See Server Status Variables for a complete list of status variables that can be viewed with SHOW STATUS.
Much of the InnoDB information here can also be seen with a SHOW ENGINE INNODB STATUS statement.
See also the Full list of MariaDB options, system and status variables.
Innodb_adaptive_hash_cellsDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Data Type: numeric
Introduced:
Removed:
Innodb_adaptive_hash_hash_searchesDescription: Hash searches as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
Before the variable was introduced in , use the adaptive_hash_searches counter in the table instead.
Scope: Global
Innodb_adaptive_hash_heap_buffersDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_adaptive_hash_non_hash_searchesDescription: Non-hash searches as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output. From , not updated if is not enabled (the default).
In , , , and , this status variable is not present. Use the adaptive_hash_searches_btree counter in the table instead.
From , this status variable is present.
Innodb_async_reads_pendingDescription: Number of async read I/O operations currently in progress (from SUBMITTED to COMPLETED). See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_async_reads_queue_sizeDescription: Current size of the async I/O read queue. See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_async_reads_tasks_runningDescription: Number of async read I/O operations currently in the EXECUTING_COMPLETION_TASK state. See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_async_reads_total_countDescription: Total number of async read completion tasks that have finished execution. See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_async_reads_total_enqueuesDescription: Total number of async read operations that were queued. Includes those still waiting and making up . See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_async_reads_wait_slot_secDescription: Total wait time for a free I/O slot (see Waiting for IO Slots). See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_async_writes_pendingDescription: Number of async write I/O operations currently in progress (from SUBMITTED to COMPLETED). See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_async_writes_queue_sizeDescription: Current size of the async I/O write queue. See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_async_writes_tasks_runningDescription: Number of async write I/O operations currently in the EXECUTING_COMPLETION_TASK state. See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_async_writes_total_countDescription: Total number of async write completion tasks that have finished execution. See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_async_writes_total_enqueuesDescription: Total number of async write operations that were queued. Includes those still waiting and making up . See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_async_writes_wait_slot_secDescription: See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_available_undo_logsDescription: Total number available InnoDB . Differs from the system variable, which specifies the number of active undo logs.
Scope: Global
Data Type: numeric
Innodb_background_log_syncDescription: As shown in the BACKGROUND THREAD section of the output.
In , this status variable is present in XtraDB.
In , , , and , this status variable is not present.
In
Innodb_buffer_pool_bytes_dataDescription: Number of bytes contained in the , both dirty (modified) and clean (unmodified). See also , which can contain pages of different sizes in the case of compression.
Scope: Global
Data Type: numeric
Innodb_buffer_pool_bytes_dirtyDescription: Number of dirty (modified) bytes contained in the . See also , which can contain pages of different sizes in the case of compression.
Scope: Global
Data Type: numeric
Innodb_buffer_pool_dump_statusDescription: A text description of the progress or final status of the last Innodb buffer pool dump.
Scope: Global
Data Type: string
Introduced:
Innodb_buffer_pool_load_incompleteDescription: Whether or not the loaded buffer pool is incomplete, for example after a shutdown or abort during innodb buffer pool load from file caused an incomplete save.
Scope: Global
Data Type: boolean
Introduced:
Innodb_buffer_pool_load_statusDescription: A text description of the progress or final status of the last Innodb buffer pool load.
Scope: Global
Data Type: string
Introduced:
Innodb_buffer_pool_pages_dataDescription: Number of pages which contain data, both dirty (modified) and clean (unmodified). See also .
Scope: Global
Data Type: numeric
Innodb_buffer_pool_pages_dirtyDescription: Number of pages which contain dirty (modified) data. See also .
Scope: Global
Data Type: numeric
Innodb_buffer_pool_pages_flushedDescription: Number of pages which have been flushed.
Scope: Global
Data Type: numeric
Innodb_buffer_pool_pages_LRU_flushedDescription: Flush list as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_buffer_pool_pages_LRU_freedDescription: Monitor the number of pages that were freed by a buffer pool LRU eviction scan, without flushing.
Scope: Global
Data Type: numeric
Introduced:
Innodb_buffer_pool_pages_freeDescription: Number of free pages.
Scope: Global
Data Type: numeric
Innodb_buffer_pool_pages_made_not_youngDescription: Pages not young as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_buffer_pool_pages_made_youngDescription: Pages made young as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_buffer_pool_pages_miscDescription: Number of pages set aside for internal use.
Scope: Global
Data Type: numeric
Innodb_buffer_pool_pages_oldDescription: Old database page, as shown in the BUFFER POOL AND MEMORY section of the output.
In and , this status variable is present for XtraDB.
In , , and , this status variable is not present.
In
Innodb_buffer_pool_pages_totalDescription: Total number of pages.
Scope: Global
Data Type: numeric
Innodb_buffer_pool_read_aheadDescription: Number of pages read into the by the read-ahead background thread.
Scope: Global
Data Type: numeric
Innodb_buffer_pool_read_ahead_evictedDescription: Number of pages read into the by the read-ahead background thread that were evicted without having been accessed by queries.
Scope: Global
Data Type: numeric
Innodb_buffer_pool_read_ahead_rndDescription: Number of random read-aheads.
Scope: Global
Data Type: numeric
Innodb_buffer_pool_read_requestsDescription: Number of requests to read from the .
Scope: Global
Data Type: numeric
Innodb_buffer_pool_readsDescription: Number of reads that could not be satisfied by the and had to be read from disk.
Scope: Global
Data Type: numeric
Innodb_buffer_pool_resize_statusDescription: Progress of the dynamic resizing operation. See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_buffer_pool_wait_freeDescription: Number of times InnoDB waited for a free page before reading or creating a page. Normally, writes to the happen in the background. When no clean pages are available, dirty pages are flushed first in order to free some up. This counts the numbers of wait for this operation to finish. If this value is not small, look at increasing .
Scope: Global
Data Type: numeric
Innodb_buffer_pool_write_requestsDescription: Number of requests to write to the .
Scope: Global
Data Type: numeric
Innodb_buffered_aio_submittedDescription:
Scope: Global
Data Type: numeric
Introduced:
Innodb_bulk_operationsDescription: Number of bulk insert operations to InnoDB tables.
Scope: Global
Data Type: numeric
Introduced: , , , ,
Innodb_checkpoint_ageDescription: The amount of data written to the InnoDB redo log since the last checkpoint, as shown in the LOG section of the output. (This is equivalent to subtracting "Last checkpoint at" from "Log sequence number", cf the ). Despite the name ("age"), the value is not a duration, but really an amount of data (in bytes) !
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
Innodb_checkpoint_max_ageDescription: Max checkpoint age, as shown in the LOG section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_checkpoint_target_ageDescription: Checkpoint age target, as shown in the LOG section of the output. XtraDB only. Removed in and replaced with MySQL 5.6's flushing implementation.
Scope: Global
Data Type: numeric
Introduced:
Innodb_current_row_locksDescription: Number of current row locks on InnoDB tables as shown in the TRANSACTIONS section of the output. Renamed from in XtraDB 5.5.8-20.1.
Scope: Global
Data Type: numeric
Introduced:
Innodb_data_fsyncsDescription: Number of InnoDB fsync (sync-to-disk) calls. fsync call frequency can be influenced by the configuration option.
Scope: Global
Data Type: numeric
Innodb_data_pending_fsyncsDescription: Number of pending InnoDB fsync (sync-to-disk) calls. fsync call frequency can be influenced by the configuration option.
Scope: Global
Data Type: numeric
Innodb_data_pending_readsDescription: Number of pending InnoDB reads.
Scope: Global
Data Type: numeric
Innodb_data_pending_writesDescription: Number of pending InnoDB writes.
Scope: Global
Data Type: numeric
Innodb_data_readDescription: Number of InnoDB bytes read since server startup (not to be confused with ).
Scope: Global
Data Type: numeric
Innodb_data_readsDescription: Number of InnoDB read operations (not to be confused with ).
Scope: Global
Data Type: numeric
Innodb_data_writesDescription: Number of InnoDB write operations.
Scope: Global
Data Type: numeric
Innodb_data_writtenDescription: Number of InnoDB bytes written since server startup. From , no longer includes writes to the redo log file ib_logfile0, which continue to be counted by . An error in counting was introduced in until , , , , and () in which writes via the doublewrite buffer started to be counted incorrectly, without multiplying them by innodb_page_size. A workaround for the error could be the following formulae: real_data_written = Innodb_data_written + (innodb_page_size - 1) * Innodb_dblwr_pages_writteninnodb_written = real_data_written + Innodb_os_log_written
Scope: Global
Data Type:
Innodb_dblwr_pages_writtenDescription: Number of pages written to the .
Scope: Global
Data Type: numeric
Innodb_dblwr_writesDescription: Number of writes to the .
Scope: Global
Data Type: numeric
Innodb_deadlocksDescription: Total number of InnoDB deadlocks. Deadlocks occur when at least two transactions are waiting for the other to finish, creating a circular dependency. InnoDB usually detects these quickly, returning an error.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
Innodb_defragment_compression_failuresDescription: Number of defragment re-compression failures. See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_defragment_countDescription: Number of defragment operations. See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_defragment_failuresDescription: Number of defragment failures. See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_dict_tablesDescription: Number of entries in the XtraDB data dictionary cache. This Percona XtraDB variable was removed in MariaDB 10/XtraDB 5.6 as it was replaced with MySQL 5.6's implementation.
Scope: Global
Data Type: numeric
Introduced: XtraDB 5.0.77-b13
Innodb_encryption_n_merge_blocks_decryptedDescription:
Scope: Global
Data Type: numeric
Introduced: , ,
Innodb_encryption_n_merge_blocks_encryptedDescription:
Scope: Global
Data Type: numeric
Introduced: , ,
Innodb_encryption_n_rowlog_blocks_decryptedDescription:
Scope: Global
Data Type: numeric
Introduced: , ,
Innodb_encryption_n_rowlog_blocks_encryptedDescription:
Scope: Global
Data Type: numeric
Introduced: , ,
Innodb_encryption_n_temp_blocks_decryptedDescription:
Scope: Global
Data Type: numeric
Introduced: , ,
Innodb_encryption_n_temp_blocks_encryptedDescription:
Scope: Global
Data Type: numeric
Introduced: , ,
Innodb_encryption_num_key_requestsDescription: Was not present in .
Scope: Global
Data Type: numeric
Introduced:
Innodb_encryption_rotation_estimated_iopsDescription: See .
Scope: Global
Data Type: numeric
Removed:
Innodb_encryption_rotation_pages_flushedDescription: See .
Scope: Global
Data Type: numeric
Removed:
Innodb_encryption_rotation_pages_modifiedDescription: See .
Scope: Global
Data Type: numeric
Removed:
Innodb_encryption_rotation_pages_read_from_cacheDescription: See .
Scope: Global
Data Type: numeric
Removed:
Innodb_encryption_rotation_pages_read_from_diskDescription: See .
Scope: Global
Data Type: numeric
Removed:
Innodb_have_atomic_builtinsDescription: Whether the server has been built with atomic instructions, provided by the CPU ensuring that critical low-level operations can't be interrupted. XtraDB only.
Scope: Global
Data Type: boolean
Innodb_have_bzip2Description: Whether the server has the bzip2 compression method available. See .
Scope: Global
Data Type: boolean
Introduced:
Innodb_have_lz4Description: Whether the server has the lz4 compression method available. See .
Scope: Global
Data Type: boolean
Introduced:
Innodb_have_lzmaDescription: Whether the server has the lzma compression method available. See .
Scope: Global
Data Type: boolean
Introduced:
Innodb_have_lzoDescription: Whether the server has the lzo compression method available. See .
Scope: Global
Data Type: boolean
Introduced:
Innodb_have_punch_holeDescription:
Scope: Global
Data Type: numeric
Introduced:
Innodb_have_snappyDescription: Whether the server has the snappy compression method available. See .
Scope: Global
Data Type: boolean
Introduced:
Innodb_history_list_lengthDescription: History list length as shown in the TRANSACTIONS section of the output. XtraDB only until introduced in .
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Innodb_ibuf_discarded_delete_marksDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_ibuf_discarded_deletesDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_ibuf_discarded_insertsDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_ibuf_free_listDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_ibuf_merged_delete_marksDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_ibuf_merged_deletesDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_ibuf_merged_insertsDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_ibuf_mergesDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_ibuf_segment_sizeDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_ibuf_sizeDescription: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_instant_alter_columnDescription: See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_log_waitsDescription: Number of times InnoDB was forced to wait for log writes to be flushed due to the log buffer being too small.
Scope: Global
Data Type: numeric
Innodb_log_write_requestsDescription: Number of requests to write to the InnoDB redo log.
Scope: Global
Data Type: numeric
Innodb_log_writesDescription: Number of writes to the InnoDB redo log.
Scope: Global
Data Type: numeric
Innodb_lsn_currentDescription: Log sequence number as shown in the LOG section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_lsn_flushedDescription: Flushed up to log sequence number as shown in the LOG section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_lsn_last_checkpointDescription: Log sequence number last checkpoint as shown in the LOG section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_master_thread_1_second_loopsDescription: As shown in the BACKGROUND THREAD section of the output.
In , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_master_thread_10_second_loopsDescription: As shown in the BACKGROUND THREAD section of the output.
In , this status variable is present in XtraDB.
In and later, this status variable is not present
Scope: Global
Innodb_master_thread_active_loopsDescription: As shown in the BACKGROUND THREAD section of the output.
In , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In , this status variable was reintroduced.
Innodb_master_thread_background_loopsDescription: As shown in the BACKGROUND THREAD section of the output.
In , this status variable is present in XtraDB.
In and later, this status variable is not present
Scope: Global
Innodb_master_thread_idle_loopsDescription: As shown in the BACKGROUND THREAD section of the output.
In , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In , this status variable was reintroduced.
Innodb_master_thread_main_flush_loopsDescription: As shown in the BACKGROUND THREAD section of the output.
In , this status variable is present in XtraDB.
In and later, this status variable is not present
Scope: Global
Innodb_master_thread_sleepsDescription: As shown in the BACKGROUND THREAD section of the output. XtraDB only.
In , this status variable is present in XtraDB.
In , , , and , this status variable is not present. Use the innodb_master_thread_sleeps counter in the table instead.
Innodb_max_trx_idDescription: As shown in the TRANSACTIONS section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In , this status variable was reintroduced.
Innodb_mem_adaptive_hashDescription: As shown in the BUFFER POOL AND MEMORY section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_mem_dictionaryDescription: As shown in the BUFFER POOL AND MEMORY section of the output.
In and , this status variable is present in XtraDB.
In , , and , this status variable is not present.
In
Innodb_mem_totalDescription: As shown in the BUFFER POOL AND MEMORY section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_mutex_os_waitsDescription: Mutex OS waits as shown in the SEMAPHORES section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_mutex_spin_roundsDescription: Mutex spin rounds as shown in the SEMAPHORES section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_mutex_spin_waitsDescription: Mutex spin waits as shown in the SEMAPHORES section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_num_index_pages_writtenDescription:
Scope:
Data Type: numeric
Introduced:
Innodb_num_non_index_pages_writtenDescription:
Scope:
Data Type: numeric
Introduced:
Innodb_num_open_filesDescription: Number of open files held by InnoDB. InnoDB only.
Scope: Global
Data Type: numeric
Innodb_num_page_compressed_trim_opDescription: Number of trim operations performed.
Scope: Global
Data Type: numeric
Innodb_num_page_compressed_trim_op_savedDescription: Number of trim operations not done because of an earlier trim.
Scope: Global
Data Type: numeric
Innodb_num_pages_decryptedDescription: Number of pages page decrypted. See .
Scope: Global
Data Type: numeric
Innodb_num_pages_encryptedDescription: Number of pages page encrypted. See .
Scope: Global
Data Type: numeric
Innodb_num_pages_page_compressedDescription: Number of pages that are page compressed.
Scope: Global
Data Type: numeric
Innodb_num_pages_page_compression_errorDescription: Number of compression errors.
Scope: Global
Data Type: numeric
Innodb_num_pages_page_decompressedDescription: Number of pages compressed with page compression that are decompressed.
Scope: Global
Data Type: numeric
Innodb_num_pages_page_encryption_errorDescription: Number of page encryption errors. See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_oldest_view_low_limit_trx_idDescription: As shown in the TRANSACTIONS section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_onlineddl_pct_progressDescription: Shows the progress of in-place alter table. It might be not so accurate because in-place alter is highly dependent on disk and buffer pool status. See .
Scope: Global
Data Type: numeric
Innodb_onlineddl_rowlog_pct_usedDescription: Shows row log buffer usage in 5-digit integer (10000 means 100.00%). See .
Scope: Global
Data Type: numeric
Innodb_onlineddl_rowlog_rowsDescription: Number of rows stored in the row log buffer. See .
Scope: Global
Data Type: numeric
Innodb_os_log_fsyncsDescription: Number of InnoDB log fsync (sync-to-disk) requests.
Scope: Global
Data Type: numeric
Removed:
Innodb_os_log_pending_fsyncsDescription: Number of pending InnoDB log fsync (sync-to-disk) requests.
Scope: Global
Data Type: numeric
Removed:
Innodb_os_log_pending_writesDescription: Number of pending InnoDB log writes.
Scope: Global
Data Type: numeric
Removed:
Innodb_os_log_writtenDescription: Number of bytes written to the InnoDB log.
Scope: Global
Data Type: numeric
Innodb_page_compression_savedDescription: Number of bytes saved by page compression.
Scope:
Data Type:
Innodb_page_compression_trim_sect512Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 512 byte block-size.
Scope:
Data Type: numeric
Introduced: , Fusion-io
Innodb_page_compression_trim_sect1024Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 1K block-size.
Scope:
Data Type: numeric
Introduced: , Fusion-io
Innodb_page_compression_trim_sect2048Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 2K block-size.
Scope:
Data Type: numeric
Introduced: , Fusion-io
Innodb_page_compression_trim_sect4096Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 4K block-size.
Scope:
Data Type: numeric
Introduced: , Fusion-io
Innodb_page_compression_trim_sect8192Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 8K block-size.
Scope:
Data Type: numeric
Introduced:, Fusion-io
Innodb_page_compression_trim_sect16384Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 16K block-size.
Scope:
Data Type: numeric
Introduced: , Fusion-io
Innodb_page_compression_trim_sect32768Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 32K block-size.
Scope:
Data Type: numeric
Introduced: , Fusion-io
Innodb_page_sizeDescription: Page size used by InnoDB. Defaults to 16KB, can be compiled with a different value.
Scope: Global
Data Type: numeric
Innodb_pages_createdDescription: Number of InnoDB pages created.
Scope: Global
Data Type: numeric
Innodb_pages_readDescription: Number of InnoDB pages read.
Scope: Global
Data Type: numeric
Innodb_pages0_readDescription: Counter for keeping track of reads of the first page of InnoDB data files, because the original implementation of data-at-rest-encryption for InnoDB introduced new code paths for reading the pages. Removed in as the extra reads of the first page were removed, and the encryption subsystem will be initialized whenever we first read the first page of each data file, in fil_node_open_file().
Scope: Global
Data Type: numeric
Innodb_pages_writtenDescription: Number of InnoDB pages written.
Scope: Global
Data Type: numeric
Innodb_purge_trx_idDescription: Purge transaction id as shown in the TRANSACTIONS section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_purge_undo_noDescription: As shown in the TRANSACTIONS section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_read_views_memoryDescription: As shown in the BUFFER POOL AND MEMORY section of the output. Shows the total of memory in bytes allocated for the InnoDB read view.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_row_lock_current_waitsDescription: Number of pending row lock waits on InnoDB tables.
Scope: Global
Data Type: numeric
Innodb_row_lock_numbersDescription: Number of current row locks on InnoDB tables as shown in the TRANSACTIONS section of the output. Renamed to in XtraDB 5.5.10-20.1.
Scope: Global
Data Type: numeric
Introduced: / XtraDB 5.5.8-20
Innodb_row_lock_timeDescription: Total time in milliseconds spent getting InnoDB row locks.
Scope: Global
Data Type: numeric
Innodb_row_lock_time_avgDescription: Average time in milliseconds spent getting an InnoDB row lock.
Scope: Global
Data Type: numeric
Innodb_row_lock_time_maxDescription: Maximum time in milliseconds spent getting an InnoDB row lock.
Scope: Global
Data Type: numeric
Innodb_row_lock_waitsDescription: Number of times InnoDB had to wait before getting a row lock.
Scope: Global
Data Type: numeric
Innodb_rows_deletedDescription: Number of rows deleted from InnoDB tables that where not system tables. Almost equivalent to which does include system tables.
Scope: Global
Data Type: numeric
Removed:
Innodb_rows_insertedDescription: Number of rows inserted into InnoDB tables that where not system tables. No direct equivalent in status variables.
Scope: Global
Data Type: numeric
Removed:
Innodb_rows_readDescription: Number of rows read from InnoDB tables that where not system tables. Almost equivalent to the sum of status variables which do include system tables.
Scope: Global
Data Type: numeric
Removed:
Innodb_rows_updatedDescription: Number of rows updated in InnoDB tables that where not system tables. Almost equivalent to which does include system tables.
Scope: Global
Data Type: numeric
Removed:
Innodb_s_lock_os_waitsDescription: As shown in the SEMAPHORES section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_s_lock_spin_roundsDescription: As shown in the SEMAPHORES section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_s_lock_spin_waitsDescription: As shown in the SEMAPHORES section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_scrub_background_page_reorganizationsDescription: See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_scrub_background_page_split_failures_missing_indexDescription: See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_scrub_background_page_split_failures_out_of_filespaceDescription: See .
Scope: Global
Data Type: numeric
Introduced:
Innodb_scrub_background_page_split_failures_underflowDescription: See .
Scope: Global
Data Type: numeric
Removed:
Innodb_scrub_background_page_split_failures_unknownDescription: See .
Scope: Global
Data Type: numeric
Removed:
Innodb_scrub_background_page_splitsDescription: See .
Scope: Global
Data Type: numeric
Removed:
Innodb_scrub_logDescription:
Scope: Global
Data Type: numeric
Introduced:
Innodb_secondary_index_triggered_cluster_readsDescription: Used to track the effectiveness of the Prefix Index Queries Optimization (). Removed in as the optimization is now always enabled.
Scope: Global
Data Type: numeric
Removed:
Innodb_secondary_index_triggered_cluster_reads_avoidedDescription: Used to track the effectiveness of the Prefix Index Queries Optimization (). Removed in as the optimization is now always enabled.
Scope: Global
Data Type: numeric
Removed:
Innodb_system_rows_deletedDescription: Number of rows deleted on system tables.
Scope: Global
Data Type: numeric
Removed:
Innodb_system_rows_insertedDescription: Number of rows inserted on system tables.
Scope: Global
Data Type: numeric
Removed:
Innodb_system_rows_readDescription: Number of rows read on system tables.
Scope: Global
Data Type: numeric
Removed:
Innodb_system_rows_updatedDescription: Number of rows updated on system tables.
Scope: Global
Data Type: numeric
Removed:
Innodb_truncated_status_writesDescription: Number of times output from has been truncated.
Scope: Global
Data Type: numeric
Innodb_undo_truncationsDescription: Number of undo tablespace truncation operations.
Scope: Global
Data Type: numeric
Introduced:
Innodb_x_lock_os_waitsDescription: As shown in the SEMAPHORES section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_x_lock_spin_roundsDescription: As shown in the SEMAPHORES section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
Innodb_x_lock_spin_waitsDescription: As shown in the SEMAPHORES section of the output.
In and , this status variable is present in XtraDB.
In and later, this status variable is not present.
Scope: Global
This page is licensed: CC BY-SA / Gnu FDL
numericIntroduced:
Data Type: numeric
Introduced:
Removed:
Scope: Global
Data Type: numeric
Introduced: ,
Scope: Global
Data Type: numeric
Introduced: (XtraDB only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
In , this status variable was reintroduced.
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Removed:
numericScope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Removed:
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Data Type: numeric
Introduced:
Removed:
Data Type: numeric
Introduced:
Removed:
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only), :
Data Type: numeric
Introduced:
Removed:
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only), :
Data Type: numeric
Introduced:
Removed:
In , this status variable was reintroduced.
Scope: Global
Data Type: numeric
Introduced:
Removed:
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Scope: Global
Data Type: numeric
Introduced: (XtraDB-only),
Data Type: numeric
Introduced:
Data Type: numeric
Introduced:
Data Type: numeric
Introduced:
Data Type: numeric
Introduced:
Removed:
Data Type: numeric
Introduced:
Removed:
Removed:
Removed:
Removed:
Removed:
Removed:
Removed:
Removed:
Removed:
Data Type: numeric
Introduced:
Removed:
Data Type: numeric
Introduced:
Removed:
Data Type: numeric
Introduced:
Removed:
Removed: / XtraDB 5.5.10-20.1
Data Type: numeric
Introduced:
Removed:
Data Type: numeric
Introduced:
Removed:
Data Type: numeric
Introduced:
Removed:
Removed:
Removed:
Removed:
Removed:
Data Type: numeric
Introduced:
Removed:
Data Type: numeric
Introduced:
Removed:
Data Type: numeric
Introduced:
Removed: