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

Massive performance impact after PTI fix

    XMLWordPrintable

Details

    Description

      Hello

      I have just applied the PTI patch on the OS and it is causing a massive difference in the execution time of a specific query.

      Disabling and reenabling PTI enables me to reproduce the difference at will :

      PTI disabled : 7s
      PTI enabled : 87s

      The query :

      SELECT * FROM `test` as b1 WHERE b1.`dateFin` > '2018-01-24' AND NOT EXISTS (SELECT 1 FROM `test` as b2 WHERE b2.`ip` = b1.`ip` AND b2.`dateFin` > b1.`dateFin`);
      

      Explain doesn't help much :

      +------+--------------------+-------+------+---------------+------+---------+------+------+-------------+
      | id   | select_type        | table | type | possible_keys | key  | key_len | ref  | rows | Extra       |
      +------+--------------------+-------+------+---------------+------+---------+------+------+-------------+
      |    1 | PRIMARY            | b1    | ALL  | NULL          | NULL | NULL    | NULL | 4499 | Using where |
      |    2 | DEPENDENT SUBQUERY | b2    | ALL  | NULL          | NULL | NULL    | NULL | 4499 | Using where |
      +------+--------------------+-------+------+---------------+------+---------+------+------+-------------+
      

      Can't see any report matching that kind of difference so far so i'm wondering what's up

      Attachments

        1. test.sql.gz
          43 kB
          Jean-Marc Messina
        2. test.sql.gz
          6 kB
          Jean-Marc Messina

        Issue Links

          Activity

            People

              axel Axel Schwenke
              falcoris Jean-Marc Messina
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.