Bug #67563 log SET GLOBAL
Submitted: 12 Nov 2012 15:21 Modified: 28 Dec 2012 18:00
Reporter: martin fuxa Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:5.5.30, all OS:Any
Assigned to: CPU Architecture:Any

[12 Nov 2012 15:21] martin fuxa
Description:
Would be nice have option (bool) log_set_global (or hardcoded default ON in Mysql server)
which logs SET GLOBAL ... query to mysql error log (eg with Note level).

Something like SQL_SLAVE_SKIP_COUNTER=1 which leads to
[Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file=...

For example after SET GLOBAL read_only=1; will be in err log
$date-time [Note] 'SET GLOBAL read_only=1' executed, master_log_name='...', master_log_pos='...'

How to repeat:
irelevant for feature request
[28 Dec 2012 18:00] Sveta Smirnova
Thank you for the report.

Verified as described.

Currently you can use general query log for same purpose. If you choose log_output='table' it will store all queries in a table, so you can easily filter them to find out SET GLOBAL queries.