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)
• Status: Verified
• Category: MySQL Server: Logging
• Severity: S4 (Feature request)
• Version: >= 5.1
• OS: Any
• CPU Architecture: Any
• Tags: general log, log table

[2 Apr 2010 16:37] Shlomi Noach

Description:
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.