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

Explain output for SHOW EXPLAIN in the slow log looks useless

Details

    • Bug
    • Status: Open (View Workflow)
    • Trivial
    • Resolution: Unresolved
    • 10.0.10, 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
    • 10.5, 10.6
    • Optimizer
    • None

    Description

      In all attempts, I was never able to get any other "plan" than this for SHOW EXPLAIN in the slow log:

      # Time: 131009 20:35:29
      # User@Host: root[root] @ localhost [127.0.0.1]
      # Thread_id: 6  Schema: test  QC_hit: No
      # Query_time: 0.002340  Lock_time: 0.000849  Rows_sent: 1  Rows_examined: 1
      #
      #  id   select_type     table   type    possible_keys   key     key_len ref     rows    Extra
      #  1    SIMPLE  EXPLAIN ALL     NULL    NULL    NULL    NULL    NULL    
      #
      SET timestamp=1381336529;
      show explain for 4;

      If it's really going to be always the same, maybe it doesn't make sense to print it there at all.

      Attachments

        Issue Links

          Activity

            No workflow transitions have been executed yet.

            People

              psergei Sergei Petrunia
              elenst Elena Stepanova
              Votes:
              0 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.