查看QPS、各种SQL执行频率、SQL操作的rows等

mysqladmin -h127.0.0.1 -P20140 -r -i 2 extended-status |awk -F "|" 'BEGIN { count=0; } { if(2 ~ /Queries/){queries=2 ~ /Com_select /){com_select=2 ~ /Com_insert /){com_insert=2 ~ /Com_update /){com_update=2 ~ /Com_delete /){com_delete=2 ~ /Innodb_rows_read/){innodb_rows_read=2 ~ /Innodb_rows_deleted/){innodb_rows_deleted=2 ~ /Innodb_rows_inserted/){innodb_rows_inserted=2 ~ /Innodb_rows_updated/){innodb_rows_updated=2 ~ /Innodb_buffer_pool_read_requests/){innodb_lor=2 ~ /Innodb_buffer_pool_reads/){innodb_phr=2 ~ /Uptime / && count >= 2){ printf(" %s |%9d",strftime("%H:%M:%S"),queries);printf("|%6d %6d %6d %6d",com_select,com_insert,com_update,com_delete);printf("|%8d %7d %7d %7d",innodb_rows_read,innodb_rows_inserted,innodb_rows_updated,innodb_rows_deleted); printf("|%10d %11d\n",innodb_lor,innodb_phr);}}'