Database Testing

Jeff Weisberg jaw+arguslist at
Fri Mar 12 14:01:25 EST 2004

| According to documentation at
|, 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
	select 'OK' from (show slave status)
	  where Slave_IO_Running = 'Yes' and Slave_SQL_Running = 'Yes'


More information about the Arguslist mailing list