MySQL run status Show status Chinese detailed

Source: Internet
Author: User
Tags joins savepoint ssl connection

To see the MySQL running state, to optimize the efficiency of MySQL running is not only to run show status to view the various states, the following is the official documents and online information compiled in Chinese detailed explanation:

Status name Scope Detailed explanation
Aborted_clients Global The number of connections that were interrupted due to client termination because the client did not close the connection properly
Aborted_connects Global The number of connections that failed while attempting to connect to the MySQL server
Binlog_cache_disk_use Global The number of transactions that use the temporary binary log cache but exceed the Binlog_cache_size value and use temporary files to hold statements in the transaction
Binlog_cache_use Global Number of transactions using the staging binary log cache
Bytes_received Both The number of bytes received from all clients.
Bytes_sent Both The number of bytes sent to all clients.
com* The number of various database operations
Compression Session No compression protocol enabled between client and server
Connections Global The number of connections to the MySQL server that you are trying to connect to (regardless of success)
Created_tmp_disk_tables Both The number of temporary tables that are automatically created on the hard disk when the server executes the statement
Created_tmp_files Global Mysqld the number of temporary files that have been created
Created_tmp_tables Both The number of temporary tables in memory that are automatically created when the server executes the statement. If the created_tmp_disk_tables is larger, you may want to increase the tmp_table_size value to make the temp table memory-based and not disk-based
Delayed_errors Global The number of rows in the error that were written with the insert delayed (possibly duplicate key).
Delayed_insert_threads Global The number of insert delayed processor threads used.
Delayed_writes Global Number of insert delayed lines written
Flush_commands Global The number of flush statements executed.
Handler_commit Both Number of internal commit statements
Handler_delete Both The number of times the row was deleted from the table.
Handler_discover Both The MySQL server can ask NDB cluster if the storage engine knows the table of a certain name. This is called discovery. Handler_discover describes the number of times that this method was discovered.
Handler_prepare Both A counter for the prepare phase of two-phase commit operations.
Handler_read_first Both The number of times the first bar in the index was read. If it is high, it is recommended that the server is performing a large number of full-index scans; for example, SELECT col1 from Foo, assuming col1 has an index.
Handler_read_key Both The number of requests to read a row by key. If it is high, the index of the query and table is correct.
Handler_read_next Both Reads the number of requests for the next line in key order. This value increases if you query an index column with a range constraint or if an index scan is performed.
Handler_read_prev Both The number of requests to read the previous line in the key order. This reading method is mainly used to optimize the order by ... DESC.
Handler_read_rnd Both The number of requests to read a row based on a fixed location. This value is higher if you are executing a large number of queries and need to sort the results. You may have used a large number of queries that require MySQL to scan the entire table or your connection did not use the keys correctly.
Handler_read_rnd_next Both The number of requests to read the next line in the data file. If you are doing a large number of table scans, this value is higher. It is usually indicated that your table index is incorrect or the query being written does not take advantage of the index.
Handler_rollback Both The number of internal rollback statements.
Handler_savepoint Both The number of requests to place a savepoint in a storage engine.
Handler_savepoint_rollback Both The requirement for a storage engine to roll back to a savepoint number.
Handler_update Both The number of requests to update a row within a table.
Handler_write Both The number of requests to insert a row within the table.
Innodb_buffer_pool_pages_data Global The number of pages that contain data (dirty or clean).
Innodb_buffer_pool_pages_dirty Global The current number of dirty pages.
Innodb_buffer_pool_pages_flushed Global Number of buffer pool pages required to be emptied
Innodb_buffer_pool_pages_free Global Empty pages.
Innodb_buffer_pool_pages_latched Global Number of pages locked in the InnoDB buffer pool. This is the number of pages that are currently being read or written or cannot be emptied or deleted for other reasons.
Innodb_buffer_pool_pages_misc Global The number of pages that are busy, because they have been assigned precedence for administration, such as row locking or applicable hash indexes. The value can also be calculated as Innodb_buffer_pool_pages_total–innodb_buffer_pool_pages_free–innodb_buffer_pool_pages_data.
Innodb_buffer_pool_pages_total Global Total buffer pool size (pages).
Innodb_buffer_pool_read_ahead_rnd Global InnoDB the number of "random" read-aheads initialized. Occurs when the query scans a large part of a table in a random order.
Innodb_buffer_pool_read_ahead_seq Global InnoDB the number of sequential read-aheads initialized. Occurs when InnoDB performs a sequential full-table scan.
Innodb_buffer_pool_read_requests Global InnoDB the number of logical read requests that have been completed.
Innodb_buffer_pool_reads Global The number of logical reads in the buffer pool that InnoDB must read in a single page cannot be satisfied.
Innodb_buffer_pool_wait_free Global In general, write to the InnoDB buffer pool through the background. However, if you need to read or create a page, and there is no clean page available, it also needs to wait for the page to empty first. The counter counts the waiting instance. If the buffer pool size is already set appropriately, the value should be small.
Innodb_buffer_pool_write_requests Global The number of writes to the InnoDB buffer pool.
Innodb_data_fsyncs Global The number of Fsync () operands.
Innodb_data_pending_fsyncs Global The number of Fsync () operands currently pending.
Innodb_data_pending_reads Global The current pending reading.
Innodb_data_pending_writes Global The current number of pending writes.
Innodb_data_read Global The number of data (bytes) that have been read at this point.
Innodb_data_reads Global The total number of data reads.
Innodb_data_writes Global Total number of data writes.
Innodb_data_written Global The amount of data (bytes) that has been written to this point.
Innodb_dblwr_pages_written Global Number of double write operations that have been performed
Innodb_dblwr_writes Global Number of pages that have been written for double write operations
Innodb_log_waits Global We have to wait for the time because the log buffer is too small, we must wait for it to clear before continuing
Innodb_log_write_requests Global Number of log write requests.
Innodb_log_writes Global The number of physical writes to the log file.
Innodb_os_log_fsyncs Global The number of Fsync () writes completed to the log file.
Innodb_os_log_pending_fsyncs Global The number of pending log file Fsync () operations.
Innodb_os_log_pending_writes Global Pending log File Write operations
Innodb_os_log_written Global The number of bytes written to the log file.
Innodb_page_size Global The compiled InnoDB page size (default 16KB). Many values are counted in pages, and the size of the page is easily converted to bytes.
innodb_pages_created Global Number of pages created.
Innodb_pages_read Global The number of pages read.
Innodb_pages_written Global Number of pages written.
Innodb_row_lock_current_waits Global The number of rows currently waiting to be locked.
Innodb_row_lock_time Global The total time, in milliseconds, that the row lock takes.
Innodb_row_lock_time_avg Global The average time, in milliseconds, that the row is locked.
Innodb_row_lock_time_max Global The maximum time, in milliseconds, that a row is locked.
Innodb_row_lock_waits Global The number of times a row lock must wait.
innodb_rows_deleted Global The number of rows deleted from the InnoDB table.
innodb_rows_inserted Global The number of rows inserted into the InnoDB table.
Innodb_rows_read Global The number of rows read from the InnoDB table.
innodb_rows_updated Global The number of rows updated in the InnoDB table.
Key_blocks_not_flushed Global The number of data blocks in the key cache that have been changed but have not yet been emptied to the hard disk.
Key_blocks_unused Global The number of unused blocks in the key cache. You can use this value to determine how many key caches are used
Key_blocks_used Global The number of blocks used within the key cache. The value is a high-level line marker that shows how many blocks have been used at the same time.
Key_read_requests Globalp> The number of requests from the cache of data blocks that read the key.
Key_reads Global The number of times the key's data block was read from the hard disk. If the key_reads is large, the Key_buffer_size value may be too small. You can calculate the cache loss rate with key_reads/key_read_requests.
Key_write_requests Global The number of requests to write the key's data block to the cache.
Key_writes Global The number of times the physical write operation of the data block to which the key was written to the hard disk.
Last_query_cost Session The total cost of the last compiled query computed with the query optimizer. Used to compare the cost of different query scenarios for the same query. The default value of 0 indicates that the query has not been compiled. The default value is 0. Last_query_cost has a session scope.
Max_used_connections Global The maximum number of connections that have been used at the same time since the server started.
ndb* NDB Cluster Related
Not_flushed_delayed_rows Global The number of rows waiting to be written to the Insert delay queue.
Open_files Global The number of open files.
Open_streams Global The number of open streams (primarily for logging).
Open_table_definitions Global Number of cached. frm files
Open_tables Both The number of tables currently open.
Opened_files Global The number of open files. Other types of files, such as sockets or pipes, are not included. It does not include files that the storage engine uses to do its own internal functions.
Opened_table_definitions Both Number of. frm files that have been cached
Opened_tables Both The number of tables that have been opened. If the opened_tables is larger, the Table_cache value may be too small.
Prepared_stmt_count Global The number of current preprocessing statements. (Maximum number is System variable: max_prepared_stmt_count)
Qcache_free_blocks Global The number of free memory blocks within the query cache.
Qcache_free_memory Global The amount of free memory used to query the cache.
Qcache_hits Global The number of times the query cache was accessed.
Qcache_inserts Global Number of queries added to the cache.
Qcache_lowmem_prunes Global The number of queries deleted from the cache because of less memory.
Qcache_not_cached Global Number of non-cached queries (not cacheable, or because the Query_cache_type setpoint is not cached).
Qcache_queries_in_cache Global The number of queries registered in the cache.
Qcache_total_blocks Global The total number of blocks in the query cache.
Queries Both The number of requests that the server executes, including requests in the stored procedure.
Questions Both The number of queries that have been sent to the server.
Rpl_status Global Failed security replication status (not yet used).
Select_full_join Both The number of joins that do not use an index. If the value is not 0, you should double-check the index of the table
Select_full_range_join Both The number of joins that use a range search in the referenced table.
Select_range Both The number of joins that use a range in the first table. The general situation is not a critical issue, even if the value is quite large.
Select_range_check Both The number of joins without a key value that are checked for key values after each row of data. If it is not 0, you should carefully check the index of the table.
Select_scan Both The number of joins that perform a full scan of the first table.
Slave_heartbeat_period Global The heartbeat interval for replication
Slave_open_temp_tables Global Number of temporary tables opened from the server
Slave_received_heartbeats Global Number of heartbeats from the server
Slave_retried_transactions Global Thread attempts to copy lines from the server since this startup
Slave_running Global If the server is a slave server that is connected to the primary server, the value is on.
Slow_launch_threads Both The number of threads that have been created longer than slow_launch_time seconds.
Slow_queries Both The number of queries that have been queried for more than long_query_time seconds.
Sort_merge_passes Both The number of merges that the sorting algorithm has performed. If the value of this variable is large, you should consider increasing the value of the sort_buffer_size system variable.
Sort_range Both The number of orders performed within the range.
Sort_rows Both The number of rows that have been sorted.
Sort_scan Both The number of sorting completed by the scan table.
ssl* SSL connection Related
Table_locks_immediate Global The number of times the table's locks are immediately obtained.
table_locks_waited Global The number of locks on the table that cannot be obtained immediately. If the value is high and there is a performance problem, you should first refine the query and then split the table or use replication.
Threads_cached Global The number of threads within the thread cache.
threads_connected Global The number of connections currently open.
threads_created Global Creates the number of threads used to process the connection. If the threads_created is larger, you may want to increase the thread_cache_size value. The method of calculating the cache access rate is threads_created/connections.
Threads_running Global The number of active (non-sleep-state) threads.
Uptime Global The time, in seconds, that the server has been running.
Uptime_since_flush_status Global The last time the flush STATUS was used (in seconds).

MySQL run status Show status Chinese (GO)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.