Hi all,
I just want to inform you that your query
mysql -e ‘SHOW SLAVE STATUS\G’ | egrep ‘Slave_IO_Running|Slave_SQL_Running’ | awk -F: ‘{print $2}’ | tr ‘\n’ ‘,’
is now returning:
Yes, Yes, Slave has read all relay log; waiting for the slave I/O thread to update it,
So it gives false negative result.