List:General Discussion« Previous MessageNext Message »
From:Jacek Becla Date:June 14 2006 4:51pm
Subject:How to split output from SHOW SLAVE STATUS?
View as plain text  
Hi,

I'm trying to find how to split the output from SHOW SLAVE STATUS
into individual fields. Specifically, I would like to be able to
do in a stored function:
1) determine what the status of slave is, and if it is
    "Waiting for master to send event", do some action,
    like stop the slave
2) extract value of Master_Log_File and Read_Master_Log_Pos
    and return it from the function.

Is that possible with existing tools (mysql 5.0.x)?

Thanks,
Jacek
Thread
How to split output from SHOW SLAVE STATUS?Jacek Becla14 Jun
  • Re: How to split output from SHOW SLAVE STATUS?Kishore Jalleda15 Jun