Bug #52554 General log table should include `db` column
Submitted: 2 Apr 2010 16:37 Modified: 2 Apr 2010 16:52
Reporter: Shlomi Noach (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:>= 5.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: general log, log table

[2 Apr 2010 16:37] Shlomi Noach
I would like to suggest that the mysql.general_log table should include a `db` column, which is the current database used by the connection (i.e. thread_id), or NULL.
It should correspond to the `db` value indicated in SHOW PROCESSLIST.
The reason for this suggestion is that general log analysis is quite difficult when this data is not present.

Note that the slow log does include said column.

How to repeat:
DESC mysql.general_log;
DESC mysql.slow_log;

Suggested fix:
Add column `db` varchar(512) NOT NULL
to mysql.general_log
[2 Apr 2010 16:52] Valeriy Kravchuk
Thank you for the feature request.