MYSQL Global stat

(reports from MySQL)
TEE mysql_stats.txt
show global variables;
show full processlist;
show engine innodb status\G
show global status;
SELECT 'Pausing 5 minutes to allow this' as 'Run the OS statistics reports, now.';
SELECT sleep(300);
show full processlist;
show engine innodb status\G
show global status;
NOTEE

(reports from the operating system. execute these while the MySQL reports are paused)
script os_stats.txt
set -x
vmstat 3 30
iostat -xcd 3 30
cat /proc/meminfo
df -h
mount
pvdisplay
vgdisplay
lvdisplay
top -b -n 3 -d 30
exit

-------------------------------------------------------------------------



mysqldump -u yourlogin -p --no-data --routines --triggers --events database_name_here > schema.txt

SHOW TABLE STATUS