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.

    XMLWordPrintable

    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)
      

       

       

        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

                  Smart Checklist