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

SHOW EXPLAIN and PERFORMANCE_SCHEMA integration

    XMLWordPrintable

Details

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

    Description

      (Ideas based on initial discussion with stephanevaroqui in Budapest.

      SHOW EXPLAIN feature should be integrated with PERFORMANCE_SCHEMA.

      PERFORMANCE_SCHEMA has tables that describe statements together with information about their execution:

      1. events_statements_current
      2. events_statements_history
      3. events_statements_history_long
      4. events_statements_summary_by_digest

      #1-#3 have info about individual statements, #4 describes a group of statements with the same digest.

      As for #1-#3:
      The straightforward decision is to add a column with EXPLAIN info. On the other hand, it will add extra mem/cpu overhead for those who don't need it. Maybe, it is better to keep EXPLAINs in a separate table.

      As for #4, there is a question which query plans should be there. Maybe, we should provide query plans from the best and the worst execution? The idea about putting EXPLAINs in a separate table applies here, too.

      In case we store EXPLAINs in a separate table(s), we could use P_S.setup_consumers to control whether EXPLAINs would be saved.

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.