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

Enable "inexpensive" PERFORMANCE_SCHEMA tables even when "performance_schema=OFF"

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None

    Description

      Right now PERFORMANCE_SCHEMA is all-or-nothing.

      Some P_S tables show information from the code instrumentation, it adds a noticeable run-time performance overhead and it makes perfect sense to be able to disable it.

      Other P_S tables, such as P_S.SESSION_CONNECT_ATTRS, only show the existing information and have zero overhead unless they're queried. It does not make sense to disable them, they should be always available.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-6726 CONNECTION_ATTRS not stored in performance schema

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-15623 Show temporary tables for all sessions in performance schema

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-29942 Provide insight on proxy_protocol usage

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              hholzgra Hartmut Holzgraefe
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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