XtraDB/InnoDB Server Status Variables

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.

Innodb_adaptive_hash_cells

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output. This Percona XtraDB variable has not been ported to XtraDB 5.6.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20
• Removed: MariaDB 10.0

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 output. Removed in Percona's XtraDB 5.6 and replaced with the adaptive_hash_searches counter in the INFORMATION_SCHEMA.INNODB_METRICS table in Percona 5.6 - MariaDB 10.0 has no equivalent.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20
• Removed: MariaDB 10.0/XtraDB 5.6

Innodb_adaptive_hash_heap_buffers

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output. This Percona XtraDB variable has not been ported to XtraDB 5.6.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20
• Removed: MariaDB 10.0/XtraDB 5.6

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 output. Removed in Percona's XtraDB 5.6 and replaced with the adaptive_hash_searches_btree counter in the INFORMATION_SCHEMA.INNODB_METRICS table in Percona 5.6 - MariaDB 10.0 has no equivalent.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20
• Removed: MariaDB 10.0/XtraDB 5.6

Innodb_available_undo_logs

• Description: Total number available InnoDB undo logs. Differs from MariaDB 10.0/MySQL 5.6's innoDB_undo_logs system variable, which specifies the number of active undo logs.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5

Innodb_background_log_sync

• Description: As shown in the BACKGROUND THREAD section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_buffer_pool_bytes_data

• Description: Number of bytes contained in the InnoDB buffer pool, both dirty (modified) and clean (unmodified). See also 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. See also 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:
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 10.0/MySQL 5.6

Innodb_buffer_pool_load_status

• Description:
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 10.0

Innodb_buffer_pool_pages_data

• Description: Number of InnoDB buffer pool pages which contain data, both dirty (modified) and clean (unmodified). See also Innodb_buffer_pool_bytes_data.
• Scope: Global
• Data Type: numeric

Innodb_buffer_pool_pages_dirty

• Description: Number of InnoDB buffer pool pages which contain dirty (modified) data. See also Innodb_buffer_pool_bytes_dirty.
• Scope: Global
• Data Type: numeric

Innodb_buffer_pool_pages_flushed

• Description: Number of InnoDB buffer pool 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 output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_buffer_pool_pages_free

• Description: Number of free InnoDB buffer pool 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 output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

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 output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_buffer_pool_pages_misc

• Description: Number of InnoDB buffer pool 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 output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_buffer_pool_pages_total

• Description: Total number of InnoDB buffer pool pages.
• Scope: Global
• Data Type: numeric

Innodb_buffer_pool_read_ahead_rnd

• Description: Number of random read-aheads.
• Scope: Global
• Data Type: numeric
• Removed: MySQL 5.1.41#

Innodb_buffer_pool_read_ahead

• Description: Number of pages read into the InnoDB buffer pool 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 by the read-ahead background thread that were evicted without having been accessed by queries.
• Scope: Global
• Data Type: numeric

Innodb_buffer_pool_read_requests

• Description: Number of requests to read from the InnoDB buffer pool.
• Scope: Global
• Data Type: numeric

Innodb_buffer_pool_reads

• Description: Number of reads that could not be satisfied by the InnoDB buffer pool and had to be read from disk.
• Scope: Global
• Data Type: numeric

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 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.
• Scope: Global
• Data Type: numeric

Innodb_buffer_pool_write_requests

• Description: Number of requests to write to the InnoDB buffer pool.
• Scope: Global
• Data Type: numeric

Innodb_checkpoint_age

• Description: The checkpoint age, as shown in the LOG section of the SHOW ENGINE INNODB STATUS output. (This is equivalent to subtracting "Last checkpoint at" from "Log sequence number".)
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_checkpoint_max_age

• Description: Max checkpoint age, as shown in the LOG section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_checkpoint_target_age

• Description: Checkpoint age target, as shown in the LOG section of the SHOW ENGINE INNODB STATUS output. Removed in MariaDB 10.0/XtraDB 5.6 and replaced with MySQL 5.6's flushing implementation.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20
• Removed: MariaDB 10.0 / XtraDB 5.6

Innodb_current_row_locks

• Description: Number of current row locks on InnoDB tables as shown in the TRANSACTIONS section of the SHOW ENGINE INNODB STATUS output. Renamed from InnoDB_row_lock_numbers in XtraDB 5.5.8-20.1.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-21

Innodb_data_fsyncs

• Description: Number of InnoDB fsync (sync-to-disk) calls. fsync call frequency can be influenced by the 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 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 server startup.
• Scope: Global
• Data Type: numeric

Innodb_dblwr_pages_written

• Description: Number of pages written to the InnoDB doublewrite buffer.
• Scope: Global
• Data Type: numeric

Innodb_dblwr_writes

• Description: Number of writes to the InnoDB doublewrite buffer.
• 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 / XtraDB 5.5.8-20

Innodb_dict_tables

• Description: 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 table_definition_cache implementation.
• Scope: Global
• Data Type: numeric
• Introduced: XtraDB 5.0.77-b13
• Removed: MariaDB 10.0 / XtraDB 5.6

Innodb_have_atomic_builtins

• Description: Whether the server has been built with atomic instructions, provided by the CPU ensuring that critical low-level operations can't be interrupted.
• Scope: Global
• Data Type: boolean

Innodb_history_list_length

• Description: History list length as shown in the TRANSACTIONS section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_ibuf_discarded_delete_marks

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_ibuf_discarded_deletes

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_ibuf_discarded_inserts

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_ibuf_free_list

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_ibuf_merged_delete_marks

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_ibuf_merged_deletes

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_ibuf_merged_inserts

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_ibuf_merges

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_ibuf_segment_size

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_ibuf_size

• Description: As shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

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 output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_lsn_flushed

• Description: Flushed up to log sequence number as shown in the LOG section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_lsn_last_checkpoint

• Description: Log sequence number last checkpoint as shown in the LOG section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_master_thread_1_second_loops

• Description: As shown in the BACKGROUND THREAD section of the SHOW ENGINE INNODB STATUS output. Removed in MariaDB 10.0/XtraDB 5.6 as MySQL 5.6's new InnoDB master thread behavior has made this redundant.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20
• Removed: MariaDB 10.0/XtraDB 5.6

Innodb_master_thread_10_second_loops

• Description: As shown in the BACKGROUND THREAD section of the SHOW ENGINE INNODB STATUS output. Removed in MariaDB 10.0/XtraDB 5.6 as MySQL 5.6's new InnoDB master thread behavior has made this redundant.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20
• Removed: MariaDB 10.0/XtraDB 5.6

Innodb_master_thread_background_loops

• Description: As shown in the BACKGROUND THREAD section of the SHOW ENGINE INNODB STATUS output. Removed in MariaDB 10.0/XtraDB 5.6 as MySQL 5.6's new InnoDB master thread behavior has made this redundant.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20
• Removed: MariaDB 10.0/XtraDB 5.6

Innodb_master_thread_main_flush_loops

• Description: As shown in the BACKGROUND THREAD section of the SHOW ENGINE INNODB STATUS output. Removed in MariaDB 10.0/XtraDB 5.6 as MySQL 5.6's new InnoDB master thread behavior has made this redundant.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20
• Removed: MariaDB 10.0/XtraDB 5.6

Innodb_master_thread_sleeps

• Description: As shown in the BACKGROUND THREAD section of the SHOW ENGINE INNODB STATUS output. Removed in Percona's XtraDB 5.6 and replaced with the innodb_master_thread_sleeps counter in the INFORMATION_SCHEMA.INNODB_METRICS table in Percona 5.6 - MariaDB 10.0 has no equivalent.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20
• Removed: MariaDB 10.0/XtraDB 5.6

Innodb_max_trx_id

• Description: As shown in the TRANSACTIONS section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_mem_adaptive_hash

• Description: As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_mem_dictionary

• Description: As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_mem_total

• Description: As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_mutex_os_waits

• Description: Mutex OS waits as shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_mutex_spin_rounds

• Description: Mutex spin rounds as shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_mutex_spin_waits

• Description: Mutex spin waits as shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_num_open_files

• Description: Number of open files held by InnoDB.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 10.0

Innodb_oldest_view_low_limit_trx_id

• Description: As shown in the TRANSACTIONS section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_os_log_fsyncs

• Description: Number of InnoDB log fsync (sync-to-disk) requests.
• Scope: Global
• Data Type: numeric

Innodb_os_log_pending_fsyncs

• Description: Number of pending InnoDB log fsync (sync-to-disk) requests.
• Scope: Global
• Data Type: numeric

Innodb_os_log_pending_writes

• Description: Number of pending InnoDB log writes.
• Scope: Global
• Data Type: numeric

Innodb_os_log_written

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

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_purge_trx_id

• Description: Purge transaction id as shown in the TRANSACTIONS section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_purge_undo_no

• Description: As shown in the TRANSACTIONS section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_row_lock_current_waits

• Description: Number of pending row locks on InnoDB tables.
• Scope: Global
• Data Type: numeric

Innodb_row_lock_numbers

• Description: Number of current row locks on InnoDB tables as shown in the TRANSACTIONS section of the SHOW ENGINE INNODB STATUS output. Renamed to InnoDB_current_row_locks in XtraDB 5.5.10-20.1.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20
• Removed: MariaDB 5.5 / XtraDB 5.5.10-20.1

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 InnoDB row locks.
• 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_time_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.
• Scope: Global
• Data Type: numeric

Innodb_rows_inserted

• Description: Number of rows inserted into InnoDB tables.
• Scope: Global
• Data Type: numeric

Innodb_rows_read

• Description: Number of rows read from InnoDB tables.
• Scope: Global
• Data Type: numeric

Innodb_rows_updated

• Description: Number of rows updated in InnoDB tables.
• Scope: Global
• Data Type: numeric

Innodb_s_lock_os_waits

• Description: As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_s_lock_spin_rounds

• Description: As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_s_lock_spin_waits

• Description: As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_truncated_status_writes

• Description: Number of times output from SHOW ENGINE INNODB STATUS has been truncated.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB/MySQL 5.5

Innodb_x_lock_os_waits

• Description: As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_x_lock_spin_rounds

• Description: As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20

Innodb_x_lock_spin_waits

• Description: As shown in the SEMAPHORES section of the SHOW ENGINE INNODB STATUS output.
• Scope: Global
• Data Type: numeric
• Introduced: MariaDB 5.5 / XtraDB 5.5.8-20