# 网上不知道哪位大神写的
mysqladmin -P3306 -uroot  -p123456 -h localhost -r -i 1 extended-status |awk -F "|" 'BEGIN { count=0; } { if($2 ~ /Variable_name/ && ++count%15 == 1){print "----------|---------|--- MySQL Command Status --|----- Innodb row operation -----|-- Buffer Pool Read --";    print "---Time---|---QPS---|select insert update delete|   read inserted updated deleted|   logical    physical";} else if ($2 ~ /Queries/){queries=$3;} else if ($2 ~ /Com_select /){com_select=$3;} else if ($2 ~ /Com_insert /){com_insert=$3;} else if ($2 ~ /Com_update /){com_update=$3;} else if ($2 ~ /Com_delete /){com_delete=$3;} else if ($2 ~ /Innodb_rows_read/){innodb_rows_read=$3;} else if ($2 ~ /Innodb_rows_deleted/){innodb_rows_deleted=$3;} else if ($2 ~ /Innodb_rows_inserted/){innodb_rows_inserted=$3;} else if ($2 ~ /Innodb_rows_updated/){innodb_rows_updated=$3;} else if ($2 ~ /Innodb_buffer_pool_read_requests/){innodb_lor=$3;} else if ($2 ~ /Innodb_buffer_pool_reads/){innodb_phr=$3;} else if ($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);}}'


#结果如下
#----------|---------|--- MySQL Command Status --|----- Innodb row operation -----|-- Buffer Pool Read --
#---Time---|---QPS---|select insert update delete|   read inserted updated deleted|   logical    physical
# 14:40:04 |       20|    18      0      0      0|  604692       0       0       0|   1072507           0
# 14:40:05 |        4|     2      0      0      0|  162419       0       0       0|    502387           0
# 14:40:06 |       67|    58      0      0      0|  921068       0       0       0|   1295338           0
# 14:40:06 |        5|     2      0      0      0|  641752       0       0       0|   1989167           0
# 14:40:08 |      118|   108      0      0      0|  561479       0       0       0|    826064           0
# 14:40:09 |        5|     2      0      0      0|  279322       0       0       0|    836263           0
# 14:40:10 |       16|    11      0      0      0|   66143       0       0       0|    129985           0
