[MDEV-18582] Port status variables related to SHOW ENGINE INNODB STATUS from XtraDB to InnoDB in 10.2+ Created: 2019-02-14  Updated: 2023-05-19  Resolved: 2019-07-03

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Variables
Fix Version/s: 10.5.0

Type: Task Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Marko Mäkelä
Resolution: Fixed Votes: 2
Labels: None

Issue Links:
Problem/Incident
causes MDEV-25211 Remove useless counter Innodb_buffere... Closed
Relates
relates to MDEV-17237 thread IDs are printed in different f... Open
relates to MDEV-18391 Print ENGINE INNODB STATUS in machine... Open
relates to MDEV-18429 Consistent non-locking reads do not a... Closed
relates to MDEV-18572 Thread executing DROP TABLE listed tw... Open
relates to MDEV-18698 Show InnoDB's internal background thr... Open
relates to MDEV-21566 Lock monitor doesn't print a name for... Closed
relates to MDEV-22087 Increase buffer size for query in SHO... Open
relates to MDEV-31308 InnoDB monitor trx_rseg_history_len w... Closed
relates to MDEV-21330 Lock monitor doesn't print a semaphor... Closed
relates to MDEV-21390 lock_print_info_summary() should work... Closed

 Description   

XtraDB has convenient status variables to access information from SHOW ENGINE INNODB STATUS, such as:

  • Innodb_buffer_pool_pages_LRU_flushed
  • Innodb_buffer_pool_pages_made_not_young
  • Innodb_buffer_pool_pages_made_young
  • Innodb_buffer_pool_pages_old
  • Innodb_checkpoint_age
  • Innodb_checkpoint_max_age
  • Innodb_current_row_locks
  • 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_lsn_current
  • Innodb_lsn_flushed
  • Innodb_lsn_last_checkpoint
  • Innodb_master_thread_active_loops
  • Innodb_master_thread_idle_loops
  • 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_oldest_view_low_limit_trx_id
  • Innodb_purge_trx_id
  • Innodb_purge_undo_no
  • Innodb_read_views_memory
  • Innodb_s_lock_os_waits
  • Innodb_s_lock_spin_rounds
  • Innodb_s_lock_spin_waits
  • Innodb_x_lock_os_waits
  • Innodb_x_lock_spin_rounds
  • Innodb_x_lock_spin_waits

But InnoDB is used instead of XtraDB in 10.2 and later, and InnoDB doesn't have these status variables. It might be worthwhile to port them to InnoDB in 10.2 and later.

 Comments   
Comment by Michael Widenius [ 2020-05-27 ]

From the commit:

Many InnoDB internal variables and counters were only exposed in an unstructured fashion via
SHOW ENGINE INNODB STATUS.
Expose more variables via SHOW STATUS. Many of these were exported in XtraDB.
Also, introduce SHOW_SIZE_T and use the proper size for exporting the InnoDB variables.

Generated at Thu Feb 08 08:45:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.