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

Ignore specific users on Slow Query Log

    XMLWordPrintable

Details

    Description

      Hello,

      Would it be possible to implement a new filter for "slow_query_log", where we can ignore specific users?

      I'm a bit on a dilemma whether I should reduce the "long_query_time" or not, and whether I should enable more filters in "log_slow_filter", because as soon as I do any of that, I'll start getting more noise than I already get.

      I have one webapp that is "obsolete" and is going to be deprecated at some point, and I "don't care" that some queries are doing full table scans or taking longer than 5 seconds, but I want to be able to monitor/optimize another webapp, without having too much noise in the logs.

      Also, there is a regular cronjob that runs some queries that intentionally do a full table scan and/or expectedly take 10+ seconds, and those queries are appearing in the logs.

      If I could make it ignore these specific users, it would be great!

      –

      Alternatively, we could have log files (or tables) for each user, so I could ignore the files of those users "I don't care".

      Thank you very much!

      Attachments

        Activity

          People

            Unassigned Unassigned
            nunop Nuno
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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