InnoDB Status Variables

Liang G edited this page Jun 21, 2013 · 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_buffer_pool_flush_async_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_ibuf_discarded_delete_marks Numeric Global
Innodb_ibuf_discarded_deletes Numeric Global
Innodb_ibuf_discarded_inserts Numeric Global
Innodb_ibuf_merged_delete_marks Numeric Global
Innodb_ibuf_merged_deletes Numeric Global
Innodb_ibuf_merged_inserts Numeric Global
Innodb_ibuf_merged_pages Numeric Global
Innodb_ibuf_pages 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_discard Numeric Global
Innodb_page_merges Numeric Global
Innodb_page_merges_succeeded Numeric Global
Innodb_page_reorganizes Numeric Global
Innodb_page_splits Numeric Global
Innodb_purge_trx_no Numeric Global
Innodb_purge_undo_no Numeric Global
Innodb_rows_search_btree_index Numeric Global
Innodb_rows_search_hash_index Numeric Global
Innodb_semaphore_stalls Numeric Global
Innodb_tablespace_files_open Numeric Global
Innodb_tablespace_files_opened Numeric Global
Innodb_tablespace_files_closed Numeric Global
Innodb_trx_max_id Numeric Global
Innodb_thread_concurrency_active Numeric Global
Innodb_thread_concurrency_waiting 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_buffer_pool_flush_async_page

    Number of pages flushed as part of async 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_ibuf_discarded_delete_marks

    Number of discarded buffered delete mark operations.

  • Innodb_ibuf_discarded_deletes

    Number of discarded buffered delete operations.

  • Innodb_ibuf_discarded_inserts

    Number of discarded buffered delete operations.

  • Innodb_ibuf_merged_delete_marks

    Number of delete mark operations merged.

  • Innodb_ibuf_merged_deletes

    Number of delete operations merged.

  • Innodb_ibuf_merged_inserts

    Number of insert operations merged.

  • Innodb_ibuf_merged_pages

    Number of index pages that absorbed buffered changes.

  • Innodb_ibuf_pages

    The current size (in pages) of the ibuf tree.

  • 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_discard

    Number of page discard operations. Also represents the number of pages that have become empty and were thus discarded.

  • Innodb_page_merges

    Number of page merge (attempt) operations.

  • Innodb_page_merges_succeeded

    Number of successful page merge operations.

  • Innodb_page_reorganizes

    Number of page reorganization operations.

  • Innodb_page_splits

    Number of page split operations.

  • Innodb_purge_trx_no

    The maximum transaction ID for which records have been (or are being) purged.

  • Innodb_purge_undo_no

    The maximum undo log record number for which records have been (or are being) purged.

  • Innodb_rows_search_btree_index

    Number of B+-tree index key searches.

  • Innodb_rows_search_hash_index

    Number of adaptive hash index key searches.

  • Innodb_semaphore_stalls

    Number of detected semaphore stalls (e.g. long semaphore wait).

  • 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.

  • Innodb_trx_max_id

    The smallest number not yet assigned as a transaction ID.

  • Innodb_thread_concurrency_active

    The number of active threads in InnoDB thread concurrency FIFO queue.

  • Innodb_thread_concurrency_waiting

    The number of waiting threads in InnoDB thread concurrency FIFO queue.