A script to view MySQL QPS

This script paste can be used absolutely no deceptive!!!

(This script originates from a great god netizen)

Execution effect:

Script:

#!/bin/bash
[Email protected]
Mysqladmin-p3306-uroot-p$pw-r-I 1 ext |\
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 ($/queries/) {queries=$3;} \
else if ($/com_select/) {com_select=$3;} \
else if ($/com_insert/) {com_insert=$3;} \
else if ($/com_update/) {com_update=$3;} \
else if ($/com_delete/) {com_delete=$3;} \
else if ($/innodb_rows_read/) {innodb_rows_read=$3;} \
else if ($/innodb_rows_deleted/) {innodb_rows_deleted=$3;} \
else if ($/innodb_rows_inserted/) {innodb_rows_inserted=$3;} \
else if ($/innodb_rows_updated/) {innodb_rows_updated=$3;} \
else if ($/innodb_buffer_pool_read_requests/) {innodb_lor=$3;} \
else if ($/innodb_buffer_pool_reads/) {innodb_phr=$3;} \
else if ($/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);
}}‘

A script to view MySQL QPS