Database Testing
Jeff Weisberg
jaw+arguslist at tcp4me.com
Fri Mar 12 14:01:25 EST 2004
| According to documentation at
| http://www.mysql.com/doc/en/Replication_Problems.html, admins should check
| that both the Slave_IO_Running and Slave_SQL_Running colums report 'Yes'.
I'm not a mysql user, so forgive my ignorance; does mysql have
any sort way to fetch this data where you can specify a column
list or where clause? perhaps by querying a 'special' table
or sub-select?
some sort of
select Slave_IO_Running, Slave_SQL_Running from special_table
or
select 'OK' from (show slave status)
where Slave_IO_Running = 'Yes' and Slave_SQL_Running = 'Yes'
--jeff
More information about the Arguslist
mailing list