Search This Blog

Wednesday, November 24, 2010

Command to monitor mysql replication slave status

watch 'mysql -u xxxx -p xxxx -e "show slave status\G" | grep "Last_"'
Posted by Unknown at 9:48 PM

1 comment:

  1. UnknownNovember 30, 2010 at 8:59 PM

    An enhancement to the commands is

    watch 'mysql -uxxxx -pxxxx -e "show slave status\G" | grep -P "Last_|Seconds_Behind_Master"'

    this also shows the amount of replication delay in seconds

    ReplyDelete

Subscribe to: Post Comments (Atom)