| 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 Becla | 14 Jun |
| • Re: How to split output from SHOW SLAVE STATUS? | Kishore Jalleda | 15 Jun |
