InnoDB Server Status Variables

You are viewing an old version of this article. View the current version here.

Contents

  1. Innodb_adaptive_hash_cells
  2. Innodb_adaptive_hash_hash_searches
  3. Innodb_adaptive_hash_heap_buffers
  4. Innodb_adaptive_hash_non_hash_searches
  5. Innodb_available_undo_logs
  6. Innodb_background_log_sync
  7. Innodb_buffer_pool_bytes_data
  8. Innodb_buffer_pool_bytes_dirty
  9. Innodb_buffer_pool_dump_status
  10. Innodb_buffer_pool_load_incomplete
  11. Innodb_buffer_pool_load_status
  12. Innodb_buffer_pool_pages_data
  13. Innodb_buffer_pool_pages_dirty
  14. Innodb_buffer_pool_pages_flushed
  15. Innodb_buffer_pool_pages_LRU_flushed
  16. Innodb_buffer_pool_pages_free
  17. Innodb_buffer_pool_pages_made_not_young
  18. Innodb_buffer_pool_pages_made_young
  19. Innodb_buffer_pool_pages_misc
  20. Innodb_buffer_pool_pages_old
  21. Innodb_buffer_pool_pages_total
  22. Innodb_buffer_pool_read_ahead
  23. Innodb_buffer_pool_read_ahead_evicted
  24. Innodb_buffer_pool_read_ahead_rnd
  25. Innodb_buffer_pool_read_requests
  26. Innodb_buffer_pool_reads
  27. Innodb_buffer_pool_resize_status
  28. Innodb_buffer_pool_wait_free
  29. Innodb_buffer_pool_write_requests
  30. Innodb_buffered_aio_submitted
  31. Innodb_checkpoint_age
  32. Innodb_checkpoint_max_age
  33. Innodb_checkpoint_target_age
  34. Innodb_current_row_locks
  35. Innodb_data_fsyncs
  36. Innodb_data_pending_fsyncs
  37. Innodb_data_pending_reads
  38. Innodb_data_pending_writes
  39. Innodb_data_read
  40. Innodb_data_reads
  41. Innodb_data_writes
  42. Innodb_data_written
  43. Innodb_dblwr_pages_written
  44. Innodb_dblwr_writes
  45. Innodb_deadlocks
  46. Innodb_defragment_compression_failures
  47. Innodb_defragment_count
  48. Innodb_defragment_failures
  49. Innodb_dict_tables
  50. Innodb_encryption_n_merge_blocks_decrypted
  51. Innodb_encryption_n_merge_blocks_encrypted
  52. Innodb_encryption_n_rowlog_blocks_decrypted
  53. Innodb_encryption_n_rowlog_blocks_encrypted
  54. Innodb_encryption_num_key_requests
  55. Innodb_encryption_rotation_estimated_iops
  56. Innodb_encryption_rotation_pages_flushed
  57. Innodb_encryption_rotation_pages_modified
  58. Innodb_encryption_rotation_pages_read_from_cache
  59. Innodb_encryption_rotation_pages_read_from_disk
  60. Innodb_have_atomic_builtins
  61. Innodb_have_bzip2
  62. Innodb_have_lz4
  63. Innodb_have_lzma
  64. Innodb_have_lzo
  65. Innodb_have_punch_hole
  66. Innodb_have_snappy
  67. Innodb_history_list_length
  68. Innodb_ibuf_discarded_delete_marks
  69. Innodb_ibuf_discarded_deletes
  70. Innodb_ibuf_discarded_inserts
  71. Innodb_ibuf_free_list
  72. Innodb_ibuf_merged_delete_marks
  73. Innodb_ibuf_merged_deletes
  74. Innodb_ibuf_merged_inserts
  75. Innodb_ibuf_merges
  76. Innodb_ibuf_segment_size
  77. Innodb_ibuf_size
  78. Innodb_instant_alter_column
  79. Innodb_log_waits
  80. Innodb_log_write_requests
  81. Innodb_log_writes
  82. Innodb_lsn_current
  83. Innodb_lsn_flushed
  84. Innodb_lsn_last_checkpoint
  85. Innodb_master_thread_1_second_loops
  86. Innodb_master_thread_10_second_loops
  87. Innodb_master_thread_active_loops
  88. Innodb_master_thread_background_loops
  89. Innodb_master_thread_idle_loops
  90. Innodb_master_thread_main_flush_loops
  91. Innodb_master_thread_sleeps
  92. Innodb_max_trx_id
  93. Innodb_mem_adaptive_hash
  94. Innodb_mem_dictionary
  95. Innodb_mem_total
  96. Innodb_mutex_os_waits
  97. Innodb_mutex_spin_rounds
  98. Innodb_mutex_spin_waits
  99. Innodb_num_index_pages_written
  100. Innodb_num_non_index_pages_written
  101. Innodb_num_open_files
  102. Innodb_num_page_compressed_trim_op
  103. Innodb_num_page_compressed_trim_op_saved
  104. Innodb_num_pages_decrypted
  105. Innodb_num_pages_encrypted
  106. Innodb_num_pages_page_compressed
  107. Innodb_num_pages_page_compression_error
  108. Innodb_num_pages_page_decompressed
  109. Innodb_num_pages_page_encryption_error
  110. Innodb_oldest_view_low_limit_trx_id
  111. Innodb_onlineddl_pct_progress
  112. Innodb_onlineddl_rowlog_pct_used
  113. Innodb_onlineddl_rowlog_rows
  114. Innodb_os_log_fsyncs
  115. Innodb_os_log_pending_fsyncs
  116. Innodb_os_log_pending_writes
  117. Innodb_os_log_written
  118. Innodb_page_compression_saved
  119. Innodb_page_compression_trim_sect512
  120. Innodb_page_compression_trim_sect1024
  121. Innodb_page_compression_trim_sect2048
  122. Innodb_page_compression_trim_sect4096
  123. Innodb_page_compression_trim_sect8192
  124. Innodb_page_compression_trim_sect16384
  125. Innodb_page_compression_trim_sect32768
  126. Innodb_page_size
  127. Innodb_pages_created
  128. Innodb_pages_read
  129. Innodb_pages0_read
  130. Innodb_pages_written
  131. Innodb_purge_trx_id
  132. Innodb_purge_undo_no
  133. Innodb_read_views_memory
  134. Innodb_row_lock_current_waits
  135. Innodb_row_lock_numbers
  136. Innodb_row_lock_time
  137. Innodb_row_lock_time_avg
  138. Innodb_row_lock_time_max
  139. Innodb_row_lock_time_waits
  140. Innodb_rows_deleted
  141. Innodb_rows_inserted
  142. Innodb_rows_read
  143. Innodb_rows_updated
  144. Innodb_s_lock_os_waits
  145. Innodb_s_lock_spin_rounds
  146. Innodb_s_lock_spin_waits
  147. Innodb_scrub_background_page_reorganizations
  148. Innodb_scrub_background_page_split_failures_missing_index
  149. Innodb_scrub_background_page_split_failures_out_of_filespace
  150. Innodb_scrub_background_page_split_failures_underflow
  151. Innodb_scrub_background_page_split_failures_unknown
  152. Innodb_scrub_background_page_splits
  153. Innodb_scrub_log
  154. Innodb_secondary_index_triggered_cluster_reads
  155. Innodb_secondary_index_triggered_cluster_reads_avoided
  156. Innodb_system_rows_deleted
  157. Innodb_system_rows_inserted
  158. Innodb_system_rows_read
  159. Innodb_system_rows_updated
  160. Innodb_truncated_status_writes
  161. Innodb_undo_truncations
  162. Innodb_x_lock_os_waits
  163. Innodb_x_lock_spin_rounds
  164. Innodb_x_lock_spin_waits

See Server Status Variables for a complete list of status variables that can be viewed with SHOW STATUS.

Much of the InnoDB/XtraDB 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_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
  • Removed: MariaDB 10.0.0

Innodb_adaptive_hash_hash_searches


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
  • Removed: MariaDB 10.0.0

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. Reintroduced in MariaDB 10.5.0.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 5.5, MariaDB 10.5.0
  • Removed: MariaDB 10.0.0

Innodb_available_undo_logs


Innodb_background_log_sync


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


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

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

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

Innodb_buffer_pool_pages_data


Innodb_buffer_pool_pages_dirty


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


Innodb_buffer_pool_pages_free


Innodb_buffer_pool_pages_made_not_young


Innodb_buffer_pool_pages_made_young


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


Innodb_buffer_pool_pages_total


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


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_buffered_aio_submitted

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

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".) XtraDB only until introduced in MariaDB 10.5.0.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 5.5 (XtraDB-only), MariaDB 10.5.0

Innodb_checkpoint_max_age


Innodb_checkpoint_target_age


Innodb_current_row_locks


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

Innodb_data_reads

  • Description: Number of InnoDB read operations (not to be confused with 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.
  • Scope: Global
  • Data Type: numeric

Innodb_dblwr_pages_written


Innodb_dblwr_writes


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. XtraDB only until introduced in MariaDB 10.5.0.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 5.5 (XtraDB-only), MariaDB 10.5.0

Innodb_defragment_compression_failures


Innodb_defragment_count


Innodb_defragment_failures


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

Innodb_encryption_n_merge_blocks_decrypted


Innodb_encryption_n_merge_blocks_encrypted


Innodb_encryption_n_rowlog_blocks_decrypted


Innodb_encryption_n_rowlog_blocks_encrypted


Innodb_encryption_num_key_requests


Innodb_encryption_rotation_estimated_iops


Innodb_encryption_rotation_pages_flushed


Innodb_encryption_rotation_pages_modified


Innodb_encryption_rotation_pages_read_from_cache


Innodb_encryption_rotation_pages_read_from_disk


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. XtraDB only.
  • Scope: Global
  • Data Type: boolean

Innodb_have_bzip2


Innodb_have_lz4


Innodb_have_lzma


Innodb_have_lzo


Innodb_have_punch_hole

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

Innodb_have_snappy


Innodb_history_list_length


Innodb_ibuf_discarded_delete_marks


Innodb_ibuf_discarded_deletes


Innodb_ibuf_discarded_inserts


Innodb_ibuf_free_list


Innodb_ibuf_merged_delete_marks


Innodb_ibuf_merged_deletes


Innodb_ibuf_merged_inserts


Innodb_ibuf_merges


Innodb_ibuf_segment_size


Innodb_ibuf_size


Innodb_instant_alter_column


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


Innodb_lsn_flushed


Innodb_lsn_last_checkpoint


Innodb_master_thread_1_second_loops


Innodb_master_thread_10_second_loops


Innodb_master_thread_active_loops


Innodb_master_thread_background_loops


Innodb_master_thread_idle_loops


Innodb_master_thread_main_flush_loops


Innodb_master_thread_sleeps

  • Description: As shown in the BACKGROUND THREAD section of the SHOW ENGINE INNODB STATUS output. XtraDB only. 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
  • Removed: MariaDB 10.0

Innodb_max_trx_id


Innodb_mem_adaptive_hash


Innodb_mem_dictionary


Innodb_mem_total


Innodb_mutex_os_waits


Innodb_mutex_spin_rounds


Innodb_mutex_spin_waits


Innodb_num_index_pages_written


Innodb_num_non_index_pages_written


Innodb_num_open_files

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

Innodb_num_page_compressed_trim_op

  • Description: Number of trim operations performed.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.1.0

Innodb_num_page_compressed_trim_op_saved

  • Description: Number of trim operations not done because of an earlier trim.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.1.0

Innodb_num_pages_decrypted


Innodb_num_pages_encrypted


Innodb_num_pages_page_compressed

  • Description: Number of pages that are page compressed.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.1.0

Innodb_num_pages_page_compression_error

  • Description: Number of compression errors.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.1

Innodb_num_pages_page_decompressed

  • Description: Number of pages compressed with page compression that are decompressed.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.1.0

Innodb_num_pages_page_encryption_error


Innodb_oldest_view_low_limit_trx_id


Innodb_onlineddl_pct_progress


Innodb_onlineddl_rowlog_pct_used


Innodb_onlineddl_rowlog_rows


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_compression_saved


Innodb_page_compression_trim_sect512

  • Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 512 byte block-size.
  • Scope:
  • Data Type: numeric
  • Introduced: MariaDB 10.1.0, MariaDB 10.0.15 Fusion-io
  • Removed: MariaDB 10.2.4

Innodb_page_compression_trim_sect1024

  • Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 1K block-size.
  • Scope:
  • Data Type: numeric
  • Introduced: MariaDB 10.1.2, MariaDB 10.0.15 Fusion-io
  • Removed: MariaDB 10.2.4

Innodb_page_compression_trim_sect2048

  • Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 2K block-size.
  • Scope:
  • Data Type: numeric
  • Introduced: MariaDB 10.1.2, MariaDB 10.0.15 Fusion-io
  • Removed: MariaDB 10.2.4

Innodb_page_compression_trim_sect4096

  • Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 4K block-size.
  • Scope:
  • Data Type: numeric
  • Introduced: MariaDB 10.1.0, MariaDB 10.0.15 Fusion-io
  • Removed: MariaDB 10.2.4

Innodb_page_compression_trim_sect8192

  • Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 8K block-size.
  • Scope:
  • Data Type: numeric
  • Introduced: MariaDB 10.1.2, MariaDB 10.0.15 Fusion-io
  • Removed: MariaDB 10.2.4

Innodb_page_compression_trim_sect16384

  • Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 16K block-size.
  • Scope:
  • Data Type: numeric
  • Introduced: MariaDB 10.1.2, MariaDB 10.0.15 Fusion-io
  • Removed: MariaDB 10.2.4

Innodb_page_compression_trim_sect32768

  • Description: Number of TRIM operations performed for the page-compression/NVM Compression workload for the 32K block-size.
  • Scope:
  • Data Type: numeric
  • Introduced: MariaDB 10.1.2, MariaDB 10.0.15 Fusion-io
  • Removed: MariaDB 10.2.4

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_pages0_read

  • Description: 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 MariaDB 10.4.0 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
  • Introduced: MariaDB 10.2.4, MariaDB 10.1.21
  • Removed: MariaDB 10.4.0

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

Innodb_purge_undo_no


Innodb_read_views_memory

  • Description: As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output. Shows the total of memory in bytes allocated for the InnoDB read view. XtraDB only.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 5.5.32

Innodb_row_lock_current_waits

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

Innodb_row_lock_numbers


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


Innodb_s_lock_spin_rounds


Innodb_s_lock_spin_waits


Innodb_scrub_background_page_reorganizations


Innodb_scrub_background_page_split_failures_missing_index


Innodb_scrub_background_page_split_failures_out_of_filespace


Innodb_scrub_background_page_split_failures_underflow


Innodb_scrub_background_page_split_failures_unknown


Innodb_scrub_background_page_splits


Innodb_scrub_log


Innodb_secondary_index_triggered_cluster_reads

  • Description: Used to track the effectiveness of the Prefix Index Queries Optimization (MDEV-6929)
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.1.2

Innodb_secondary_index_triggered_cluster_reads_avoided

  • Description: Used to track the effectiveness of the Prefix Index Queries Optimization (MDEV-6929)
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.1.2

Innodb_system_rows_deleted


Innodb_system_rows_inserted


Innodb_system_rows_read


Innodb_system_rows_updated


Innodb_truncated_status_writes


Innodb_undo_truncations

  • Description: Number of undo tablespace truncation operations.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.3.10

Innodb_x_lock_os_waits


Innodb_x_lock_spin_rounds


Innodb_x_lock_spin_waits


Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.