slow_query_log_use_global_control=all doesn't mean all

Bug #1042723 reported by Jay Janssen
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
New
Undecided
Unassigned

Bug Description

Setting slow_query_log_use_global_control=all does not set all possible values (especially long_query_time):

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_log_use_global_control';
+-----------------------------------+-------+
| Variable_name | Value |
+-----------------------------------+-------+
| slow_query_log_use_global_control | |
+-----------------------------------+-------+
1 row in set (0.00 sec)

(root@localhost) [(none)]> set global slow_query_log_use_global_control='all';
Query OK, 0 rows affected (0.00 sec)

(root@localhost) [(none)]> show global variables like 'slow_query_log_use_global_control';
+-----------------------------------+--------------------------------------------------------+
| Variable_name | Value |
+-----------------------------------+--------------------------------------------------------+
| slow_query_log_use_global_control | log_slow_filter,log_slow_rate_limit,log_slow_verbosity |
+-----------------------------------+--------------------------------------------------------+
1 row in set (0.00 sec)

(root@localhost) [(none)]> set global slow_query_log_use_global_control="log_slow_filter,log_slow_rate_limit,log_slow_verbosity,long_query_time";
Query OK, 0 rows affected (0.00 sec)

(root@localhost) [(none)]> show global variables like 'slow_query_log_use_global_control';
+-----------------------------------+------------------------------------------------------------------------+
| Variable_name | Value |
+-----------------------------------+------------------------------------------------------------------------+
| slow_query_log_use_global_control | log_slow_filter,log_slow_rate_limit,log_slow_verbosity,long_query_time |
+-----------------------------------+------------------------------------------------------------------------+
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.

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

slow_query_log_use_global_control=all is broken. Duplicate of https://bugs.launchpad.net/percona-server/+bug/1016991

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.