Details
-
Type:
Task
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
Axel,
we're now in the same situation as we were in the previous iteration. In order to narrow down the problem, I need to get benchmark results and profiles for the simplified queries.
The queries are provided below; they should be ran on MyISAM, multiple times. Please check MariaDB 5.5 (with "the fix"), MariaDB 5.3, and MySQL 5.5.
I need profiles also. If one can observe a meaningful difference between different versions, please pick the runs that show the difference.
The queries:
explain
select
sum(l_quantity) as sum_qty,
sum(l_extendedprice) as sum_base_price,
sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
avg(l_quantity) as avg_qty,
avg(l_extendedprice) as avg_price,
avg(l_discount) as avg_disc,
count(*) as count_order
from
lineitem;
select
sum(l_quantity) as sum_qty
from
lineitem;
Gliffy Diagrams
Attachments
Issue Links
- is part of
-
-
- Closed
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Q1a:
5.3.12 - 30.93
5.5.r-3696 - 34.36
MySQL-5.5.30 - 37.96
Q1b:
5.3.12 - 15.08
MySQL-5.5.30 - 15.53
5.5.r-3696 - 15.65
That is:
- 5.3 is always the fastest.
For Q1b (the simplest query), MySQL 5.5 is the second, closely follwed by 5.5.
For Q1a, its other way around: MariaDB 5.5 is the second, and MySQL 5.5 is 3rd.
Sergei, is there anything left to do for this task? Maybe running a different reduced 2nd query?
Axel,
right now, I am not sure if I need a different reduced query. Let's look at results of MDEV-4309 and then decide.
Reduced priority - don't know if we need to dig further in the profiles. For virtual call removal, it would be nice to finish with MDEV-4309 first.
Closing as MDEV-4309 has been closed.
Profiles data from Axel. Built some more charts.