Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5.34
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:Linux
Description
[revin@forge mysql]$ sb 55341
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.34-MariaDB MariaDB Server
Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql [localhost] {msandbox} ((none)) > SET @@SESSION.MAX_QUERY_TIME=0.5;
ERROR 1193 (HY000): Unknown system variable 'MAX_QUERY_TIME'
mysql [localhost] {msandbox} ((none)) > SET SESSION MAX_QUERY_TIME=0.5;
ERROR 1193 (HY000): Unknown system variable 'MAX_QUERY_TIME'
mysql [localhost] {msandbox} ((none)) > SET GLOBAL MAX_QUERY_TIME = 0.5
-> ;
ERROR 1193 (HY000): Unknown system variable 'MAX_QUERY_TIME'
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Hi Sergei,
https://mariadb.com/kb/en/how-to-limittimeout-queries/
According to the documentation, there should be a MAX_QUERY_TIME variable starting 5.5.29
Interesting. I don't know how this got into the KB. As far as I can see, MariaDB never had this feature, and certainly not in 5.5.29 (I've just looked over all 5.5.29 changes again, just to make sure it's not something that was implemented and later removed).
I've corrected the manual, thanks!
Why do you think there should be a 'MAX_QUERY_TIME' variable?