[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!


Generated at Thu Feb 08 10:06:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.