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

Full table scan in INFORMATION_SCHEMA.PARAMETERS/ROUTINES

    XMLWordPrintable

    Details

      Description

      It seems there is an issue when querying on I_S.PARAMETERS table (used in java metadata) :
      when doing this kind of query (one result) :
      SELECT * FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_SCHEMA = 'testj' AND SPECIFIC_NAME = 'p2_512'
      It takes 15ms if 400 parameters in I_S.PARAMETERS table
      It takes 65ms if 4K parameters
      It takes 350ms if 20K parameters

      It seems to execute a full table scan in INFORMATION_SCHEMA.PARAMETERS

      The same query takes 6ms on mysql 8 with 20K same parameters

        Attachments

        1. mdev20609.diff
          8 kB
        2. screenshot-1.png
          screenshot-1.png
          5 kB
        3. screenshot-2.png
          screenshot-2.png
          18 kB

          Issue Links

            Activity

              People

              Assignee:
              oleg.smirnov Oleg Smirnov
              Reporter:
              diego dupin Diego Dupin
              Votes:
              2 Vote for this issue
              Watchers:
              15 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.