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
SELECT /* Host connections */ host, user, COUNT(*) AS host_connections | |
FROM information_schema.processlist | |
GROUP BY host, 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') | |
GROUP BY host, user; | |
SELECT /* thread counts */ variable_name, variable_value |
# 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 |
-- 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: | |
-- |
# 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; |
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; |
#!/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 |
mysql -u${DBA_USER} -p${DBA_PASSWD} -h ${INSTANCE_ENDPOINT} -e "SHOW ENGINE INNODB STATUS\G" | awk -f deadlock.awk
################################################################################ | |
# Name : perschema.sql | |
# Purpose : List details of the specific schema | |
# Author : Ronald Bradford http://ronaldbradford.com | |
# Version : 2 03-June-2009 | |
################################################################################ | |
SELECT NOW(), VERSION(); | |
# Per Schema Queries |