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

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_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_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 512K block-size.
  • Scope:
  • Data Type: numeric
  • Introduced: MariaDB 10.1.0, MariaDB 10.0.15 Fusion-io

Innodb_page_compression_trim_sect1024

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

Innodb_page_compression_trim_sect2048

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

Innodb_page_compression_trim_sect4096

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

Innodb_page_compression_trim_sect8192

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

Innodb_page_compression_trim_sect16384

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

Innodb_page_compression_trim_sect32768

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

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

  • 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


Innodb_x_lock_spin_rounds


Innodb_x_lock_spin_waits


Comments

Comments loading...
Loading