MySQL Bugs: #73162: mysql.*_log tables should be deprecated and removed

Bug #73162	mysql.*_log tables should be deprecated and removed
Submitted:	1 Jul 2014 14:50	Modified:	24 May 2016 20:00
Reporter:	Morgan Tocker	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Logging	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:	Frederic Descamps	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Via: http://www.tocker.ca/2013/12/16/proposal-to-change-mysql-replication-defaults.html

The general_log and slow_log tables are obsolete with the introduction of performance_schema w/statement level support.

The slow log has less information than the on-disk slow log (and certainly less than P_S).

Together they both use the CSV engine, and it would be nice to make mysql.* InnoDB only and reserved for configuration.

Also - keeping mysql.* small is important for DBA administration, as this aids a fast restore.

How to repeat:
N/A

Suggested fix:
Feature Request.

Thank you for this feature request.