Re: Mysql Health script

You probably want to use SHOW STATUS instead of SHOW VARIABLES.

And add use strict and use warnings to your script - this will pay off.

Comment on Re: Mysql Health script Select or Download Code

Replies are listed 'Best First'.
Re^2: Mysql Health script by aalneyperl (Acolyte) on Nov 16, 2007 at 14:01 UTC
i want to use show variables,show status and show slave status once and fetch there values periodically whenever i need them for calculation.	[reply]
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]