Bug #62424 show status of replication slave in SHOW PROCESSLIST on master

• Submitted: 13 Sep 2011 19:12
• Modified: 14 Sep 2011 13:39
• Reporter: Mark Callaghan
• Status: Verified
• Category: MySQL Server: Replication
• Severity: S4 (Feature request)
• Version: 5.1.52
• OS: Any
• CPU Architecture: Any
• Tags: show, slave

[13 Sep 2011 19:12] Mark Callaghan

Description:
It can be useful to show the offset of the slave (master binlog filename and position) when SHOW PROCESSLIST is run on the master. See http://bazaar.launchpad.net/~mysqlatfacebook/mysqlatfacebook/5.1/revision/3729

How to repeat:
NA

Suggested fix:
SHOW PROCESSLIST;
Id      User    Host    db      Command Time    State   Info
3       root    localhost:47190 test    Query   1       Writing to net  INSERT INTO t1 SELECT * FROM t1
5       root    localhost:47194 NULL    Binlog Dump     1       NULL    slave offset: master-bin.0000014

[14 Sep 2011 13:39] Valeriy Kravchuk

Thank you for the feature request.