FiveFeet

All the following is found at Command-Line-Fu.

Compare mysql db schema from two different servers
diff <(mysqldump -hsystem db_name --no-data --routines) <(mysqldump -hsystem2 db_name --no-data --routines) --side-by-side --suppress-common-lines --width=690 | more

check mysql server performance
mysqlslap --query=/home/ec2-user/insert.txt --concurrency=123 --iterations=1 --create-schema=test

Extract queries from mysql general log
grep -Eo '( *[^ ]* *){4}Invoice_Template( *[^ ]* *){4}' /mysql-bin-log/mysql-gen.log | head -10000 | sort -u

check mysql capacity to handle traffic
mysqlslap --query=/root/select_query_cp.sql --concurrency=10 --iterations=5 --create-schema=cvts1

mysql backup utility
mysqlbackup --port=3306 --protocol=tcp --user=dba --password=dba --with-timestamp --backup-dir=/tmp/toback/ --slave-info backup-and-apply-log --innodb_data_file_path=ibdata1:10M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=5242880

InnoDB related parameters
mysqladmin variables | egrep '(innodb_log_file|innodb_data_file)'

mysql status
mysqladmin status >> /home/status.txt 2>> /home/status_err.txt

Linux system calls of MySQL process
strace -c -p $(pidof -s mysqld) -f -e trace=all