Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4206

slow query log is not logging when log_slow_filter is empty

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.1, 5.5.29
    • Fix Version/s: 10.0.3, 5.5.31
    • Component/s: None
    • Labels:
      None

      Description

      Switched to MariaDB 5.5.29 from Percona SQL Server 5.1a and noticed empty slow query log.

      It looks like it is logging only when log_slow_filter is set, but it is not logging when log_slow_filter is set empty string.

      Having filter set is not resolving the issue, since optimized, but still slow queries are not logged.

      log_slow_filter = 'admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk'

      Test case:

      SET long_query_time=1;
      SET log_slow_filter='';
      SET GLOBAL slow_query_log=1;
      SET GLOBAL log_output='TABLE';
       
      SELECT SLEEP(2);
      SELECT * FROM mysql.slow_log;

        Attachments

          Activity

            People

            • Assignee:
              wlad Vladislav Vaintroub
              Reporter:
              seletit Sergiy Tytarenko
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: