Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18582

Port status variables related to SHOW ENGINE INNODB STATUS from XtraDB to InnoDB in 10.2+

    XMLWordPrintable

    Details

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: