Bug #90677 dragnet logging: please allow comments in language (e.g. /* ... */)
Submitted: 29 Apr 2018 7:35 Modified: 30 Apr 2018 18:14
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: dragnet, logging

[29 Apr 2018 7:35] Simon Mudd
Description:
The new dragnet logging requires a variable to be set with potentially a long list of rules. There's no way to explain why you've added that rule which may come from normal filtering, requests by support to track a specific issue etc etc. It's really convenient to have that as months or years later you may not remember or even know the reason and remove a filter that's there for a reason.

my /etc/my.cnf has various comments to remind me of settings for this specific reason and some are for unfixed bugs / FRs from several years ago.

How to repeat:
See above.

My current setup (and it will get bigger is:

myuser@myhost [(none)]> show global variables like '%dragnet%';
+--------------------------------+---------------------------------------------------------------------------+
| Variable_name                  | Value                                                                     |
+--------------------------------+---------------------------------------------------------------------------+
| dragnet.log_error_filter_rules | IF err_code == 10927 or err_code == 10914 or err_code == 10926 then drop. |
+--------------------------------+---------------------------------------------------------------------------+

Why did I set this? No idea. You can guess but may not know. I'd like to be able to document for others.

Suggested fix:
Please allow comments in the language such as /* a comment */
[29 Apr 2018 8:15] Simon Mudd
fix typo in synopsis