Andy Ford ha scritto:
Can I do it with DBD::Perl
DBD::Mysql is a good module and you can control mysql status...
You can do a lot of select and you can send them functions as createdb,
shutdown or reload.
I use this module in my mysql databases (i've only one server not many
as you have...)
What would be the best approach to remote monitoring of numerous mySQL
databases remotely i.e. number of threads. number of open tables etc etc
Can I do it with DBD::Perl
Thanks
Andy
--
perl -e print qq^bIG VeRN ! ^^qq^#'#Yv#=D+ ^
Managed Services (in:control) Developer, Telindus, RG27 9HY
From: Andy Ford Sent: 06 July 2006 17:06
What would be the best approach to remote monitoring of numerous mySQL
databases remotely i.e. number of threads. number of open
tables etc etc
Can I do it with DBD::Perl
You could, run queries such as
SHOW STATUS;
SHOW TABLE STATUS;
against