Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.1.21, 10.1.22
-
Processor: Intel(R) Xeon(R) CPU E5-2620 v2 @ 2.10GHz 2.10GHz
RAM: 32 GB
Operating system: Windows Server 2008 R2 Enterprise
System type: 64-bit
Description
The following SQL-statement is slow in MariaDB comparing to PostgreSQL and Oracle. I think something is wrong with your optimizer.
select * |
from
|
(select distinct td.id, |
td.name, |
td.data_type,
|
td.data_size,
|
td.created_new,
|
td.owner_id,
|
td.digest,
|
td.trainclass,
|
td.unit,
|
td.instance
|
from transferdata td, |
units_unitgroups uu
|
where td.trainclass = uu.fk_trainclass |
and td.unit = uu.fk_unit_number |
and td.data_type_new = 19 |
and td.created_new >= 1490006800000 |
and td.trainclass = 'myclass' |
and uu.fk_unitgroup_id in (1) |
order by created_new |
) as subquery |
limit 500
|
This test has been done in 10 parallel threads with 10 second delay before next 10 threads are started with 3 hour duration.
