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

Poor performance after upgrade from 10.1.14 to 10.1.16

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.16
    • 10.1.16
    • Optimizer
    • This problem was detected in a CentOS 7 and Fedora 23 environment

    Description

      After the upgrade from the 10.1.14 to 10.1.16, I have detected that some queries need a lot of time to be executed.

      When I have downgraded to the 10.1.14, I have checked that the problem has dissapeared. I have executed the mysql_upgrade after each upgrade.

      I attach some files that I expect that help you to understand the problem and fix it.

      • saltos-10.1.14.log => contains the log of all queries executed by SaltOS to get the list page - using a MariaDB 10.1.14.
      • saltos-10.1.16.log => contains the log of all queries executed by SaltOS to get the list page using a MariaDB 10.1.16.
      • query.sql => contains the conflictive query!!!
      • explain-10.1.14.log => contains the explain extended command for the previous query using a MariaDB 10.1.14.
      • explain-10.1.16.log => contains the explain extended command for the same query using a MariaDB 10.1.16.
      • schema.sql => contains the schema used by the SaltOS's database.
      • used-size.pdf => contains the real used size to understand the problem.

      Attachments

        1. explain-10.1.14.log
          2 kB
          Josep Sanz
        2. explain-10.1.16.log
          2 kB
          Josep Sanz
        3. explain-10.1.16-v2.log
          2 kB
          Josep Sanz
        4. query.sql
          3 kB
          Josep Sanz
        5. saltos-10.1.14.log
          14 kB
          Josep Sanz
        6. saltos-10.1.16.log
          14 kB
          Josep Sanz
        7. saltos-10.1.16-v2.log
          14 kB
          Josep Sanz
        8. schema.sql
          66 kB
          Josep Sanz
        9. used-size.pdf
          68 kB
          Josep Sanz

        Activity

          People

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