一、操作系统的基本状态诊断

1.1 mysqladmin
1.1.1 查看命令
mysqladmin -uroot -p'password' -S /home/mysql/data/mysqldata1/sock/mysql.sock -r -i 1 extended -c 100000
|awk -F"|" "BEGIN{ count=0; }"'{ if($2 ~ /Variable_name/ && ((++count)%20 == 1)){\
print "|---------|--- MySQL Command Status --|---- Innodb row operation ---|- Buffer Pool Read -|- thread info -
|-tmp table used-|------- cient connection -------";\
print "|---QPS---|select insert update delete|read inserted updated deleted| logical physical| running
connected| total disk| conn Aborted_cli Aborted_con";\
} else if ($2 ~ /Queries/){queries=$3;} else if ($2 ~ /Com_select /){com_select=$3;} else if ($2 ~ /Com_i