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+

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

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25211 Remove useless counter Innodb_buffered_aio_submitted

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17237 thread IDs are printed in different formats in different sections of SHOW ENGINE INNODB STATUS output

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-18391 Print ENGINE INNODB STATUS in machine parsable format

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18429 Consistent non-locking reads do not appear in TRANSACTIONS section of SHOW ENGINE INNODB STATUS

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18572 Thread executing DROP TABLE listed twice in SHOW ENGINE INNODB STATUS output

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-18698 Show InnoDB's internal background threads in SHOW ENGINE INNODB STATUS

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21566 Lock monitor doesn't print a name for RW-latches

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22087 Increase buffer size for query in SHOW ENGINE INNODB STATUS output

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31308 InnoDB monitor trx_rseg_history_len was accidentally disabled by default

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21330 Lock monitor doesn't print a semaphore's last reserved thread in non-debug builds and INFORMATION_SCHEMA.INNODB_SYS_SEMAPHORE_WAITS is totally broken

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21390 lock_print_info_summary() should work even when trx_sys.mutex is locked

          • Major - Major loss of function.
          • Closed

          Activity

            monty Michael Widenius added a comment -

            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.

            monty Michael Widenius added a comment - 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.

            People

              marko Marko Mäkelä
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.