[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 All late releases affected with speed degradation for this kind of query Results for 5.6.10-linux-glibc2.5-x86_64: select now(); And for 5.5.31-linux2.6-x86_64: select now(); |
| 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. 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:
VM:
|