Bug #30431 SHOW BINLOG EVENTS should show last log by default
Submitted: 15 Aug 2007 10:02 Modified: 24 Feb 2010 17:43
Reporter: Stefan Hinz Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version: OS:Any
Assigned to: Mats Kindahl CPU Architecture:Any
Triage: Triaged: D5 (Feature request) / R1 (None/Negligible) / E2 (Low)

[15 Aug 2007 10:02] Stefan Hinz
SHOW BINLOG EVENTS shows the contents of the first file in the binlog index file. I'd consider that a design flaw, because who with a reason to inspect the binlog would be interested in what happened when the server was started for the very first time? It's reasonable to expect that users would be interested in what's happened recently.

How to repeat:
Issue SHOW BINLOG EVENTS without the IN clause.

Suggested fix:
Make SHOW BINLOG EVENTS show the contents of the last file in the binlog index file.
[15 Aug 2007 15:17] Miguel Solorzano
Thank you for the bug report feature request.
[24 Feb 2010 17:43] Lars Thalmann
This was brought up on Server Product Team meeting 2010-02-24.  
There is not currently not enough user interest in this feature 
for it to be implemented.  Bug report marked as "Won't fix".
[11 Nov 2011 10:11] Eduard Ruffert
this is a feature that a user doesn't nedd often, _but_ when he needs it and it's missing, things become very annoying.

Having to dump the complete log just to be able to look at the last n events, is really annoying.

I really miss this feature, too.