Re: remote monitoring of mySQL

[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...) and i'm very
happy about it.




-- 
vittorio zuccalà
Finconsumo Banca SPA
[EMAIL PROTECTED]
Tel: 011-6319464



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

remote monitoring of mySQL

[Andy Ford]

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 
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]

RE: remote monitoring of mySQL

[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 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]