Skip to content

InnoDB Status Variables

Jump to bottom
darnaut edited this page Dec 28, 2012 · 12 revisions

Status variables that provide information about the InnoDB storage engine.

Variable Name Variable Type Variable Scope
Innodb_buffer_pool_LRU_search_scanned Numeric Global
Innodb_buffer_pool_LRU_unzip_search_scanned Numeric Global
Innodb_buffer_pool_LRU_get_free_search Numeric Global
Innodb_buffer_pool_flush_LRU_batch_scanned Numeric Global
Innodb_buffer_pool_flush_LRU_page_count Numeric Global
Innodb_buffer_pool_flush_adaptive_pages Numeric Global
Innodb_buffer_pool_flush_anticipatory_pages Numeric Global
Innodb_buffer_pool_flush_background_pages Numeric Global
Innodb_buffer_pool_flush_batch_scanned Numeric Global
Innodb_buffer_pool_flush_max_dirty_pages Numeric Global
Innodb_buffer_pool_flush_neighbor_pages Numeric Global
Innodb_buffer_pool_flush_sync_page Numeric Global
Innodb_corrupted_page_reads Numeric Global
Innodb_corrupted_table_opens Numeric Global
Innodb_files_open Numeric Global
Innodb_files_opened Numeric Global
Innodb_files_closed Numeric Global
Innodb_files_flushed Numeric Global
Innodb_lock_deadlocks Numeric Global
Innodb_lsn_current Numeric Global
Innodb_lsn_flushed Numeric Global
Innodb_lsn_checkpoint Numeric Global
Innodb_mysql_master_log_file String Global
Innodb_mysql_master_log_pos Numeric Global
Innodb_page_merges Numeric Global
Innodb_page_reorganizes Numeric Global
Innodb_page_splits Numeric Global
Innodb_tablespace_files_open Numeric Global
Innodb_tablespace_files_opened Numeric Global
Innodb_tablespace_files_closed Numeric Global

  • Innodb_buffer_pool_LRU_search_scanned

    Number of pages scanned as part of LRU search.

  • Innodb_buffer_pool_LRU_unzip_search_scanned

    Number of pages scanned as part of LRU unzip search.

  • Innodb_buffer_pool_LRU_get_free_search

    Number of searches performed for a clean page.

  • Innodb_buffer_pool_flush_LRU_batch_scanned

    Number of pages scanned as part of LRU batches.

  • Innodb_buffer_pool_flush_LRU_page_count

    Number of pages flushed as part of LRU batches.

  • Innodb_buffer_pool_flush_adaptive_pages

    Number of pages flushed as part of adaptive batches.

  • Innodb_buffer_pool_flush_anticipatory_pages

    Number of pages flushed as part of anticipatory batches.

  • Innodb_buffer_pool_flush_background_pages

    Number of pages flushed as part of background (async) batches.

  • Innodb_buffer_pool_flush_batch_scanned

    Number of pages scanned as part of a flush batch.

  • Innodb_buffer_pool_flush_max_dirty_pages

    Number of pages flushed as part of max_dirty batches.

  • Innodb_buffer_pool_flush_neighbor_pages

    Number of pages flushed as part of neighbor flush.

  • Innodb_buffer_pool_flush_sync_page

    Number of pages flushed as part of sync batches.

  • Innodb_corrupted_page_reads

    Number of corrupted pages read.

  • Innodb_corrupted_table_opens

    Number of attempts to open a table that is marked as corrupted.

  • Innodb_files_open

    Number of currently open files by InnoDB.

  • Innodb_files_opened

    Number of files opened by InnoDB.

  • Innodb_files_closed

    Number of files closed by InnoDB.

  • Innodb_files_flushed

    Number of files flushed (e.g. fsync) by InnoDB.

  • Innodb_lock_deadlocks

    Number of deadlocks that have occurred within InnoDB.

  • Innodb_lsn_current

    Current log sequence number.

  • Innodb_lsn_flushed

    How far the log has been flushed to disk.

  • Innodb_lsn_checkpoint

    Position at which InnoDB last took a checkpoint.

  • Innodb_mysql_master_log_file

    The name of the master binary log file containing the event of the most recent InnoDB transaction executed by the SQL thread. If the system tablespace does not contain the replication information, the value defaults to zero.

  • Innodb_mysql_master_log_pos

    The position in the master binary log file to which the SQL thread has read and executed an InnoDB transaction, marking the start of the next transaction or event to be processed. If the system tablespace does not contain the replication information, the value defaults to an empty string.

  • Innodb_page_merges

    Number of page merge (attempt) operations.

  • Innodb_page_reorganizes

    Number of page reorganization operations.

  • Innodb_page_splits

    Number of page split operations.

  • Innodb_tablespace_files_open

    Number of .ibd files currently open. Only relevant for multiple tablespaces.

  • Innodb_tablespace_files_opened

    Number of .ibd files opened by InnoDB. Only relevant for multiple tablespaces.

  • Innodb_tablespace_files_closed

    Number of .ibd files closed by InnoDB. Only relevant for multiple tablespaces.

Clone this wiki locally