set global slow_query_log_use_global_control='ALL' does not work as expected

[Valerii Kravchuk]

Documentation (http://www.percona.com/doc/percona-server/5.5/diagnostics/slow_extended_55.html#slow_query_log_use_global_control) says:

"Specifies which variables have global scope instead of local. Value is a “flag” variable - you can specify multiple values separated by commas

        none: All variables use local scope
        log_slow_filter: Global variable log_slow_filter has effect (instead of local)
        log_slow_rate_limit: Global variable log_slow_rate_limit has effect (instead of local)
        log_slow_verbosity: Global variable log_slow_verbosity has effect (instead of local)
        long_query_time: Global variable long_query_time has effect (instead of local)
        min_examined_row_limit: Global variable min_examined_row_limit has effect (instead of local)
        all Global variables has effect (instead of local)"

One would assume from the text above that "all" means all 5 options listed above, but this is not the case:

openxs@ao756:~/dbs/p5.5$ bin/mysql --no-defaults -uroot test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.33 MySQL Community Server (GPL)

Copyright (c) 2009-2013 Percona LLC and/or its affiliates
Copyright (c) 2000, 2013, 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.

mysql> show variables like 'slow_query_log_use_global_control';
 +-----------------------------------+-------+
| Variable_name | Value |
+-----------------------------------+-------+
| slow_query_log_use_global_control | |
+-----------------------------------+-------+
1 row in set (0.00 sec)

mysql> set global slow_query_log_use_global_control='ALL';
Query OK, 0 rows affected (0.00 sec)

mysql> 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)

mysql> show session 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)

So, both globally and for current session only 3 out of 5 options seem set.

[Laurynas Biveinis (laurynas-biveinis)]

This is the same issue as bug 1016991.