A good use of mysqladmin extended-status to view the running state script for MySQL:
Mysqladmin-p3306-uroot-p-h127.0.0.1-r-i1Extended-status |awk-F"|" "begin{count=0;}"'{if ($ ~/variable_name/&& ((++count)%20 = = 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 ("|%6d%8d%7d%7d", innodb_rows_read,innodb_rows_inserted,innodb_rows_updated,innodb_rows_deleted); printf ("|%10d%11d\n", INNODB_LOR,INNODB_PHR);}}'
This address: http://www.cnblogs.com/ajiangg/p/6565748.html
Use mysqladmin extended-status to view MySQL's running status script