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]