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

Performance issue on one request which is 200* slower than Mysql

    XMLWordPrintable

Details

    Description

      I had only one request which is 200* slower on MariaDB than Mysql. The others thousands of requests are in the same line or quicker with MariaDB.

      I can change the DB server by MariaDB and Mysql and reproduce it each time on Debian 7 on several servers (Virtual or production servers).

      I can not send the full database but only the request. It is store on a view. In the example attached, there is no performance issue with 'erp_view_supplyneeds_base', a SELECT take around 0.4 sec and then is well stored in cache, but only with 'erp_view_supplyneeds_global' on wich a SELECT take around 30 sec on MariaDB and is never stored in cache.

      Attachments

        1. example.sql.zip
          2 kB
        2. user.cnf
          0.6 kB
        3. MDEV-8076-MariaDB-10.1.19.txt
          27 kB
        4. MDEV-8076-MySQL-5.7.16.txt
          29 kB

        Activity

          People

            alice Alice Sherepa
            boutikcircus Nicolas Trossat
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.