#!/bin/bash### #该脚本用于 mysqladmin Output real-time qps information frequency of 1 s#### example#### sh mysql_status.sh 10.0.0.7 3306#### sh status.sh 10.0.0.8 3306mysqladmin -p$2 -uhooduser -p ' xxxx ' -h$1 -r -i 1 ext |awk -f "|" "BEGIN{ COUNT=0; }" ' { if ($2 ~ /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 article is from the "Hanchengway" blog, make sure to keep this source http://hanchengway.blog.51cto.com/10974268/1883369
Mysqladmin awk monitoring MySQL QPS