|
Here you can find the formula used.
| threadcache-hitrate |
|
100 −
|
Threads_created * 100
|
|
Connections
|
|
| querycache-hitrate |
|
Qcache_hits * 100
|
|
Qcache_hits + Com_select
|
|
| keycache-hitrate |
|
100 −
|
Key_reads * 100
|
|
Key_read_requests
|
|
| bufferpool-hitrate |
|
100 −
|
Innodb_buffer_pool_reads * 100
|
|
Innodb_buffer_pool_read_requests
|
|
| tablecache-hitrate |
|
Open_tables * 100
|
|
Opened_tables
|
|
| table-lock-contention |
|
Table_locks_waited * 100
|
|
Table_locks_waited + Table_locks_immediate
|
|
| tmp-disk-tables |
|
Created_tmp_disk_tables * 100
|
|
Created_tmp_tables
|
|
| slow-queries |
|
Slow_queries2−Slow_queries1
|
|
t2 − t1
|
|
| qcache-lowmem-prunes |
|
Qcache_lowmem_prunes2−Qcache_lowmem_prunes1
|
|
t2 − t1
|
|
| bufferpool-wait-free |
|
Innodb_buffer_pool_wait_free2−Innodb_buffer_pool_wait_free1
|
|
t2 − t1
|
|
| log-waits |
|
Innodb_log_waits2−Innodb_log_waits1
|
|
t2 − t1
|
|
|
Open Source 
Back