What is the introduction of Monyog?
This article shows you what the introduction of Monyog is, which is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.
1. The powerful tool can directly locate what the sql statement is doing.
Mysql log
Can MONyog read the MySQL error log?
New entry in the error log?
The most recently entered type is [ERROR]
Slow log-enabled?
The execution time of the query is considered to be very slow, the number of times of query log query does not use index?
General Log-enabled?
Log warning?
Log destination
Wait, etc.
What metrics should be monitored in Mysql performance testing
1. Get the total number of processes under MySQL users
Ps-ef | awk'{print $1}'| grep "mysql" | grep-v "grep" | wc-1
Second, host performance status
# uptime
[root@ ~] # uptime
13:05:52 up 53 days, 52 min, 1 user, load average: 0.00, 0.00, 0.00
Third, CPU utilization rate
# top
Or
# vmstat
Fourth, disk IO quantity
# vmstat or # iostat
Fifth, swap in and out [memory]
# free
Sixth, database performance status
(1) QPS (number of queries per second)
QPS = Questions (or Queries) / seconds
Mysql > show / * 50000 global * / status like 'Question'
(2) TPS (transactions per second)
TPS = (Com_commit + Com_rollback) / seconds
Mysql > show status like 'Com_commit'
Mysql > show status like 'Com_rollback'
(3) key Buffer hit rate
Key_buffer_read_hits = (1-key_reads / key_read_requests) * 100%
Key_buffer_write_hits = (1-key_writes / key_write_requests) * 100%
Mysql > show status like 'Key%'
(4) InnoDB Buffer hit rate
Innodb_buffer_read_hits = (1-innodb_buffer_pool_reads / innodb_buffer_pool_read_requests) * 100%
Mysql > show status like 'innodb_buffer_pool_read%'
(5) Query Cache hit rate
Query_cache_hits = (Qcahce_hits / (Qcache_hits + Qcache_inserts)) * 100%
Mysql > show status like 'Qcache%'
(6) Table Cache state quantity
Mysql > show status like 'open%'
(7) Thread Cache hit rate
Thread_cache_hits = (1-Threads_created / connections) * 100%
Mysql > show status like 'Thread%'
Mysql > show status like 'Connections'
(8) locked statu
Mysql > show status like'% lock%'
(9) replication delay
Mysql > show slave status
(10) Tmp Table status (temporary table status)
Mysql > show status like 'Create_tmp%'
(11) Binlog Cache usage
Mysql > show status like 'Binlog_cache%'
(12) Innodb_log_waits quantity
Mysql > show status like 'innodb_log_waits'
The above is what the introduction of Monyog is like. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.
