Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
Reading from information_schema.PARAMETERS table in MariaDB is slower than MySQL by a factor of 20x in the best of cases, and deteriorates linearly in MariaDB once the number of reading threads exceeds the number of available cores, whereas in MySQL the deterioration remains more-or-less flat.
The following table shows relative performance running mysqlslap against the dataset provided in the attached sql file cs0401486-test.sql with this series of commands
for i in 1 5 20 100
|
do
|
mysqlslap -q "select * from information_schema.parameters where SPECIFIC_NAME = 'aaa_sp50001'" -i 10 -c $i
|
done
|
Tests conducted in CentOS 7 machines with 1G RAM and approx. 800 real IOPS with one and four Intel i7-9750H cores @ 2.592GHz, average times reported:
CoresThreads MDB 6.7 MySQL 8 Diff %
|
1 1 0.193 0.008 2413%
|
1 5 0.901 0.015 6007%
|
4 1 0.171 0.004 4275%
|
4 5 0.296 0.007 4229%
|
4 20 1.159 0.066 1756%
|
4 100 19.017 0.340 5593%
|
Timings all on MariaDB 10.6.7. Confirmed on 10.6.8, 10.7.4, and 10.8.3 in Rocky Linux.
Attachments
Issue Links
- is part of
-
-
- Closed
-
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Attachment | cs0401486-test.sql [ 64692 ] | |
| Description |
Reading from information_schema.PARAMETERS table in MariaDB is slower than MySQL by a factor of 20x in the best of cases, and deteriorates linearly in MariaDB once the number of reading threads exceeds the number of available cores, whereas in MySQL the deterioration remains more-or-less flat.
The following table shows relative performance running mysqlslap against the dataset provided in the attached sql file cs0401486-test.sql with this series of commands {noformat} for i in 1 5 20 100 do mysqlslap -q "select * from information_schema.parameters where SPECIFIC_NAME = 'aaa_sp50001'" -i 10 -c $i done {noformat} Tests conducted in CentOS 7 machines with 1G RAM and approx. 800 real IOPS with one and four Intel i7-9750H cores @ 2.592GHz, average times reported: {noformat} CoresThreads MDB 6.7 MySQL 8 Diff 1 1 0.193 0.008 24 1 5 0.901 0.015 60 4 1 0.171 0.004 43 4 5 0.296 0.007 42 4 20 1.159 0.066 18 4 100 19.017 0.340 56 {noformat} Timings all on MariaDB 10.6.7. Confirmed on 10.6.8, 10.7.4, and 10.8.3 in Rocky Linux. |
Reading from information_schema.PARAMETERS table in MariaDB is slower than MySQL by a factor of 20x in the best of cases, and deteriorates linearly in MariaDB once the number of reading threads exceeds the number of available cores, whereas in MySQL the deterioration remains more-or-less flat.
The following table shows relative performance running mysqlslap against the dataset provided in the attached sql file cs0401486-test.sql with this series of commands {noformat} for i in 1 5 20 100 do mysqlslap -q "select * from information_schema.parameters where SPECIFIC_NAME = 'aaa_sp50001'" -i 10 -c $i done {noformat} Tests conducted in CentOS 7 machines with 1G RAM and approx. 800 real IOPS with one and four Intel i7-9750H cores @ 2.592GHz, average times reported: {noformat} CoresThreads MDB 6.7 MySQL 8 Diff % 1 1 0.193 0.008 2413% 1 5 0.901 0.015 6007% 4 1 0.171 0.004 4275% 4 5 0.296 0.007 4229% 4 20 1.159 0.066 1756% 4 100 19.017 0.340 5593% {noformat} Timings all on MariaDB 10.6.7. Confirmed on 10.6.8, 10.7.4, and 10.8.3 in Rocky Linux. |
| Link |
This issue relates to |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.7 [ 24805 ] | |
| Fix Version/s | 10.8 [ 26121 ] | |
| Assignee | Sergei Petrunia [ psergey ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Assignee | Sergei Petrunia [ psergey ] | Oleg Smirnov [ JIRAUSER50405 ] |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.7 [ 24805 ] | |
| Fix Version/s | 10.8 [ 26121 ] |
| Affects Version/s | 10.6.7 [ 26812 ] | |
| Affects Version/s | 10.8.3 [ 27502 ] | |
| Affects Version/s | 10.7.4 [ 27504 ] | |
| Affects Version/s | 10.6.8 [ 27506 ] | |
| Environment |
CentOS Linux 7.5 & Rocky Linux 8.6 x86_64
Intel i7-9750H @ 2.592GHz 1G / 2G RAM, 1 & 4 cores |
|
| Issue Type | Bug [ 1 ] | Task [ 3 ] |
| Fix Version/s | 10.11.0 [ 28411 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Resolution | Duplicate [ 3 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Resolution | Duplicate [ 3 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 10.11.0 [ 28411 ] |
| Priority | Critical [ 2 ] | Major [ 3 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Assignee | Oleg Smirnov [ JIRAUSER50405 ] | Sergei Petrunia [ psergey ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Sergei Petrunia [ psergey ] | Oleg Smirnov [ JIRAUSER50405 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Oleg Smirnov [ JIRAUSER50405 ] | Sergei Petrunia [ psergey ] |
| Attachment | mdev29104-test-log.txt [ 65457 ] |
| Link |
This issue is part of |
| Fix Version/s | 10.11.0 [ 28411 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Labels | Preview_10.11 |
| Zendesk Related Tickets | 164352 143503 |