InnoDB Server Status Variables

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_checkpoint_age
  31. Innodb_checkpoint_max_age
  32. Innodb_checkpoint_target_age
  33. Innodb_current_row_locks
  34. Innodb_data_fsyncs
  35. Innodb_data_pending_fsyncs
  36. Innodb_data_pending_reads
  37. Innodb_data_pending_writes
  38. Innodb_data_read
  39. Innodb_data_reads
  40. Innodb_data_writes
  41. Innodb_data_written
  42. Innodb_dblwr_pages_written
  43. Innodb_dblwr_writes
  44. Innodb_deadlocks
  45. Innodb_defragment_compression_failures
  46. Innodb_defragment_count
  47. Innodb_defragment_failures
  48. Innodb_dict_tables
  49. Innodb_encryption_n_merge_blocks_decrypted
  50. Innodb_encryption_n_merge_blocks_encrypted
  51. Innodb_encryption_n_rowlog_blocks_decrypted
  52. Innodb_encryption_n_rowlog_blocks_encrypted
  53. Innodb_encryption_num_key_requests
  54. Innodb_encryption_rotation_estimated_iops
  55. Innodb_encryption_rotation_pages_flushed
  56. Innodb_encryption_rotation_pages_modified
  57. Innodb_encryption_rotation_pages_read_from_cache
  58. Innodb_encryption_rotation_pages_read_from_disk
  59. Innodb_have_atomic_builtins
  60. Innodb_have_bzip2
  61. Innodb_have_lz4
  62. Innodb_have_lzma
  63. Innodb_have_lzo
  64. Innodb_have_punch_hole
  65. Innodb_have_snappy
  66. Innodb_history_list_length
  67. Innodb_ibuf_discarded_delete_marks
  68. Innodb_ibuf_discarded_deletes
  69. Innodb_ibuf_discarded_inserts
  70. Innodb_ibuf_free_list
  71. Innodb_ibuf_merged_delete_marks
  72. Innodb_ibuf_merged_deletes
  73. Innodb_ibuf_merged_inserts
  74. Innodb_ibuf_merges
  75. Innodb_ibuf_segment_size
  76. Innodb_ibuf_size
  77. Innodb_instant_alter_column
  78. Innodb_log_waits
  79. Innodb_log_write_requests
  80. Innodb_log_writes
  81. Innodb_lsn_current
  82. Innodb_lsn_flushed
  83. Innodb_lsn_last_checkpoint
  84. Innodb_master_thread_1_second_loops
  85. Innodb_master_thread_10_second_loops
  86. Innodb_master_thread_active_loops
  87. Innodb_master_thread_background_loops
  88. Innodb_master_thread_idle_loops
  89. Innodb_master_thread_main_flush_loops
  90. Innodb_master_thread_sleeps
  91. Innodb_max_trx_id
  92. Innodb_mem_adaptive_hash
  93. Innodb_mem_dictionary
  94. Innodb_mem_total
  95. Innodb_mutex_os_waits
  96. Innodb_mutex_spin_rounds
  97. Innodb_mutex_spin_waits
  98. Innodb_num_index_pages_written
  99. Innodb_num_non_index_pages_written
  100. Innodb_num_open_files
  101. Innodb_num_page_compressed_trim_op
  102. Innodb_num_page_compressed_trim_op_saved
  103. Innodb_num_pages_decrypted
  104. Innodb_num_pages_encrypted
  105. Innodb_num_pages_page_compressed
  106. Innodb_num_pages_page_compression_error
  107. Innodb_num_pages_page_decompressed
  108. Innodb_num_pages_page_encryption_error
  109. Innodb_oldest_view_low_limit_trx_id
  110. Innodb_onlineddl_pct_progress
  111. Innodb_onlineddl_rowlog_pct_used
  112. Innodb_onlineddl_rowlog_rows
  113. Innodb_os_log_fsyncs
  114. Innodb_os_log_pending_fsyncs
  115. Innodb_os_log_pending_writes
  116. Innodb_os_log_written
  117. Innodb_page_compression_saved
  118. Innodb_page_compression_trim_sect512
  119. Innodb_page_compression_trim_sect1024
  120. Innodb_page_compression_trim_sect2048
  121. Innodb_page_compression_trim_sect4096
  122. Innodb_page_compression_trim_sect8192
  123. Innodb_page_compression_trim_sect16384
  124. Innodb_page_compression_trim_sect32768
  125. Innodb_page_size
  126. Innodb_pages_created
  127. Innodb_pages_read
  128. Innodb_pages0_read
  129. Innodb_pages_written
  130. Innodb_purge_trx_id
  131. Innodb_purge_undo_no
  132. Innodb_read_views_memory
  133. Innodb_row_lock_current_waits
  134. Innodb_row_lock_numbers
  135. Innodb_row_lock_time
  136. Innodb_row_lock_time_avg
  137. Innodb_row_lock_time_max
  138. Innodb_row_lock_time_waits
  139. Innodb_rows_deleted
  140. Innodb_rows_inserted
  141. Innodb_rows_read
  142. Innodb_rows_updated
  143. Innodb_s_lock_os_waits
  144. Innodb_s_lock_spin_rounds
  145. Innodb_s_lock_spin_waits
  146. Innodb_scrub_background_page_reorganizations
  147. Innodb_scrub_background_page_split_failures_missing_index
  148. Innodb_scrub_background_page_split_failures_out_of_filespace
  149. Innodb_scrub_background_page_split_failures_underflow
  150. Innodb_scrub_background_page_split_failures_unknown
  151. Innodb_scrub_background_page_splits
  152. Innodb_scrub_log
  153. Innodb_secondary_index_triggered_cluster_reads
  154. Innodb_secondary_index_triggered_cluster_reads_avoided
  155. Innodb_system_rows_deleted
  156. Innodb_system_rows_inserted
  157. Innodb_system_rows_read
  158. Innodb_system_rows_updated
  159. Innodb_truncated_status_writes
  160. Innodb_undo_truncations
  161. Innodb_x_lock_os_waits
  162. Innodb_x_lock_spin_rounds
  163. 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

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

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

  • Description: Flush list as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output. XtraDB only.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Innodb_buffer_pool_pages_free


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

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

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

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

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

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

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

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

  • Description: History list length 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_ibuf_discarded_delete_marks

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

Innodb_ibuf_discarded_deletes

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

Innodb_ibuf_discarded_inserts

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

Innodb_ibuf_free_list

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

Innodb_ibuf_merged_delete_marks

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

Innodb_ibuf_merged_deletes

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

Innodb_ibuf_merged_inserts

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

Innodb_ibuf_merges

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

Innodb_ibuf_segment_size

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

Innodb_ibuf_size

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

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

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

Innodb_lsn_last_checkpoint

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

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

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

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