> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/innodb-status-variables.md).

# InnoDB Server Status Variables

InnoDB server status variables, viewable with SHOW STATUS.

See [Server Status Variables](/docs/server/server-management/variables-and-modes/server-status-variables.md) for a complete list of status variables that can be viewed with [SHOW STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-status.md).

Much of the [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) information here can also be seen with a [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) statement.

See also the [Full list of MariaDB options, system and status variables](/docs/server/server-management/variables-and-modes/full-list-of-mariadb-options-system-and-status-variables.md).

#### `Innodb_adaptive_hash_hash_searches`

* Description: Hash searches as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_adaptive_hash_non_hash_searches`

* Description: Non-hash searches as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output. From [MariaDB 10.6.2](/docs/release-notes/community-server/10.6/10.6.2.md), not updated if [innodb\_adaptive\_hash\_index](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_adaptive_hash_index) is not enabled (the default).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_async_reads_pending`

* Description: Number of async read I/O operations currently in progress (from SUBMITTED to COMPLETED). See [InnoDB Asynchronous I/O](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_async_reads_queue_size`

* Description: Current size of the async I/O read queue. See [InnoDB Asynchronous I/O Queuing Mechanism](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md#queuing-mechanism).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_async_reads_tasks_running`

* Description: Number of async read I/O operations currently in the EXECUTING\_COMPLETION\_TASK state. See [InnoDB Asynchronous I/O](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_async_reads_total_count`

* Description: Total number of async read completion tasks that have finished execution. See [InnoDB Asynchronous I/O](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_async_reads_total_enqueues`

* Description: Total number of async read operations that were queued. Includes those still waiting and making up [innodb\_async\_reads\_queue\_size](#innodb_async_reads_queue_size). See [InnoDB Asynchronous I/O](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_async_reads_wait_slot_sec`

* Description: Total wait time for a free I/O slot (see Waiting for IO Slots). See [InnoDB Asynchronous I/O Waiting for IO Slots](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md#waiting-for-io-slots).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_async_writes_pending`

* Description: Number of async write I/O operations currently in progress (from SUBMITTED to COMPLETED). See [InnoDB Asynchronous I/O](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_async_writes_queue_size`

* Description: Current size of the async I/O write queue. See [InnoDB Asynchronous I/O Queuing Mechanism](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md#queuing-mechanism).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_async_writes_tasks_running`

* Description: Number of async write I/O operations currently in the EXECUTING\_COMPLETION\_TASK state. See [InnoDB Asynchronous I/O](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_async_writes_total_count`

* Description: Total number of async write completion tasks that have finished execution. See [InnoDB Asynchronous I/O](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_async_writes_total_enqueues`

* Description: Total number of async write operations that were queued. Includes those still waiting and making up [innodb\_async\_writes\_queue\_size](#innodb_async_writes_queue_size). See [InnoDB Asynchronous I/O](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_async_writes_wait_slot_sec`

* Description: See [InnoDB Asynchronous I/O](/docs/server/server-usage/storage-engines/innodb/innodb-asynchronous-io.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

#### `Innodb_available_undo_logs`

* Description: Total number available InnoDB [undo logs](/docs/server/server-usage/storage-engines/innodb/innodb-undo-log.md).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_background_log_sync`

* Description: As shown in the BACKGROUND THREAD section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_buffer_pool_bytes_data`

* Description: Number of bytes contained in the [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md), both dirty (modified) and clean (unmodified). See also [Innodb\_buffer\_pool\_pages\_data](#innodb_buffer_pool_pages_data), which can contain pages of different sizes in the case of compression.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_bytes_dirty`

* Description: Number of dirty (modified) bytes contained in the [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md). See also [Innodb\_buffer\_pool\_pages\_dirty](#innodb_buffer_pool_pages_dirty), which can contain pages of different sizes in the case of compression.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_dump_status`

* Description: A text description of the progress or final status of the last Innodb buffer pool dump.
* Scope: Global
* Data Type: `string`
* Introduced: [MariaDB 10.0.0](/docs/release-notes/community-server/old-releases/10.0/10.0.0.md)

#### `Innodb_buffer_pool_load_incomplete`

* Description: 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: [MariaDB 10.3.5](/docs/release-notes/community-server/old-releases/10.3/10.3.5.md)

#### `Innodb_buffer_pool_load_status`

* Description: A text description of the progress or final status of the last Innodb buffer pool load.
* Scope: Global
* Data Type: `string`
* Introduced: [MariaDB 10.0.0](/docs/release-notes/community-server/old-releases/10.0/10.0.0.md)

#### `Innodb_buffer_pool_pages_data`

* Description: Number of [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) pages which contain data, both dirty (modified) and clean (unmodified). See also [Innodb\_buffer\_pool\_bytes\_data](#innodb_buffer_pool_bytes_data).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_pages_dirty`

* Description: Number of [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) pages which contain dirty (modified) data. See also [innodb\_buffer\_pool\_bytes\_dirty](#innodb_buffer_pool_bytes_dirty).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_pages_flushed`

* Description: Number of [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) pages which have been flushed.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_pages_LRU_flushed`

* Description: Flush list as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_buffer_pool_pages_LRU_freed`

* Description: Monitor the number of pages that were freed by a buffer pool LRU eviction scan, without flushing.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.6.0](/docs/release-notes/community-server/10.6/10.6.0.md)

#### `Innodb_buffer_pool_pages_free`

* Description: Number of free [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) pages.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_pages_made_not_young`

* Description: Pages not young as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_buffer_pool_pages_made_young`

* Description: Pages made young as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_buffer_pool_pages_misc`

* Description: Number of [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) pages set aside for internal use.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_pages_old`

* Description: Old database page, as shown in the BUFFER POOL AND MEMORY section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_buffer_pool_pages_total`

* Description: Total number of [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) pages.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_read_ahead`

* Description: Number of pages read into the [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) by the read-ahead background thread.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_read_ahead_evicted`

* Description: Number of pages read into the [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) 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_rnd`

* Description: Number of random read-aheads.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_read_requests`

* Description: Number of requests to read from the [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) .
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_reads`

* Description: Number of reads that could not be satisfied by the [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) and had to be read from disk.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_resize_status`

* Description: Progress of the dynamic [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) resizing operation. See [Setting Innodb Buffer Pool Size Dynamically](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/setting-innodb-buffer-pool-size-dynamically.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.2.2](/docs/release-notes/community-server/old-releases/10.2/10.2.2.md)

#### `Innodb_buffer_pool_wait_free`

* Description: Number of times InnoDB waited for a free page before reading or creating a page. Normally, writes to the [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) 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 [innodb\_buffer\_pool\_size](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_buffer_pool_size).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_buffer_pool_write_requests`

* Description: Number of requests to write to the [InnoDB buffer pool](/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool.md) .
* Scope: Global
* Data Type: `numeric`

#### `Innodb_bulk_operations`

* Description: Number of bulk insert operations to InnoDB tables.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.6.19](/docs/release-notes/community-server/10.6/10.6.19.md), [MariaDB 10.11.9](/docs/release-notes/community-server/10.11/10.11.9.md), [MariaDB 11.1.6](/docs/release-notes/community-server/old-releases/11.1/11.1.6.md), [MariaDB 11.2.5](/docs/release-notes/community-server/old-releases/11.2/11.2.5.md), [MariaDB 11.4.3](/docs/release-notes/community-server/11.4/11.4.3.md)

#### `Innodb_checkpoint_age`

* Description: The amount of data written to the InnoDB redo log since the last checkpoint, as shown in the LOG section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output. (This is equivalent to subtracting "Last checkpoint at" from "Log sequence number", cf the [RedoLog details](/docs/server/server-usage/storage-engines/innodb/innodb-redo-log.md)). Despite the name ("age"), the value is not a duration, but really an amount of data (in bytes) !
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_checkpoint_max_age`

* Description: Max checkpoint age, as shown in the LOG section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_data_fsyncs`

* Description: Number of InnoDB fsync (sync-to-disk) calls. fsync call frequency can be influenced by the [innodb\_flush\_method](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_flush_method) configuration option.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_data_pending_fsyncs`

* Description: Number of pending InnoDB fsync (sync-to-disk) calls. fsync call frequency can be influenced by the [innodb\_flush\_method](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_flush_method) configuration option.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_data_pending_reads`

* Description: Number of pending InnoDB reads.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_data_pending_writes`

* Description: Number of pending InnoDB writes.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_data_read`

* Description: Number of InnoDB bytes read since server startup (not to be confused with [Innodb\_data\_reads](#innodb_data_reads)).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_data_reads`

* Description: Number of InnoDB read operations (not to be confused with [Innodb\_data\_read](#innodb_data_read)).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_data_writes`

* Description: Number of InnoDB write operations.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_data_written`

* Description: Number of InnoDB bytes written since server startup. Does not include writes to the redo log file `ib_logfile0`, which are counted by [Innodb\_os\_log\_written](#innodb_os_log_written). An error in counting affected releases before [MariaDB 10.6.13](/docs/release-notes/community-server/10.6/10.6.13.md), [MariaDB 10.8.8](/docs/release-notes/community-server/old-releases/10.8/10.8.8.md), [MariaDB 10.9.6](/docs/release-notes/community-server/old-releases/10.9/10.9.6.md), [MariaDB 10.10.4](/docs/release-notes/community-server/old-releases/10.10/10.10.4.md) and [MariaDB 10.11.3](/docs/release-notes/community-server/10.11/10.11.3.md) ([MDEV-31124](https://jira.mariadb.org/browse/MDEV-31124)): writes via the doublewrite buffer were 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: `numeric`

#### `Innodb_dblwr_pages_written`

* Description: Number of pages written to the [InnoDB doublewrite buffer](/docs/server/server-usage/storage-engines/innodb/innodb-doublewrite-buffer.md).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_dblwr_writes`

* Description: Number of writes to the [InnoDB doublewrite buffer](/docs/server/server-usage/storage-engines/innodb/innodb-doublewrite-buffer.md).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_deadlocks`

* Description: 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.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_defragment_compression_failures`

* Description: Number of defragment re-compression failures. See [Defragmenting InnoDB Tablespaces](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/defragmenting-innodb-tablespaces.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.1](/docs/release-notes/community-server/old-releases/10.1/10.1.1.md)

#### `Innodb_defragment_count`

* Description: Number of defragment operations. See [Defragmenting InnoDB Tablespaces](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/defragmenting-innodb-tablespaces.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.1](/docs/release-notes/community-server/old-releases/10.1/10.1.1.md)

#### `Innodb_defragment_failures`

* Description: Number of defragment failures. See [Defragmenting InnoDB Tablespaces](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/defragmenting-innodb-tablespaces.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.1](/docs/release-notes/community-server/old-releases/10.1/10.1.1.md)

#### `Innodb_encryption_key_rotation_list_length`

* Description: Intended to show the number of tablespaces in the key rotation list. InnoDB never updated the counter, so it always returned `0`. [INFORMATION\_SCHEMA.INNODB\_TABLESPACES\_ENCRYPTION](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_tablespaces_encryption-table.md) reports the key rotation state of each tablespace.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.6.8](/docs/release-notes/community-server/10.6/10.6.8.md), [MariaDB 10.5.16](/docs/release-notes/community-server/old-releases/10.5/10.5.16.md), [MariaDB 10.4.25](/docs/release-notes/community-server/old-releases/10.4/10.4.25.md), [MariaDB 10.3.35](/docs/release-notes/community-server/old-releases/10.3/10.3.35.md)

#### `Innodb_encryption_n_merge_blocks_decrypted`

* Description:
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.28](/docs/release-notes/community-server/old-releases/10.1/10.1.28.md), [MariaDB 10.2.9](/docs/release-notes/community-server/old-releases/10.2/10.2.9.md), [MariaDB 10.3.2](/docs/release-notes/community-server/old-releases/10.3/10.3.2.md)

#### `Innodb_encryption_n_merge_blocks_encrypted`

* Description:
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.28](/docs/release-notes/community-server/old-releases/10.1/10.1.28.md), [MariaDB 10.2.9](/docs/release-notes/community-server/old-releases/10.2/10.2.9.md), [MariaDB 10.3.2](/docs/release-notes/community-server/old-releases/10.3/10.3.2.md)

#### `Innodb_encryption_n_rowlog_blocks_decrypted`

* Description:
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.28](/docs/release-notes/community-server/old-releases/10.1/10.1.28.md), [MariaDB 10.2.9](/docs/release-notes/community-server/old-releases/10.2/10.2.9.md), [MariaDB 10.3.2](/docs/release-notes/community-server/old-releases/10.3/10.3.2.md)

#### `Innodb_encryption_n_rowlog_blocks_encrypted`

* Description:
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.28](/docs/release-notes/community-server/old-releases/10.1/10.1.28.md), [MariaDB 10.2.9](/docs/release-notes/community-server/old-releases/10.2/10.2.9.md), [MariaDB 10.3.2](/docs/release-notes/community-server/old-releases/10.3/10.3.2.md)

#### `Innodb_encryption_n_temp_blocks_decrypted`

* Description:
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.2.26](/docs/release-notes/community-server/old-releases/10.2/10.2.26.md), [MariaDB 10.3.17](/docs/release-notes/community-server/old-releases/10.3/10.3.17.md), [MariaDB 10.4.7](/docs/release-notes/community-server/old-releases/10.4/10.4.7.md)

#### `Innodb_encryption_n_temp_blocks_encrypted`

* Description:
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.2.26](/docs/release-notes/community-server/old-releases/10.2/10.2.26.md), [MariaDB 10.3.17](/docs/release-notes/community-server/old-releases/10.3/10.3.17.md), [MariaDB 10.4.7](/docs/release-notes/community-server/old-releases/10.4/10.4.7.md)

#### `Innodb_encryption_num_key_requests`

* Description: Number of requests for the latest version of an encryption key.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.2.4](/docs/release-notes/community-server/old-releases/10.2/10.2.4.md)

#### `Innodb_encryption_rotation_estimated_iops`

* Description: See [Table and Tablespace Encryption](/docs/server/security/encryption/data-at-rest-encryption/innodb-encryption.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.3](/docs/release-notes/community-server/old-releases/10.1/10.1.3.md)

#### `Innodb_encryption_rotation_pages_flushed`

* Description: See [Table and Tablespace Encryption](/docs/server/security/encryption/data-at-rest-encryption/innodb-encryption.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.3](/docs/release-notes/community-server/old-releases/10.1/10.1.3.md)

#### `Innodb_encryption_rotation_pages_modified`

* Description: See [Table and Tablespace Encryption](/docs/server/security/encryption/data-at-rest-encryption/innodb-encryption.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.3](/docs/release-notes/community-server/old-releases/10.1/10.1.3.md)

#### `Innodb_encryption_rotation_pages_read_from_cache`

* Description: See [Table and Tablespace Encryption](/docs/server/security/encryption/data-at-rest-encryption/innodb-encryption.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.3](/docs/release-notes/community-server/old-releases/10.1/10.1.3.md)

#### `Innodb_encryption_rotation_pages_read_from_disk`

* Description: See [Table and Tablespace Encryption](/docs/server/security/encryption/data-at-rest-encryption/innodb-encryption.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.3](/docs/release-notes/community-server/old-releases/10.1/10.1.3.md)

#### `Innodb_have_bzip2`

* Description: Whether the server has the bzip2 compression method available. See [InnoDB/XtraDB Page Compression](/docs/server/server-usage/storage-engines/innodb/innodb-page-compression.md).
* Scope: Global
* Data Type: `boolean`
* Introduced: [MariaDB 10.1.0](/docs/release-notes/community-server/old-releases/10.1/10.1.0.md)

#### `Innodb_have_lz4`

* Description: Whether the server has the lz4 compression method available. See [InnoDB/XtraDB Page Compression](/docs/server/server-usage/storage-engines/innodb/innodb-page-compression.md).
* Scope: Global
* Data Type: `boolean`
* Introduced: [MariaDB 10.1.0](/docs/release-notes/community-server/old-releases/10.1/10.1.0.md)

#### `Innodb_have_lzma`

* Description: Whether the server has the lzma compression method available. See [InnoDB/XtraDB Page Compression](/docs/server/server-usage/storage-engines/innodb/innodb-page-compression.md).
* Scope: Global
* Data Type: `boolean`
* Introduced: [MariaDB 10.1.0](/docs/release-notes/community-server/old-releases/10.1/10.1.0.md)

#### `Innodb_have_lzo`

* Description: Whether the server has the lzo compression method available. See [InnoDB/XtraDB Page Compression](/docs/server/server-usage/storage-engines/innodb/innodb-page-compression.md).
* Scope: Global
* Data Type: `boolean`
* Introduced: [MariaDB 10.1.0](/docs/release-notes/community-server/old-releases/10.1/10.1.0.md)

#### `Innodb_have_punch_hole`

* Description:
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.2.4](/docs/release-notes/community-server/old-releases/10.2/10.2.4.md)

#### `Innodb_have_snappy`

* Description: Whether the server has the snappy compression method available. See [InnoDB/XtraDB Page Compression](/docs/server/server-usage/storage-engines/innodb/innodb-page-compression.md).
* Scope: Global
* Data Type: `boolean`
* Introduced: [MariaDB 10.1.3](/docs/release-notes/community-server/old-releases/10.1/10.1.3.md)

#### `Innodb_history_list_length`

* Description: History list length as shown in the TRANSACTIONS section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_ibuf_discarded_delete_marks`

* Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_ibuf_discarded_deletes`

* Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_ibuf_discarded_inserts`

* Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_ibuf_free_list`

* Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_ibuf_merged_delete_marks`

* Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_ibuf_merged_deletes`

* Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_ibuf_merged_inserts`

* Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_ibuf_merges`

* Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_ibuf_segment_size`

* Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_ibuf_size`

* Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_instant_alter_column`

* Description: See [Instant ADD COLUMN for InnoDB](/docs/server/server-usage/storage-engines/innodb/innodb-online-ddl/instant-add-column-for-innodb.md).
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.3.2](/docs/release-notes/community-server/old-releases/10.3/10.3.2.md)

#### `Innodb_log_waits`

* Description: 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_requests`

* Description: Number of requests to write to the InnoDB redo log.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_log_writes`

* Description: Number of writes to the InnoDB redo log.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_lsn_current`

* Description: Log sequence number as shown in the LOG section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_lsn_flushed`

* Description: Flushed up to log sequence number as shown in the LOG section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_lsn_last_checkpoint`

* Description: Log sequence number last checkpoint as shown in the LOG section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_lsn_archived`

* Description: The Log Sequence Number (LSN) since which a complete InnoDB log archive is available. When [`innodb_log_archive`](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_log_archive) is `OFF`, the value advances to the latest checkpoint each time a log checkpoint is executed. When `innodb_log_archive` is `ON`, the value does not change — the archive is, by construction, complete from this LSN onward. The initial value at startup is taken from `innodb_log_archive_start`, or auto-detected from the available log files if that parameter is `0`.
* Scope: Global
* Data Type: `numeric`
* Introduced: MariaDB 13.0

#### `Innodb_master_thread_active_loops`

* Description: As shown in the BACKGROUND THREAD section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.0.9](/docs/release-notes/community-server/old-releases/10.0/10.0.9.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md):

#### `Innodb_master_thread_idle_loops`

* Description: As shown in the BACKGROUND THREAD section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.0.9](/docs/release-notes/community-server/old-releases/10.0/10.0.9.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md):

#### `Innodb_max_trx_id`

* Description: As shown in the TRANSACTIONS section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_mem_adaptive_hash`

* Description: As shown in the BUFFER POOL AND MEMORY section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_mem_dictionary`

* Description: As shown in the BUFFER POOL AND MEMORY section of the [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) output.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) (XtraDB-only), [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md)

#### `Innodb_num_index_pages_written`

* Description: Intended to show the number of index pages written. The code that updated the counter was lost, so it always returns `0`.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.0](/docs/release-notes/community-server/old-releases/10.1/10.1.0.md)
* Removed: [MariaDB 10.6.8](/docs/release-notes/community-server/10.6/10.6.8.md), [MariaDB 10.5.16](/docs/release-notes/community-server/old-releases/10.5/10.5.16.md), [MariaDB 10.4.25](/docs/release-notes/community-server/old-releases/10.4/10.4.25.md), [MariaDB 10.3.35](/docs/release-notes/community-server/old-releases/10.3/10.3.35.md)

#### `Innodb_num_non_index_pages_written`

* Description: Intended to show the number of non-index pages written. The code that updated the counter was lost, so it always returns `0`.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.1.0](/docs/release-notes/community-server/old-releases/10.1/10.1.0.md)
* Removed: [MariaDB 10.6.8](/docs/release-notes/community-server/10.6/10.6.8.md), [MariaDB 10.5.16](/docs/release-notes/community-server/old-releases/10.5/10.5.16.md), [MariaDB 10.4.25](/docs/release-notes/community-server/old-releases/10.4/10.4.25.md), [MariaDB 10.3.35](/docs/release-notes/community-server/old-releases/10.3/10.3.35.md)

#### `Innodb_num_open_files`

* Description: Number of open files held by InnoDB. InnoDB only.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_num_page_compressed_trim_op`

* Description: Number of trim operations performed.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_num_pages_decrypted`

* Description: Number of pages page decrypted. See [Table and Tablespace Encryption](/docs/server/security/encryption/data-at-rest-encryption/innodb-encryption.md).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_num_pages_encrypted`

* Description: Number of pages page encrypted. See [Table and Tablespace Encryption](/docs/server/security/encryption/data-at-rest-encryption/innodb-encryption.md).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_num_pages_page_compressed`

* Description: Number of pages that are page compressed.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_num_pages_page_compression_error`

* Description: Number of compression errors.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_num_pages_page_decompressed`

* Description: Number of pages compressed with page compression that are decompressed.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_onlineddl_pct_progress`

* Description: 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 [Monitoring progress and temporal memory usage of Online DDL in InnoDB](https://blog.mariadb.org/monitoring-progress-and-temporal-memory-usage-of-online-ddl-in-innodb).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_onlineddl_rowlog_pct_used`

* Description: Shows row log buffer usage in 5-digit integer (10000 means 100.00%). See [Monitoring progress and temporal memory usage of Online DDL in InnoDB](https://blog.mariadb.org/monitoring-progress-and-temporal-memory-usage-of-online-ddl-in-innodb).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_onlineddl_rowlog_rows`

* Description: Number of rows stored in the row log buffer. See [Monitoring progress and temporal memory usage of Online DDL in InnoDB](https://blog.mariadb.org/monitoring-progress-and-temporal-memory-usage-of-online-ddl-in-innodb).
* Scope: Global
* Data Type: `numeric`

#### `Innodb_os_log_fsyncs`

* Description: Number of InnoDB log fsync (sync-to-disk) requests.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.8](/docs/release-notes/community-server/old-releases/10.8/what-is-mariadb-108.md)

#### `Innodb_os_log_pending_fsyncs`

* Description: Number of pending InnoDB log fsync (sync-to-disk) requests.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.8](/docs/release-notes/community-server/old-releases/10.8/what-is-mariadb-108.md)

#### `Innodb_os_log_pending_writes`

* Description: Number of pending InnoDB log writes.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.8](/docs/release-notes/community-server/old-releases/10.8/what-is-mariadb-108.md)

#### `Innodb_os_log_written`

* Description: Number of bytes written to the InnoDB log.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_page_compression_saved`

* Description: Number of bytes saved by page compression.
* Scope:
* Data Type:

#### `Innodb_page_size`

* Description: Page size used by InnoDB. Defaults to 16KB, can be compiled with a different value.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_pages_created`

* Description: Number of InnoDB pages created.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_pages_read`

* Description: Number of InnoDB pages read.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_pages_written`

* Description: Number of InnoDB pages written.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_row_lock_current_waits`

* Description: Number of pending row lock waits on InnoDB tables.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_row_lock_time`

* Description: Total time in milliseconds spent getting InnoDB row locks.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_row_lock_time_avg`

* Description: Average time in milliseconds spent getting an InnoDB row lock.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_row_lock_time_max`

* Description: Maximum time in milliseconds spent getting an InnoDB row lock.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_row_lock_waits`

* Description: Number of times InnoDB had to wait before getting a row lock.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_rows_deleted`

* Description: Number of rows deleted from InnoDB tables that where not system tables. Almost equivalent to [Handler\_delete](/docs/server/server-management/variables-and-modes/server-status-variables.md#handler_delete) which does include system tables.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md)

#### `Innodb_rows_inserted`

* Description: Number of rows inserted into InnoDB tables that where not system tables. No direct equivalent in [Handler](/docs/server/server-management/variables-and-modes/server-status-variables.md#handler_commit) status variables.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md)

#### `Innodb_rows_read`

* Description: Number of rows read from InnoDB tables that where not system tables. Almost equivalent to the sum of [Handler\_read\*](/docs/server/server-management/variables-and-modes/server-status-variables.md#handler_read_first) status variables which do include system tables.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md)

#### `Innodb_rows_updated`

* Description: Number of rows updated in InnoDB tables that where not system tables. Almost equivalent to [Handler\_update](/docs/server/server-management/variables-and-modes/server-status-variables.md#handler_update) which does include system tables.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md)

#### `Innodb_secondary_index_triggered_cluster_reads`

* Description: Used to track the effectiveness of the Prefix Index Queries Optimization ([MDEV-6929](https://jira.mariadb.org/browse/MDEV-6929)). Removed in [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md) as the optimization is now always enabled.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md)

#### `Innodb_secondary_index_triggered_cluster_reads_avoided`

* Description: Used to track the effectiveness of the Prefix Index Queries Optimization ([MDEV-6929](https://jira.mariadb.org/browse/MDEV-6929)). Removed in [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md) as the optimization is now always enabled.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md)

#### `Innodb_system_rows_deleted`

* Description: Number of rows deleted on system tables.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md)

#### `Innodb_system_rows_inserted`

* Description: Number of rows inserted on system tables.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md)

#### `Innodb_system_rows_read`

* Description: Number of rows read on system tables.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.10.0](/docs/release-notes/community-server/old-releases/10.10/10.10.0.md)

#### `Innodb_system_rows_updated`

* Description: Number of rows updated on system tables.
* Scope: Global
* Data Type: `numeric`
* Removed: [MariaDB 10.10.0](/docs/release-notes/community-server/old-releases/10.10/10.10.0.md)

#### `Innodb_truncated_status_writes`

* Description: Number of times output from [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md) has been truncated.
* Scope: Global
* Data Type: `numeric`

#### `Innodb_undo_truncations`

* Description: Number of undo tablespace truncation operations.
* Scope: Global
* Data Type: `numeric`
* Introduced: [MariaDB 10.3.10](/docs/release-notes/community-server/old-releases/10.3/10.3.10.md)