Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-5813

To set the slow_query_log_use_global_control to "none" could cause an error.

    Details

      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)
      

       

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                kamil.holubicki Kamil Holubicki
                Reporter:
                lalit.choudhary Lalit Choudhary
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 day, 4 hours, 21 minutes
                  1d 4h 21m