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

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


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_x_lock_os_waits


Innodb_x_lock_spin_rounds


Innodb_x_lock_spin_waits


Comments

Comments loading...