ronaldbradford

Pokémon: 4
4 Genesect V FST 185
3 Mew V FST 113
3 Mew VMAX FST 114
2 Meloetta FST 124

Trainer: 17
4 Battle VIP Pass FST 225
4 Cram-o-matic FST 229
4 Ultra Ball SVI 196

ronaldbradford

#!/usr/bin/env bash


error() {
  echo "ERROR: $*"
  exit 1
}

command -v aws >/dev/null 2>&1 || error "'aws' not installed"
command -v jq >/dev/null 2>&1 || error "'jq' not installed"

ronaldbradford

Pokemon Decks

Alolan Vulpix VSTAR (SIT 34)

• Vulpix Beta - 5 Mar 2023 (Fire & Dice - Bobby)
• ARCEUS VSTAR WITH FLYING PIKACHU VMAX (JustInBasil)
• ARTICUNO (JustInBasil)

About

• Water Energy

ronaldbradford

SELECT /* Host connections */ SUBSTRING_INDEX(host, ':', 1) AS host, user, COUNT(*) AS host_connections
FROM information_schema.processlist
GROUP BY SUBSTRING_INDEX(host, ':', 1), user;

SELECT /* Running connections per source/user/schema */ host,user,db,command,COUNT(*) AS running
FROM information_schema.processlist
WHERE command NOT IN ('Sleep','Daemon','Binlog Dump')
GROUP BY host, user;

SELECT /* thread counts */ variable_name, variable_value

ronaldbradford

# this Code will help to schedule stop the RDS databasrs using Lambda
# Yesh
# Version -- 2.0
# Adapted from https://aws.amazon.com/blogs/database/schedule-amazon-rds-stop-and-start-using-aws-lambda/

import boto3
import os
import sys
import time
from datetime import datetime, timezone

ronaldbradford

-- filler.lua
--
-- 1. Ensure you have a 'sysbench' user and privileges to manage objects in schema 'sysbench'. e.g.
--
--    mysql> CREATE USER sysbench@'%' IDENTIFIED BY 'RM#aEq29waQE';
--    mysql> GRANT ALL ON sysbench.* TO sysbench@'%';
--    mysql> CREATE SCHEMA sysbench;
--
-- 2. Create the filler table with:
--

ronaldbradford

# Connect to your schema first, i.e. USE <schema>

SELECT   if(length(table_name)>40,concat(left(table_name,38),'..'),table_name) AS table_name,
         engine,row_format as format, table_rows, avg_row_length as avg_row,
         round((data_length+index_length)/1024/1024,2) as total_mb,
         round((data_length)/1024/1024,2) as data_mb,
         round((index_length)/1024/1024,2) as index_mb
FROM     information_schema.tables
WHERE    table_schema=DATABASE()
ORDER BY 6 DESC;

ronaldbradford

SELECT   table_schema,
         SUM(data_length+index_length)/1024/1024 AS total_mb,
         SUM(data_length)/1024/1024 AS data_mb,
         SUM(index_length)/1024/1024 AS index_mb,
         COUNT(*) AS tables,
         CURDATE() AS today
FROM     information_schema.tables
WHERE    table_schema NOT IN ('mysql','information_schema','performance_schema','sys','_doit_statpack_mysql')
GROUP BY table_schema
ORDER BY 2 DESC;

ronaldbradford

#!/usr/bin/env bash
#set -o errexit
set -o pipefail

[ -z "${TMP_DIR}" ] && TMP_DIR=/tmp
TMP_FILE=${TMP_DIR}/binlog.txt.$$

BINLOG_ADDITIONAL_ARGS=${BINLOG_ADDITIONAL_ARGS:- -vvv --base64-output=DECODE-ROWS}
BINLOG_FILE=$1
[ -z "${BINLOG_FILE}" ] && echo "ERROR: You must specify a MySQL binary Log file" && exit 1

ronaldbradford