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

slow query log is not logging when log_slow_filter is empty

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.1, 5.5.29
    • 10.0.3, 5.5.31
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.