Re: remote monitoring of mySQL

2006-07-07 Thread Vittorio ZuccalĂ 
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...)

RE: remote monitoring of mySQL

2006-07-06 Thread Addison, Mark
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