Aborted_clients
The number of connections aborted because the client did not close the connection.
Aborted_connects
The number of connections that attempted to connect to the MySQL server but failed.
Binlog_cache_disk_use
The number of temporary file stores used by the temporary binary log cache for transactions that exceed binlog_cache_size settings.
Binlog_cache_use
The number of temporary binary log caches used by the office.
Connections
The number of connections attempted to connect to the MySQL server (whether successful or unsuccessful).
Created_tmp_disk_tables
The number of temporary tables that are automatically created on disk when the server executes the statement. If the created_tmp_disk_tables is large, you can increase the value of tmp_table_size so that the server uses memory to store temporary tables rather than disks.
Created_tmp_tables
The number of temporary tables that are automatically created in memory when the server executes the statement.
Handler_read_first
The number of times an index entry point was read. If the value is large, it means that your server performs many full index scans. For example, suppose that the field col1 has been indexed and then executes SELECT col1 from Foo.
Handler_read_key
The number of requests to read rows based on the index. If the value is large, your query and table are well-established indexes.
Handler_read_next
Reads the number of requests for the next row according to the index order. If you are querying an indexed field and limit the scope, or perform a full table scan, the value will grow continuously.
Handler_read_rnd
The number of requests to read rows based on a fixed location. If you perform many queries that need to be sorted, the value is high. You may have many queries that require a full table scan, or you use an incorrect index for multiple table queries.
Handler_read_rnd_next
The number of requests to read rows from the data file. If you are scanning many tables, this value will be very large. Typically this means that your table is not indexed, or that your query statement is not using a good indexed field.
Innodb_buffer_pool_bytes_data
The total number of bytes in the InnoDB buffer pool that contains the data. This number includes dirty and clean pages
Innodb_buffer_pool_reads
InnoDB the number of single-page reads that cannot be fetched from the buffer pool while the logical reads are being performed.
Innodb_log_waits
The number of waits caused by the log cache being too small to wait for it to be written.
Innodb_log_write_requests
Number of log write requests.
Innodb_row_lock_time
Total time (in milliseconds) to wait for a row lock.
Innodb_row_lock_time_avg
The average time (in milliseconds) to wait for a row lock.
Innodb_row_lock_time_max
The maximum time, in milliseconds, to wait for a row lock.
Innodb_row_lock_waits
The number of times to wait for a row lock.
Key_read_requests
The number of requests to read a key block from the cache.
Key_reads
The number of times the key block was physically read from disk. If the key_reads is large, your key_buffer_size may be set too small. The cache loss rate can be computed by key_reads/key_read_requests.
Opened_tables
The number of tables that have been opened. If the value is large, the table buffer size may be set too small.
Select_full_join
Number of multi-table queries that do not use indexes. If the value is not 0, you should carefully check whether an appropriate index has been established for the table.
Select_range_check
The number of multi-table queries used by the index, but after each row, is not used. (If the value is not 0, you should carefully check to see if an appropriate index has been established for the table.) )
Slow_launch_threads
Use more time than slow_launch_time to start the number of threads.
Slow_queries
The number of queries that were used more time than long_query_time.
Sort_merge_passes
The number of times the sorting algorithm uses merging. If the value is large, you should consider increasing the value of the system variable sort_buffer_size.
Sort_scan
The number of sort times that the scan table completed.
threads_created
The number of threads currently used to control connections. If the threads_created is large, you may need to increase the value of thread_cache_size. (This usually does not lead to significant performance gains if the thread is in good condition.) )
Threads_running
The number of threads that are not in the sleep state.
MySQL state variable (partial)
