Detailed explanation of common output fields of MySQL show status command
Aborted_clients the number of connections that have been abandoned because the customer did not close the connection correctly.
The number of times Aborted_connects has attempted a connection to the MySQL server that has failed.
The number of times Connections attempted to connect to the MySQL server.
Created_tmp_tables the number of implicit temporary tables that have been created when the statement is executed.
The number of latency insertion processor threads being used by Delayed_insert_threads.
The number of rows written by Delayed_writes in INSERT DELAYED.
The number of rows written by Delayed_errors with INSERT DELAYED for which some errors (possibly duplicate key values) have occurred.
The number of times Flush_commands executed the FLUSH command.
The number of times Handler_delete requests to delete rows from a table.
The number of times Handler_read_first requests to read the first row in the table.
The Handler_read_key request number is based on the key reading line.
The number of times Handler_read_next requests to read a row based on a key.
The number of times Handler_read_rnd requests to read a row based on a fixed location.
The number of times Handler_update requests to update a row in the table.
The number of times Handler_write requests to insert a row into the table.
The number of blocks used by Key_blocks_used for keyword caching.
The number of times Key_read_requests requests to read a key value from the cache.
The number of times Key_reads physically reads a key value from disk.
Key_write_requests requests the number of times a keyword block is written to the cache.
The number of times Key_writes physically writes a key block to disk.
The maximum number of connections used simultaneously by Max_used_connections.
Not_flushed_key_blocks keyblocks that have been changed in the key cache but have not been emptied to disk.
The number of rows that Not_flushed_delayed_rows is waiting to write in the INSERT DELAY queue.
The number of Open_tables open tables.
The number of files opened by Open_files.
Number of Open_streams open streams (mainly used for logging)
The number of tables that Opened_tables has opened.
The number of queries sent by Questions to the server.
The number of queries that Slow_queries takes longer than long_query_time time.
The number of connections currently open by Threads_connected.
The number of threads that Threads_running is not sleeping.
How many seconds did the Uptime server work?
