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

Add InnoDB engine information to the slow query log

Details

    Description

      Percona server has some useful InnoDB status information in the slow query log.
      The Percona Performance Monitor can provide useful graphs from these

      This task is to add some of the most useful ones, but with less code.
      The code should also be engine independent, so that it is easy to add
      monitoring of other engines!

      The current task will add the following new information to the slow query log if enabled with
      --log-slow-verbosity=innodb

       # Pages_accessed: 184  Pages_read: 95  Pages_updated: 0  Undo_rows_read: 1
      		 
       # Pages_read_time: 17.0204  Engine_time: 248.1297

      Engine_time is how many milliseconds is spent inside engine calls (similar as with analyze).
      Page_* variables are for now only for InnoDB.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30875 main.analyze_stmt_orderby/rowid_filter_innodb/explain_json_format_partitions (+ 7 more) fails on Launchpad armhf builders

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-32159 AIX crash on mariadbd --bootstrap - invalid mariadb_stats pointer

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32910 cycles can overflow and result in large explain json=X measurements

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34296 extern thread_local is a CPU waste

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

          Task - A task that needs to be done. MDEV-31577 Make ANALYZE FORMAT=JSON print innodb stats

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31589 Secondary index MVCC access is unnecessarily inefficient

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34190 ANALYZE: r_engine_stats shows unrealistically low pages_read_count

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Michael Widenius made transition -
            Open In Progress
            		9d 19h 27m 1
            Michael Widenius made transition -
            In Progress Closed
            		4h 38m 1

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.