Bug #45657 Please Add Equivalent I_S Table For SHOW BINARY LOGS
Submitted: 22 Jun 2009 14:19
Reporter: Mikiya Okuno Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:any OS:Any
Assigned to: CPU Architecture:Any

[22 Jun 2009 14:19] Mikiya Okuno
If such there is such a table in INFORMATION_SCHEMA, we can create a stored procedure or an event for an event scheduler in order to PURGE them periodically / intelligently. For example, we can purge the oldest binlog when total amount of file size exceeds some threshold. This may help DBAs so much.

How to repeat:

Suggested fix:
Identical fields to SHOW BINARY LOGS command plus timestamp indicating last update should come in handy.