slow_query_log_use_global_control=all doesn't mean all
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
Setting slow_query_
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 50
Server version: 5.5.27-28.0 Percona Server (GPL), Release 28.0
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
(root@localhost) [(none)]> show global variables like 'slow_query_
+------
| Variable_name | Value |
+------
| slow_query_
+------
1 row in set (0.00 sec)
(root@localhost) [(none)]> set global slow_query_
Query OK, 0 rows affected (0.00 sec)
(root@localhost) [(none)]> show global variables like 'slow_query_
+------
| Variable_name | Value |
+------
| slow_query_
+------
1 row in set (0.00 sec)
(root@localhost) [(none)]> set global slow_query_
Query OK, 0 rows affected (0.00 sec)
(root@localhost) [(none)]> show global variables like 'slow_query_
+------
| Variable_name | Value |
+------
| slow_query_
+------
1 row in set (0.00 sec)
This is a pain -- especially when trying to force already-connected clients to use the global long_query_time.
slow_query_ log_use_ global_ control= all is broken. Duplicate of https:/ /bugs.launchpad .net/percona- server/ +bug/1016991