[MDEV-5425] MAX_QUERY_TIME is Missing Created: 2013-12-10  Updated: 2013-12-11  Due: 2014-01-10  Resolved: 2013-12-11

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.34
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Jervin R Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
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'



 Comments   
Comment by Sergei Golubchik [ 2013-12-10 ]

Why do you think there should be a 'MAX_QUERY_TIME' variable?

Comment by Jervin R [ 2013-12-11 ]

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

Comment by Sergei Golubchik [ 2013-12-11 ]

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!

Generated at Thu Feb 08 07:04:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.