[MDEV-8023] CREATE TEMPORARY TABLE ... SELECT on innodb is slower than on 5.1 Created: 2015-04-20  Updated: 2015-04-22

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5, 10.0, 10.1
Fix Version/s: 10.1

Type: Bug Priority: Minor
Reporter: Oleksandr Voytsekhovskyy Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: upstream, verified


 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



 Comments   
Comment by Elena Stepanova [ 2015-04-22 ]

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
Generated at Thu Feb 08 07:24:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.