Queries | mysql.global_status.queries.count | The number of queries executed by this server | Count |
Slow Queries | mysql.global_status.slow_queries.count | The number of queries that have taken more than long_query_time seconds. This counter increments regardless of whether the slow query log is enabled. For information about that log, see Section 5.4.5, “The Slow Query Log”. | Count |
Table Locks Waited | mysql.global_status.table_locks_waited.count | The number of times that a request for a table lock could not be granted immediately and a wait was needed. If this is high and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication. | Count |
Table Locks Immediate | mysql.global_status.table_locks_immediate.count | The number of times that a request for a table lock could be granted immediately. | Count |
Current Connections | mysql.global_status.current_connections | The number of currently open connections. | Count |
Threads Running | mysql.global_status.threads_running | The number of threads that are not sleeping. | Count |
Innodb Buffer Pool Pages Data | mysql.global_status.innodb_buffer_pool_pages_data | The number of pages in the InnoDB buffer pool containing data. The number includes both dirty and clean pages. When using compressed tables, the reported Innodb_buffer_pool_pages_data value may be larger than Innodb_buffer_pool_pages_total | Count |
Innodb Buffer Pool Pages Dirty | mysql.global_status.innodb_buffer_pool_pages_dirty | The current number of dirty pages in the InnoDB buffer pool. | Count |
Innodb Buffer Pool Pages Free | mysql.global_status.innodb_buffer_pool_pages_free | The number of free pages in the InnoDB buffer pool. | Count |
Innodb Buffer Pool Pages Total | mysql.global_status.innodb_buffer_pool_pages_total | The total size of the InnoDB buffer pool, in pages. When using compressed tables, the reported Innodb_buffer_pool_pages_data value may be larger than Innodb_buffer_pool_pages_total | Count |
Innodb Data Reads | mysql.global_status.innodb_data_reads.count | The total number of data reads (OS file reads). | Count |
Innodb Data Writes | mysql.global_status.innodb_data_writes.count | The total number of data writes. | Count |
Innodb Data Read | mysql.global_status.innodb_data_read.count | The total amount of data read from files. | Byte |
Innodb Data Written | mysql.global_status.innodb_data_written.count | The total amount of data written. | Byte |