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