Re^2: Mysql Health script

i want to use show variables,show status and show slave status once and fetch there values periodically whenever i need them for calculation.

Comment on Re^2: Mysql Health script

Replies are listed 'Best First'.
Re^3: Mysql Health script by stark (Pilgrim) on Nov 16, 2007 at 21:24 UTC
There is some simple Perl code in the book "High Performance Mysql" which does a slave check. Very good book by the way. Have you considered to use nagios (or other monitoring solutions)? There are some plugins for nagios that deal with Mysql.	[reply]
Re^4: Mysql Health script by Anonymous Monk on Nov 17, 2007 at 13:00 UTC
hi, thanks stark..it did help, however i still am stuck with picking up the variables dynamically and using it for calculation..	[reply]