How to monitor SQL status and hit rate by MySQL
This article mainly explains "how MySQL monitors SQL status and hit rate". Friends who are interested may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how MySQL monitors SQL status and hit rate".
[root@hank-yoon scrips] # vi mysqlstat.sh
/ export/servers/mysql/bin/mysqladmin-P3306-uyoon-pyoon-h227.0.0.1-r-I 2 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 ("| d\ n", innodb_lor,innodb_phr);\
}'
[root@hank-yoon scrips] # sh mysqlstat.sh
Warning: Using a password on the command line interface can be 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 | 00 | 00 | 00 | 00
17:00:37 | 1 | 00 | 00 | 00 | 00
17:00:39 | 1 | 00 | 00 | 00 | 00
17:00:41 | 1 | 00 | 00 | 00 | 00
17:00:43 | 1 | 00 | 00 | 00 | 00
17:00:45 | 1 | 00 | 00 | 00 | 00
17:00:45 | 1 | 00 | 00 | 00 | 00
17:00:49 | 1 | 00 | 00 | 00 | 00
17:00:51 | 1 | 00 | 00 | 00 | 00
17:00:53 | 1 | 00 | 00 | 00 | 00
17:00:55 | 1 | 00 | 00 | 00 | 00
17:00:57 | 1 | 00 | 00 | 00 | 00
At this point, I believe you have a deeper understanding of "how MySQL monitors the status and hit rate of SQL". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!
