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

merge new P_S instrumentation and tables from 5.7

Details

    • 10.2.2-1, 10.2.2-3, 10.2.2-4

    Description

      Meta task to merge new P_S instrumentation and tables from 5.7

      See linked tasks. After they're all closed, one still needs to compare tables and their structures with 5.7 and to implement whatever was not covered by linked tasks.

      Done and released with MariaDB 10.5.2 everything except:

      • sysvars instrumentation
      • replication instrumentation
      • group replication Instrumentation

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-9067 performance_schema from 5.7

          • Major - Major loss of function.
          • Closed
          includes

          Task - A task that needs to be done. MDEV-16340 Implement way to determine which connections are using SSL/TLS

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16431 merge 5.7 P_S memory instrumentation and tables

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16432 merge 5.7 P_S mdl instrumentation and tables

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16433 merge 5.7 P_S ps instrumentation and tables

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16434 merge 5.7 P_S sp instrumentation and tables

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16435 merge 5.7 P_S transaction instrumentation and tables

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16436 merge 5.7 P_S sxlocks instrumentation and tables

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16437 merge 5.7 P_S replication instrumentation and tables

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

          Task - A task that needs to be done. MDEV-16438 merge 5.7 P_S [show] status instrumentation and tables

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16439 merge 5.7 P_S user variables instrumentation and tables

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-16440 merge 5.7 P_S sysvars instrumentation and tables

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

          Task - A task that needs to be done. MDEV-16437 merge 5.7 P_S replication instrumentation and tables

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

          Task - A task that needs to be done. MDEV-16441 merge 5.7 P_S group replication instrumentation and tables

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-24310 Implement option to allow performance schema to persist server shutdowns and restarts

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15798 Mutex leak on accessing INFORMATION_SCHEMA.INNODB_MUTEXES

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-24388 Implement schema_unused_indexes in performance_schema or sys schema

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

          Activity

            Ascending order - Click to sort in descending order
            leafonsword guo feng added a comment -

            Hope sys schema comes soon!

            leafonsword guo feng added a comment - Hope sys schema comes soon!
            ccalender Chris Calender (Inactive) added a comment -

            Can this fix please be added to 10.1 instead of 10.2?

            I don't think it should matter so long as only new tables are being added.

            Many thanks for your consideration.

            ccalender Chris Calender (Inactive) added a comment - Can this fix please be added to 10.1 instead of 10.2? I don't think it should matter so long as only new tables are being added. Many thanks for your consideration.
            serg Sergei Golubchik added a comment -

            No, it can not. "Adding new P_S tables" means doing lots of changes inside the server to all all the necessary instrumentation.

            serg Sergei Golubchik added a comment - No, it can not. "Adding new P_S tables" means doing lots of changes inside the server to all all the necessary instrumentation.
            jonathan.day@mariadb.com Jonathan Day (Inactive) added a comment - - edited

            I have a large prospect interested in tracking prepared statements. I believe the "prepared_statements_instance" table is needed in particular. Thanks!

            jonathan.day@mariadb.com Jonathan Day (Inactive) added a comment - - edited I have a large prospect interested in tracking prepared statements. I believe the "prepared_statements_instance" table is needed in particular. Thanks!
            marko Marko Mäkelä added a comment -

            As part of doing this, I suggest considering the patch that is attached to MDEV-15798. It removes InnoDB rw_lock_list, the table information_schema.innodb_mutexes and the show engine innodb mutex output.

            marko Marko Mäkelä added a comment - As part of doing this, I suggest considering the patch that is attached to MDEV-15798 . It removes InnoDB rw_lock_list , the table information_schema.innodb_mutexes and the show engine innodb mutex output.

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              14 Vote for this issue
              Watchers:
              23 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.