Bug #98036 Provide an option in mysqlbinlog client to log last executed position
Submitted: 20 Dec 2019 5:56 Modified: 27 Feb 2020 13:40
Reporter: Chelluru Vidyadhar Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:all OS:Any
Assigned to: CPU Architecture:Any
Tags: mysqlbinlog

[20 Dec 2019 5:56] Chelluru Vidyadhar 
Description:
While performing point intime restores we usually prefer mysqlbinlog client. The problem is its very difficult to track last executed position in case the mysqlbinlog utility got interrupted during execution. 

How to repeat:
Run any mysqlbinlog command to replay binary logs and interrupt the process. Then its difficult to identify till which position it applied the logs.

Suggested fix:
It would be nice to provide an option (like --progress) to track the last executed file and position. This can help to make the tool much better and helpful for those who make the PITR automated.
[27 Feb 2020 13:40] MySQL Verification Team 
Hi Mr. Didyadhar,

Thank you for your feature request.

I consider this a viable request, which could be quite usefull.

Verified as reported.