As follows:
#!/bin/SHmysqladmin-p3306-uroot-p'Password'-r-i1ext |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);}}'
The output is as follows:
This script mainly takes advantage of the functionality provided by Mysqladmin
-R,--relative Show difference between current and previous values when-I. Currently only works with Ext Ended-status.
Extended-status Gives an extended status message from the server
EXT is the abbreviation of Extended-status ~
A simple MySQL performance query script