[Email protected] scrips]# VI mysqlstat.sh
?
?? /export/servers/mysql/bin/mysqladmin-p3306-uyoon-pyoon-h127.0.0.1-r-I 2 ext |\
awk-f "|" \
"begin{count=0;}" \
' {if ($ ~/variable_name/&& ((++count)%20 = = 1)} {\
print "----------|---------|---MySQL Command Status--|-----Innodb row operation----|--Buffer Pool Read--"; \< /c4>
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);
}} '
?
? [Email protected] scrips]# sh mysqlstat.sh
Warning:using a password on the command line interface can is insecure.
----------|---------|---MySQL Command Status--|-----Innodb row operation----|--Buffer Pool Read--
---time---|---QPS---|select insert update delete| Read inserted updated deleted| Logical physical
17:00:35 | 1| 0 0 0 0| 0 0 0 0| 0 0
17:00:37 | 1| 0 0 0 0| 0 0 0 0| 0 0
17:00:39 | 1| 0 0 0 0| 0 0 0 0| 0 0
17:00:41 | 1| 0 0 0 0| 0 0 0 0| 0 0
17:00:43 | 1| 0 0 0 0| 0 0 0 0| 0 0
17:00:45 | 1| 0 0 0 0| 0 0 0 0| 0 0
17:00:45 | 1| 0 0 0 0| 0 0 0 0| 0 0
17:00:49 | 1| 0 0 0 0| 0 0 0 0| 0 0
17:00:51 | 1| 0 0 0 0| 0 0 0 0| 0 0
17:00:53 | 1| 0 0 0 0| 0 0 0 0| 0 0
17:00:55 | 1| 0 0 0 0| 0 0 0 0| 0 0
17:00:57 | 1| 0 0 0 0| 0 0 0 0| 0 0
?
??
MySQL monitor SQL and hit rate script