Partial interpretation of the INNODB state

Innodb_buffer_pool_pages_data Innodb the number of pages in the buffer pool that contain data, including dirty pages. Unit is page. Innodb_buffer_pool_pages_dirty InnoDB the number of dirty pages in the buffer pool cache. Unit is page. Innodb_buffer_pool_pages_flushed InnoDB the number of page requests that are refreshed in the buffer pool cache pools. Unit is page. Innodb_buffer_pool_pages_free InnoDB the number of pages remaining in the buffer pool. Unit is page. Innodb_buffer_pool_pages_misc The number of InnoDB buffer pool buffers that are currently used for administrative purposes or hash index and cannot be used as normal data pages. Unit is page. Innodb_buffer_pool_pages_total InnoDB the total number of pages in the buffer pool. Unit is page. Innodb_buffer_pool_read_ahead The number of pages that the backend read-ahead thread reads to InnoDB buffer pool. Unit is page. innodb_buffer_pool_read_ahead_evicted The number of pages that are read-ahead, but not being read from the buffer pool, is generally used to determine the efficiency of the read-ahead. Innodb_buffer_pool_read_requests InnoDB the number of logical reads. Unit is the second. Innodb_buffer_pool_reads The number of single-page reads that cannot be fetched from the buffer pool while performing a logical read. Unit is the second. Innodb_buffer_pool_wait_free Writing to the InnoDB buffer pool is usually done in the background, but it is necessary to read or create the page when there is no clean page, it is necessary to wait for the page to be refreshed first. The InnoDB IO thread reads from the data file the number of times a free page waits for the data to be written to the buffer pool. Unit is the second. Innodb_buffer_pool_write_requests The number of times the InnoDB buffer pool was written. Unit is the second. Innodb_data_fsyncs InnoDB the number of Fsync () operations performed. Unit is the second. Innodb_data_pending_fsyncs InnoDB the number of Fsync () operations currently pending. Unit is the second. Innodb_data_pending_reads InnoDB the current number of pending read operations. Unit is the second. Innodb_data_pending_writes Inndo the number of write operations currently pending. Unit is the second. Innodb_data_read The total amount of data read by the InnoDB. Units are bytes. Innodb_data_reads InnoDB the total number of data reads. Unit is the second. Innodb_data_writes InnoDB the total number of data writes. Unit is the second. Innodb_data_written The total amount of data written by the InnoDB. Units are bytes. Innodb_dblwr_pages_written InnoDB the total number of pages that have been completed for Doublewrite. Unit is page. Innodb_dblwr_writes InnoDB the total number of doublewrite that have been completed. Unit is the second. Innodb_log_waits The number of waits caused by the log cache being too small to wait for it to be written. Unit is the second. Innodb_log_write_requests InnoDB the number of log write requests. Unit is the second. Innodb_log_writes InnoDB Log Buffer The total number of times the log file was written. Unit is the second. Innodb_os_log_fsyncs InnoDB Log Buffer The total number of fsync (). Unit is the second. Innodb_os_log_pending_fsyncs The number of Fsync log files that are currently pending. Unit is the second. Innodb_os_log_pending_writes The number of currently pending write log file. Unit is the second. Innodb_os_log_written The number of bytes written to the log file. Units are bytes. Innodb_page_size The compiled InnoDB page size (default 16KB). innodb_pages_created InnoDB total number of pages. Unit is page. Innodb_pages_read InnoDB total number of pages read. Unit is page. Innodb_pages_written InnoDB total number of pages written. Unit is page. Innodb_row_lock_current_waits InnoDB is currently waiting for the number of row locks. Unit is a. Innodb_row_lock_time InnoDB gets the total consumption time of the row lock. The unit is in milliseconds. Innodb_row_lock_time_avg InnoDB gets the average time for row lock waits. The unit is in milliseconds. Innodb_row_lock_time_max InnoDB gets the maximum wait time for a row lock. The unit is in milliseconds. Innodb_row_lock_waits InnoDB the number of times a row lock is waiting to be acquired. Unit is the second. innodb_rows_deleted The number of rows removed from the InnoDB table. Units are rows. innodb_rows_inserted The number of rows inserted into the InnoDB table. Units are rows. innodb_rows_updated The number of rows updated in the InnoDB table. Unit is line

Partial interpretation of the INNODB state