Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.5.12
-
None
-
Debian
Description
Hi Team,
In mysql 5.6 calculation queries finished quickly within 30 sec. After upgrade MariaDB 10.5.12
same query it's taking more time even it's not completing.
Time of query on old DB: (MySQL 5.6) |
|
bash
|
real 0m30.015s
|
user 0m0.420s
|
sys 0m0.580s
|
|
New DB (MariaDB 10.5.12) |
|
ERROR 1969 (70100): Query execution was interrupted (max_statement_time exceeded) |
|
MariaDB [(none)]> show variables like '%max_statement_time%'; |
+--------------------+------------+
|
| Variable_name | Value |
|
+--------------------+------------+
|
| max_statement_time | 600.000000 | |
+--------------------+------------+
|
1 row in set (0.001 sec) |
Here I have attached the explain plan, analyze json outputs and global variables output. Please check it. Let me know if you need any other details.