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

Poor performance after upgrade from 10.1.14 to 10.1.16

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.16
    • Fix Version/s: 10.1.16
    • Component/s: Optimizer
    • Environment:
      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
        2. explain-10.1.16.log
          2 kB
        3. explain-10.1.16-v2.log
          2 kB
        4. query.sql
          3 kB
        5. saltos-10.1.14.log
          14 kB
        6. saltos-10.1.16.log
          14 kB
        7. saltos-10.1.16-v2.log
          14 kB
        8. schema.sql
          66 kB
        9. used-size.pdf
          68 kB

          Activity

            People

            • Assignee:
              psergey Sergei Petrunia
              Reporter:
              sanz Josep Sanz
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: