Bug #85144 Flushing and Purging logs event should get recorded in mysqld server log.
Submitted: 23 Feb 2017 7:20 Modified: 23 Feb 2017 16:48
Reporter: lalit Choudhary Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: Critical event tracing in mysqld server log

[23 Feb 2017 7:20] lalit Choudhary
Currently after Flushing or Purging MySQL logs nothing is getting logged in mysqld server(--log-error) log.

After executing such log rotation commands, MySQL server should add NOTE/WARNING for such events.

How to repeat:
Execute following,

mysql> flush logs


mysqladmin -u <user> -p <pwd> flush-logs


mysql> PURGE BINARY LOGS TO 'mysql-bin14.000121';

Nothing is getting logged in MySQL server log.

Suggested fix:
MySQL server should add NOTE/WARNING for Flushing or Purging log events.
[23 Feb 2017 7:26] lalit Choudhary
changing category
[23 Feb 2017 16:28] MySQL Verification Team

Thank you for your report. I do not see any bug in it, but this is a fully valid and justified feature request.

I also think that destination for logging of the command should be a general log.

Hence, verified as a feature request.
[23 Feb 2017 16:48] lalit Choudhary
I would prefer as 'NOTE' in mysqld server log (--log-error), since Purging and flush activity for overall server and not more like client activity.