Description of Innodb status and Innodb status

Description of Innodb status and Innodb status

Innodb_buffer_pool_pages_data The number of pages in the Innodb buffer pool containing data, including dirty pages. The Unit is page. Innodb_buffer_pool_pages_dirty The number of dirty pages in the innodb buffer pool. The Unit is page. Innodb_buffer_pool_pages_flushed Number of page refresh requests in the innodb buffer pool. The Unit is page. Innodb_buffer_pool_pages_free Number of pages remaining in the innodb buffer pool. The Unit is page. Innodb_buffer_pool_pages_misc Currently, the innodb buffer pool is used for management purposes or hash indexes and cannot be used as the number of common data pages. The Unit is page. Innodb_buffer_pool_pages_total The total number of pages in the innodb buffer pool. The Unit is page. Innodb_buffer_pool_read_ahead Number of pages read by the backend pre-read thread to the innodb buffer pool. The Unit is page. Innodb_buffer_pool_read_ahead_evicted The number of pre-read pages that are replaced from the buffer pool if not read. This is generally used to determine the pre-Read efficiency. Innodb_buffer_pool_read_requests The number of innodb logical reads. The Unit is once. Innodb_buffer_pool_reads The number of times that a single page is read when logical reads cannot be obtained from the buffer pool. The Unit is once. Innodb_buffer_pool_wait_free Writing to the InnoDB buffer pool is usually performed in the background, but it is necessary to read or create pages when there are no clean pages, and it is necessary to wait for the page to be refreshed first. When the Innodb IO thread reads data from the data file and writes the data to the buffer pool, it needs to wait for the number of idle pages. The Unit is once. Innodb_buffer_pool_write_requests The number of times the InnoDB buffer pool is written. The Unit is once. Innodb_data_fsyncs The number of times innodb performs fsync () operations. The Unit is once. Innodb_data_pending_fsyncs Innodb currently suspends the fsync () operation. The Unit is once. Innodb_data_pending_reads The read operations currently suspended by innodb. The Unit is once. Innodb_data_pending_writes The number of write operations currently suspended by inndo. The Unit is once. Innodb_data_read Total data volume read by innodb. The Unit is byte. Innodb_data_reads Total number of innodb data reads. The Unit is once. Innodb_data_writes Total number of innodb data writes. The Unit is once. Innodb_data_written Total data volume written by innodb. The Unit is byte. Innodb_dblwr_pages_written The total number of innodb doublewrite pages. The Unit is page. Innodb_dblwr_writes Total number of doublewrites completed by innodb. The Unit is once. Innodb_log_waits Because the log cache is too small, you must wait for the number of waits caused by the write. The Unit is once. Innodb_log_write_requests Number of innodb log write requests. The Unit is once. Innodb_log_writes The total number of times innodb log buffer writes log files. The Unit is once. Innodb_ OS _log_fsyncs The total number of times that innodb log buffer performs fsync. The Unit is once. Innodb_ OS _log_pending_fsyncs The number of currently suspended fsync log files. The Unit is once. Innodb_ OS _log_pending_writes The number of currently suspended write log files. The Unit is once. Innodb_ OS _log_written The number of bytes written to the log file. The Unit is byte. Innodb_page_size Size of the compiled InnoDB page (16 KB by default ). Innodb_pages_created Total number of innodb pages. The Unit is page. Innodb_pages_read Total number of pages read by innodb. The Unit is page. Innodb_pages_written Total number of pages written by innodb. The Unit is page. Innodb_row_lock_current_waits Innodb is currently waiting for the number of row locks. The unit is. Innodb_row_lock_time Total time consumed by innodb to obtain row locks. The Unit is milliseconds. Innodb_row_lock_time_avg Average time for innodb to get the row lock wait. The Unit is milliseconds. Innodb_row_lock_time_max Maximum wait time for innodb to obtain the row lock. The Unit is milliseconds. Innodb_row_lock_waits The number of times innodb waits to obtain the row lock. The Unit is once. Innodb_rows_deleted The number of rows deleted from the innodb table. The Unit is row. Innodb_rows_inserted The number of rows inserted to the innodb table. The Unit is row. Innodb_rows_updated The number of rows updated in the innodb table. Unit: Row