Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
5.6.44-86.0, 5.7.26-29, 8.0.17-8
-
None
Description
Looking at the Percona documentation for slow query, setting 'null' value for slow_query_log_use_global_control variable should work, but it's failing with an error.
set global slow_query_log_use_global_control = none; ERROR 1231 (42000): Variable 'slow_query_log_use_global_control' can't be set to the value of 'none' set global slow_query_log_use_global_control = 'none'; ERROR 1231 (42000): Variable 'slow_query_log_use_global_control' can't be set to the value of 'none'
As a workaround, we need to set it to a blank value.
mysql [localhost] {msandbox} ((none)) > set global slow_query_log_use_global_control = '';
Query OK, 0 rows affected (0.00 sec)
mysql [localhost] {msandbox} ((none)) > show variables like 'slow_query_log_use_global_control';
+-----------------------------------+-------+
| Variable_name | Value |
+-----------------------------------+-------+
| slow_query_log_use_global_control | |
+-----------------------------------+-------+
1 row in set (0.01 sec)
