[MDEV-22036] Can't dynamically set 'long_query_time' Created: 2020-03-25  Updated: 2020-03-25  Resolved: 2020-03-25

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.4.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: acsfer Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

https://mariadb.com/kb/en/slow-query-log-overview/#configuring-the-slow-query-log-time

MariaDB [(none)]> SET GLOBAL long_query_time=1.000000;
 
Query OK, 0 rows affected (0.005 sec)
 
 
 
MariaDB [(none)]> SHOW VARIABLES LIKE 'long_query_time';
 
+-----------------+-----------+
 
| Variable_name   | Value     |
 
+-----------------+-----------+
 
| long_query_time | 10.000000 |
 
+-----------------+-----------+
 
1 row in set (0.002 sec)



 Comments   
Comment by Alice Sherepa [ 2020-03-25 ]

A global variable change affects all new sessions. It does not affect any currently open sessions, including the one that made the change. (https://mariadb.com/kb/en/set/#global-session)

Generated at Thu Feb 08 09:11:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.