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

CREATE TEMPORARY TABLE ... SELECT on innodb is slower than on 5.1

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.1, 10.0, 5.5
        • Fix Version/s: 10.1
        • Component/s: None
        • Labels:

          Description

          Originally posted in mysql bugs, but they don't do anything for 2 years
          http://bugs.mysql.com/bug.php?id=69219

          All late releases affected with speed degradation for this kind of query

          Results for 5.6.10-linux-glibc2.5-x86_64:

          select now();
          now()
          2013-05-13 23:25:23
          create temporary table norepl_t1 engine=myisam select amount, price, money, id_product from scj_tt_ships;
          select now();
          now()
          2013-05-13 23:25:39

          And for 5.5.31-linux2.6-x86_64:

          select now();
          now()
          2013-05-13 23:27:33
          create temporary table norepl_t1 engine=myisam select amount, price, money, id_product from scj_tt_ships;
          select now();
          now()
          2013-05-13 23:27:34

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #69219 - CREATE TEMPORARY TABLE ... SELECT is slower on 5.6 than on 5.1

                  Activity

                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  I could kind of reproduce it while running the test case from the upstream bug on MariaDB 5.1.67, 5.5.42, 10.0.17.
                  10.1 is affected too.

                  Notes: make sure you are not using /var/shm, it can affect results. Also, on some reason the difference was less visible on my VM, so if you aren't getting the problem, try to use a real box

                  Average results:

                  Real machine:

                    5.1.67 5.5.42 10.0.17
                  MyISAM 1 4 6
                  InnoDB 6 6 12

                  VM:

                    5.1.67 5.5.42 10.0.17
                  MyISAM 1 2 2.5
                  InnoDB 2 3 4.5
                  Show
                  elenst Elena Stepanova added a comment - I could kind of reproduce it while running the test case from the upstream bug on MariaDB 5.1.67, 5.5.42, 10.0.17. 10.1 is affected too. Notes: make sure you are not using /var/shm, it can affect results. Also, on some reason the difference was less visible on my VM, so if you aren't getting the problem, try to use a real box Average results: Real machine:   5.1.67 5.5.42 10.0.17 MyISAM 1 4 6 InnoDB 6 6 12 VM:   5.1.67 5.5.42 10.0.17 MyISAM 1 2 2.5 InnoDB 2 3 4.5

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      youngvan Oleksandr Voytsekhovskyy
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated: