Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
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!