Details
-
Task
-
Status: In Progress (View Workflow)
-
Critical
-
Resolution: Unresolved
-
Q3/2025 Maintenance, Q4/2025 Server Maintenance, Q1/2026 Server Maintenance
Description
In testing MariaDB 10.11.13 and 11.4.7 on an Intel single socket server with the InnoDB storage engine and SERIALIZABLE transaction isolation and a scale factor 1 schema it was observed that the overall query set takes 2X the time on 11.4.7 of which most of this is attributed to Q21 that takes 10X longer 50 seconds on 11.4 compared to 5 on 10.11.
MariaDB [(none)]> select @@version;
|
+------------------+
|
| @@version |
|
+------------------+
|
| 10.11.13-MariaDB |
|
+------------------+
|
1 row in set (0.000 sec)
|
|
|
"682F4B1EA3FE03E253036393": {
|
"db": "MariaDB",
|
"bm": "TPC-H",
|
"tstamp": "2025-05-22 18:04:46",
|
"queries": "22",
|
"querysets": "1",
|
"geomean": "0.90616",
|
"querytime": "50"
|
},
|
|
|
"Executing Query 21 (9 of 22)",
|
"1",
|
"query 21 completed in 4.699 seconds",
|
|
MariaDB [(none)]> select @@version;
|
+----------------+
|
| @@version |
|
+----------------+
|
| 11.4.7-MariaDB |
|
+----------------+
|
"682F54A5355F03E213235373": {
|
"db": "MariaDB",
|
"bm": "TPC-H",
|
"tstamp": "2025-05-22 18:45:25",
|
"queries": "22",
|
"querysets": "1",
|
"geomean": "1.14923",
|
"querytime": "105"
|
},
|
"Executing Query 21 (9 of 22)",
|
"1",
|
"query 21 completed in 50.65 seconds",
|
Graphs of query sets attached
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
MDEV-37732 TPROC-H, no stats: Query 21 is much slower in 11.4 than in 10.11
-
- Stalled
-
- split to
-
-
- Closed
-
-
-
- Closed
-