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 each db and munge the results.
mark
Thanks
Andy
--
perl -e print qq^bIG VeRN ! ^^qq^#'#Yv#=D+ ^
Managed Services (in:control) Developer, Telindus, RG27 9HY
DDI: +44 1256 709200, GSM: +44 7810 636652
This e-mail is private and may be confidential and is for the
intended recipient only. If misdirected, please notify us by
telephone and confirm that it has been deleted from your
system and any copies destroyed. If you are not the intended
recipient you are strictly prohibited from using, printing,
copying, distributing or disseminating this e-mail or any
information contained in it. We use reasonable endeavours to
virus scan all e-mails leaving the Company but no warranty is
given that this e-mail and any attachments are virus free.
You should undertake your own virus checking. The right to
monitor e-mail communications through our network is reserved by us.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
MARK ADDISON
WEB DEVELOPER
200 GRAY'S INN ROAD
LONDON
WC1X 8XZ
UNITED KINGDOM
T +44 (0)20 7430 4678
F
E [EMAIL PROTECTED]
WWW.ITN.CO.UK
Please Note:
Any views or opinions are solely those of the author and do not necessarily
represent
those of Independent Television News Limited unless specifically stated.
This email and any files attached are confidential and intended solely for the
use of the individual
or entity to which they are addressed.
If you have received this email in error, please notify [EMAIL PROTECTED]
Please note that to ensure regulatory compliance and for the protection of our
clients and business,
we may monitor and read messages sent to and from our systems.
Thank You.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]