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

Querying INFORMATION_SCHEMA becomes slow in MariaDB 10.1

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.1.19, 10.1.24, 10.1(EOL), 10.2(EOL)
    • 10.1.29, 10.2.10, 10.3.3
    • Admin statements
    • None
    • 10.2.10

    Description

      Querying INFORMATION_SCHEMA repeatedly using CentOS 6 becomes slow in MariaDB 10.1 (10.1.19, 10.1.24).

      With a basic table, and simple repeated SELECT from I_S, on CentOS 6, thus far, we see a slowdown. It remains sub-second from my testing on Windows, even up to 2K iterations.

      I will provide the CREATE TABLE and test case in a private comment.

      Here are a sample of times from 10.1.19 (compared to times on MySQL 5.5 and 5.6) on CentOS 6.8:

      MariaDB 10.1.19
      		 
      real 0m16.970s
      		 
      user 0m2.804s
      		 
      sys 0m0.303s
      		 
       
      MySQL 5.6.16
      		 
      real 0m11.291s
      		 
      user 0m2.331s
      		 
      sys 0m0.280s
      		 
       
      MySQL 5.5.36
      		 
      real 0m7.246s
      		 
      user 0m2.349s
      		 
      sys 0m0.277s

      And here are times from Elena (10.1.24 on CentOS 6.2) using test case provided:

      real    0m4.699s
      		 
      user    0m1.641s
      		 
      sys     0m2.590s

      This latter one is faster than the first one, but still not sub-second.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          ccalender Chris Calender (Inactive) created issue -
          ccalender Chris Calender (Inactive) made changes -
          Field Original Value New Value
          Description Querying INFORMATION_SCHEMA repeatedly using CentOS 6 becomes slow in MariaDB 10.1 (10.1.19, 10.1.24).

          With a basic table, and simple repeated SELECT from I_S, on CentOS 6, thus far, we see a slowdown. It remains sub-second from my testing on Windows, even up to 2K iterations.

          I will provide the CREATE TABLE and test case in a private comment.           		Querying INFORMATION_SCHEMA repeatedly using CentOS 6 becomes slow in MariaDB 10.1 (10.1.19, 10.1.24).

          With a basic table, and simple repeated SELECT from I_S, on CentOS 6, thus far, we see a slowdown. It remains sub-second from my testing on Windows, even up to 2K iterations.

          I will provide the CREATE TABLE and test case in a private comment.

          Here are a sample of times from 10.1.19 (compared to times on MySQL 5.5 and 5.6) on CentOS 6.8:

          {code}
          MariaDB 10.1.19
          real 0m16.970s
          user 0m2.804s
          sys 0m0.303s
           
          MySQL 5.6.16
          real 0m11.291s
          user 0m2.331s
          sys 0m0.280s
           
          MySQL 5.5.36
          real 0m7.246s
          user 0m2.349s
          sys 0m0.277s
          {code}


          And here are times from Elena (10.1.24 on CentOS 6.2) using test case provided:

          {code}
          real 0m4.699s
          user 0m1.641s
          sys 0m2.590s
          {code}

          This latter one is faster than the first one, but still not sub-second.
          elenst Elena Stepanova made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          elenst Elena Stepanova made changes -
          Fix Version/s 10.1 [ 16100 ]
          Assignee Sergei Golubchik [ serg ]
          elenst Elena Stepanova made changes -
          Fix Version/s 10.2 [ 14601 ]
          Affects Version/s 10.1 [ 16100 ]
          Affects Version/s 10.2 [ 14601 ]
          ccalender Chris Calender (Inactive) made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          serg Sergei Golubchik made changes -
          Sprint 10.2.10 [ 183 ]
          serg Sergei Golubchik made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Summary Querying INFORMATION_SCHEMA repeatedly using CentOS 6 becomes slow in MariaDB 10.1 (10.1.19, 10.1.24) Querying INFORMATION_SCHEMA repeatedly using CentOS 6 becomes slow in MariaDB 10.1
          serg Sergei Golubchik made changes -
          Summary Querying INFORMATION_SCHEMA repeatedly using CentOS 6 becomes slow in MariaDB 10.1 Querying INFORMATION_SCHEMA becomes slow in MariaDB 10.1
          serg Sergei Golubchik made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          serg Sergei Golubchik made changes -
          Component/s Admin statements [ 11400 ]
          Fix Version/s 10.1.29 [ 22636 ]
          Fix Version/s 10.2.10 [ 22615 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.1 [ 16100 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          bar Alexander Barkov made changes -
          Assignee Sergei Golubchik [ serg ] Alexander Barkov [ bar ]
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Stalled [ 10000 ]
          bar Alexander Barkov made changes -
          Assignee Alexander Barkov [ bar ] Sergei Golubchik [ serg ]
          bar Alexander Barkov made changes -
          Fix Version/s 10.3.3 [ 22644 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          ccalender Chris Calender (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Stalled [ 10000 ]
          serg Sergei Golubchik made changes -
          Labels need_feedback
          ccalender Chris Calender (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          julien.fritsch Julien Fritsch made changes -
          Labels need_feedback
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 81183 ] MariaDB v4 [ 152304 ]
          mariadb-jira-automation Jira Automation (IT) made changes -
          Zendesk Related Tickets 133145

          People

            serg Sergei Golubchik
            ccalender Chris Calender (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            9 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.