Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.