[MDEV-29211] Ignore specific users on Slow Query Log Created: 2022-07-30 Updated: 2022-08-01 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Server |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Nuno | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | slow_query_log | ||
| 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! |