Re: Mysql Monitoring with Graphite
I am using graphite, but what exactly do you want to graph? For mysql graphing I actually use nagios plugin called check_mysql_health along with check_mk/pnp4nagios That works really well. On Fri, Feb 22, 2013 at 2:24 AM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: Adarsh Sharma eddy.ada...@gmail.com Anyone has any idea about this. Unless someone else here is using Graphite (I've never even heard of it, tbh) I think this may be something for the Graphite support channels, instead. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Mysql Monitoring with Graphite
Hi all, I need to set up mysql monitoring graphs in Graphite. I am able to monitor basic system metrics after runnning example-client.py that comes with graphite installation. when i m looking for mysql plugin for graphite , i find MySQLPerfCollector.py but when i am running it after installing diamond , it is not sending status to graphite server. Can anybody pls let me know how can we plot mysql basic monitoing graphs in graphite. --Thanks
Re: Mysql Monitoring with Graphite
Anyone has any idea about this. On Thu, Feb 21, 2013 at 7:42 PM, Adarsh Sharma eddy.ada...@gmail.comwrote: Hi all, I need to set up mysql monitoring graphs in Graphite. I am able to monitor basic system metrics after runnning example-client.py that comes with graphite installation. when i m looking for mysql plugin for graphite , i find MySQLPerfCollector.py but when i am running it after installing diamond , it is not sending status to graphite server. Can anybody pls let me know how can we plot mysql basic monitoing graphs in graphite. --Thanks
Re: Mysql Monitoring with Graphite
- Original Message - From: Adarsh Sharma eddy.ada...@gmail.com Anyone has any idea about this. Unless someone else here is using Graphite (I've never even heard of it, tbh) I think this may be something for the Graphite support channels, instead. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: mysql monitoring
i think he was speaking more of graphical stats ..if i am not mistaken...mytop cant give you that or atleast i havent seen it..but it wouldnt be bad if it could have those stats in a graphical format. cheers David Ziggy Lubowa Network Engineer One2net (U) web: www.one2net.co.ug Tel: +256 41 345466 -Original Message- From: Dr. Poo [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 11, 2003 5:07 PM To: Michael Weiner; [EMAIL PROTECTED] Subject: Re: mysql monitoring I didn't read the original thread...but go to CPAN and check out MyTop.pl. Just like unix Top process watch application, but for mysql... pretty cool! -Chris On Thursday 09 January 2003 06:02 pm, Michael Weiner wrote: There are a few solutions out there for you. I recommend you check out RRDTOOL, and associated packages at http://people.ee.ethgz.ch/~oetiker/webtools/rrdtool/ and also look for a took called cactus, it absolutely rules. THere are others, but rrdtool, has a myriad of contributed packages it can work with to monitor email servers, bandwidth, and just about anything you can think of. Enjoy Michael Weiner spamfilteraide sql,query,queries,smallint /spamfilteraide - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql monitoring
I didn't read the original thread...but go to CPAN and check out MyTop.pl. Just like unix Top process watch application, but for mysql... pretty cool! -Chris On Thursday 09 January 2003 06:02 pm, Michael Weiner wrote: There are a few solutions out there for you. I recommend you check out RRDTOOL, and associated packages at http://people.ee.ethgz.ch/~oetiker/webtools/rrdtool/ and also look for a took called cactus, it absolutely rules. THere are others, but rrdtool, has a myriad of contributed packages it can work with to monitor email servers, bandwidth, and just about anything you can think of. Enjoy Michael Weiner spamfilteraide sql,query,queries,smallint /spamfilteraide - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql monitoring
Thanks Chris, i had not seen that before, nice little tool to compliment the plots!! thanks, added as a bookmark and running it now Michael Weiner -- On Sat, 2003-01-11 at 09:06, Dr. Poo wrote: I didn't read the original thread...but go to CPAN and check out MyTop.pl. Just like unix Top process watch application, but for mysql... pretty cool! -Chris spamfilteraide sql,query,queries,smallint /spamfilteraide - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: mysql monitoring?
Hello David, DL is there an snmp mib or something available for snmp to monitor mysql DL server? or, does anyone have a script that they would like to share that DL they use to monitor and gather statistics about mysql? MYSQLSTAT - A set of utilities to monitor, store and display Mysql DBMS usage statistics Types of stats: 1. Number of queries (queries/sec) 2. Number of Connections (conn/sec) 3. Data In/Out (bytes/sec) 4. Key write requests (requests/sec) 5. Key read requests (requests/sec) 6. Key writes (writes/sec) 7. Key reads (reads/sec) 8. Types of queries 9. Temporary and disk tables usage http://www.mysqlstat.org/en/ http://www.mysqlstat.org/en/screenshot Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql monitoring?
cacti? cheers David Ziggy Lubowa Network Engineer One2net (U) web: www.one2net.co.ug Tel: +256 41 345466 -Original Message- From: Shon Stephens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 8:55 PM To: '[EMAIL PROTECTED]' Subject: mysql monitoring? is there an snmp mib or something available for snmp to monitor mysql server? or, does anyone have a script that they would like to share that they use to monitor and gather statistics about mysql? thanks, shon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql monitoring
There are a few solutions out there for you. I recommend you check out RRDTOOL, and associated packages at http://people.ee.ethgz.ch/~oetiker/webtools/rrdtool/ and also look for a took called cactus, it absolutely rules. THere are others, but rrdtool, has a myriad of contributed packages it can work with to monitor email servers, bandwidth, and just about anything you can think of. Enjoy Michael Weiner spamfilteraide sql,query,queries,smallint /spamfilteraide - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Monitoring Alerts
Hi, I hope this question hasn't been asked loads of times before but I can't see any reference to it in the documentation. Basically I need a way to monitor MySQL to ensure it hasn't gone down. We are using MySQL as the backend of some important sites and need to ensure that if it does crash for whatever reason, an alert (email and SMS) is sent out to an engineer to resolve the problem. We are presently using a program known as NetSaint to monitor our services but it sometimes doesn't seem to be 100% reliable at detecting a MySQL error. Anyway, can anyone tell me a better way to monitor MySQL so that if it has any problems an oncall engineer can respond quickly. I'm sure this must be a common problem so there must be something out there already. Many thanks, Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Monitoring Tool
Hi, I hope this question hasn't been asked loads of times before but I can't see any reference to it in the documentation. Basically I need a way to monitor MySQL to ensure it hasn't gone down. We are using MySQL as the backend of some important sites and need to ensure that if it does crash for whatever reason, an alert (email and SMS) is sent out to an engineer to resolve the problem. We are presently using a program known as NetSaint to monitor our services but it sometimes doesn't seem to be 100% reliable at detecting a MySQL error. Anyway, can anyone tell me a better way to monitor MySQL so that if it has any problems an oncall engineer can respond quickly. I'm sure this must be a common problem so there must be something out there already. Many thanks, Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Monitoring Tool
Pada Tue, 10 Sep 2002 11:03:40 +0100 Tom Freeman [EMAIL PROTECTED] menulis : Hi, I hope this question hasn't been asked loads of times before but I can't see any reference to it in the documentation. Basically I need a way to monitor MySQL to ensure it hasn't gone down. We are using MySQL as the backend of some important sites and need to ensure that if it does crash for whatever reason, an alert (email and SMS) is sent out to an engineer to resolve the problem. We are presently using a program known as NetSaint to monitor our services but it sometimes doesn't seem to be 100% reliable at detecting a MySQL error. Anyway, can anyone tell me a better way to monitor MySQL so that if it has any problems an oncall engineer can respond quickly. I'm sure this must be a common problem so there must be something out there already. Hi, I usually use bofhlog, you can find it in freshmeat.net ... the purpose is for tailing the log file. And we configured bofhlog to monitor the error messages from hostname.err ... with keyword : shutdown or restart ... if bofhlog found a line with one of these keywords, then it will alarm you via anything you want (using other tools). It's real time monitoring ;-) -- C is quirky, flawed, and an enormous success -- Dennis M. Ritchie MySQL 3.23.51 : up 0 days, Queries : 776.454 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone: +62 21 79199577 - HP: +62 8158787286 - Web: http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Monitoring Alerts
Hey, I noticed another response about tailing the log and looking for information in the err log which looks like a great solution. However, if you have an extra computer laying around, you can also set up a cron job with a shell script that connects to the server (via telnet or using a mysql client to connect) and checks the output. Then quickly disconnects so as not to tie up a connection. If the connection is refused or unavailable, then the server is not responding. You could even put in some extra lines in the script for checking more than once to see if it was a fluke the first time. This would be a little more real time and allows you to set the frequency in which you want to monitor the server. Plus, you could set the script to Email you if the server isnt working. If not - hey what do I know heh Eric Lamendola At 10:04 AM 9/10/02 +0100, Tom Freeman wrote: Hi, I hope this question hasn't been asked loads of times before but I can't see any reference to it in the documentation. Basically I need a way to monitor MySQL to ensure it hasn't gone down. We are using MySQL as the backend of some important sites and need to ensure that if it does crash for whatever reason, an alert (email and SMS) is sent out to an engineer to resolve the problem. We are presently using a program known as NetSaint to monitor our services but it sometimes doesn't seem to be 100% reliable at detecting a MySQL error. Anyway, can anyone tell me a better way to monitor MySQL so that if it has any problems an oncall engineer can respond quickly. I'm sure this must be a common problem so there must be something out there already. Many thanks, Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Monitoring Tool
Tom, What type of problems AREN'T you detecting? I'd take a wild guess and say you're only checking MySQL every 5 minutes or so. You can decrease the frequency between checks for more updated status. There are two variables that you need to look at: normal_check_interval, which is part of the services.cfg file. This determines how often to check your host. The second is interval_length in the nagios.cfg file. normal_check_interval * interval_length = time between checks in s. We decreased interval_length from 60 to 30, so each interval was 30 seconds instead of 60. This cuts the time between checks in half across the board. -J -Original Message- From: Tom Freeman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 5:04 AM To: [EMAIL PROTECTED] Subject: MySQL Monitoring Tool Hi, I hope this question hasn't been asked loads of times before but I can't see any reference to it in the documentation. Basically I need a way to monitor MySQL to ensure it hasn't gone down. We are using MySQL as the backend of some important sites and need to ensure that if it does crash for whatever reason, an alert (email and SMS) is sent out to an engineer to resolve the problem. We are presently using a program known as NetSaint to monitor our services but it sometimes doesn't seem to be 100% reliable at detecting a MySQL error. Anyway, can anyone tell me a better way to monitor MySQL so that if it has any problems an oncall engineer can respond quickly. I'm sure this must be a common problem so there must be something out there already. Many thanks, Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Monitoring Alerts
Mike, I totally agree. The log solution wasn't my idea though smile. No matter what language you write the script in, any type of Get some kind of response by throwing something against the server and seeing if it sticks response will get you the information you need. I set up a dummy account and use a simple shell with a mysqladmin status command. Works fine for me. This just lets me know whether the server is up or down. Your way would work well also, because if you have to get a data response, it would probably provide greater detail as to the status and response time of the server. If not - hey what do I know heh Eric Lamendola At 10:26 AM 9/10/02 -0500, mos wrote: Eric, Isn't letting an outside connection access to your log file a little dangerous? Why not create a dummy table with just one record in it, restrict it to read access only, then use your chron job on a remote computer to run a PHP/Perl script to access that record over the net. If it returns an error, then examine the error number to determine what the problem is. (Maybe the connection is down, or the database is down.) There may be better ways to do it but this should be more secure. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
dump stats? - Re: mysql monitoring
Has anyone though about writing an internal function to have MySQL dump database statistics into a flat file or database tables? -RG On 5 Apr 2002, Jason Yates wrote: Date: 05 Apr 2002 16:04:01 -0500 From: Jason Yates [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysql monitoring Is there any sort of mysql load monitoring tools out there? If not how can I get how many query's per/sec, users, etc, which I can log to a flat file or db, and I could run rrdtool against it to get graphs? -Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql monitoring
Is there any sort of mysql load monitoring tools out there? If not how can I get how many query's per/sec, users, etc, which I can log to a flat file or db, and I could run rrdtool against it to get graphs? -Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL monitoring tools
Hi! Hi All, Does anybody know if there are any monitoring tools for MySQL database? Thanks, Aruna. You can find a wide range of MySQL tools in the MySQL software portals at: http://www.mysql.com/portal/software/html/index.html Take a look under the section 'Administrators' and 'Graphical clients' Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL monitoring tools
Jeremy Zawodny writes: On Fri, Jan 25, 2002 at 03:40:37PM +0200, Sinisa Milivojevic wrote: Hi! There is a wide choice. You can use either admin modules of mysqlgui or mysql module in MOODSS. Depends on what exactly you need, and on your taste ... If you'd rather use a console-based app, mytop will give you some helpful info: http://public.yahoo.com/~jzawodn/mytop/ (Shameless plug.) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 22 days, processed 525,264,930 queries (264/sec. avg) And you can accomplish the same functionality with mysqlgui in process dialogue, with sorting by Time column descending ... (Much more shameless plug.) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL monitoring tools
Hi All, Does anybody know if there are any monitoring tools for MySQL database? Thanks, Aruna. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL monitoring tools
Gorantla, Aruna writes: Hi All, Does anybody know if there are any monitoring tools for MySQL database? Thanks, Aruna. Hi! There is a wide choice. You can use either admin modules of mysqlgui or mysql module in MOODSS. Depends on what exactly you need, and on your taste ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL monitoring tools
On Fri, Jan 25, 2002 at 03:40:37PM +0200, Sinisa Milivojevic wrote: Gorantla, Aruna writes: Hi All, Does anybody know if there are any monitoring tools for MySQL database? Thanks, Aruna. Hi! There is a wide choice. You can use either admin modules of mysqlgui or mysql module in MOODSS. Depends on what exactly you need, and on your taste ... If you'd rather use a console-based app, mytop will give you some helpful info: http://public.yahoo.com/~jzawodn/mytop/ (Shameless plug.) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 22 days, processed 525,264,930 queries (264/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL monitoring tools
I just ran across mtop on freshmeat. Looks kind of nice to me. -- Bruce One day at a time... One second if that's what it takes Gorantla, Aruna wrote: Hi All, Does anybody know if there are any monitoring tools for MySQL database? Thanks, Aruna. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANNOUNCE: MySQL monitoring with moodss-15.6
Moodss (a modular monitoring application, graphical and daemon) fully supports the MySQL database and great efforts are made in collaboration with the MySQL AB developer Sinisa Milivojevic, in order to achieve a practical and thorough monitoring of MySQL servers. No less than 6 modules, such as the new myhealth and upcoming myerrorlog modules, are available. This version adds the new *myhealth* module, which allows monitoring the health of a database server. Carefully chosen relevant indicators are displayed, allowing the administrator to set meaningful thresholds. For example, it is possible to alert several persons with an email message when a server becomes unreachable, or the number of remaining connections becomes low, or intrusions may be attempted... The module online help suggests values for thresholds, along with a description of the causes and eventual remedies, all only a mouse move away... This module was designed with the extremely valuable help of Sinisa Milivojevic [EMAIL PROTECTED], whom I wish to sincerely thank for his input. More examples and documentation can be found in the module help file, at http://jfontain.free.fr/myhealth/myhealth.htm, various screenshots and other modules for MySQL (mystatus, myvars, myprocs, myquery, ...) are visible at the moodss and MySQL specific page: http://jfontain.free.fr/mysql/, whereas complete information on moodss itself can be found at http://jfontain.free.fr/moodss/. Main features of moodss and its MySQL modules: * monitor as many servers (such as replicated) as you wish, on the same dashboard * threshold alerts forwarded by email to the administrators * native connection to the database servers or via ODBC * performance, statistics (graphs, pies, ...) and errors monitoring * background monitoring with the moomps daemon * monitor servers residing on any MySQL supported platforms (UNIX, Windows, ...) * can be combined with server system monitoring (cpustats, memstats, mounts, ...), network monitoring (snmp, snmptrap, ...) and web server monitoring (apache, apachex, ...) to construct a site wide monitoring station * critical errors and warnings reporting directly from the MySQL error log, even on remote machines, thanks to the upcoming myerrorlog module * Windows support is planned, albeit with reduced functionality Development on moodss MySQL modules is very active, and your comments, bug reports, feature requests, ... will be greatly appreciated. Downloads: http://jfontain.free.fr/moodss-15.6.tar.bz2 http://jfontain.free.fr/moodss-15.6-1.i386.rpm http://jfontain.free.fr/moomps-1.2.1-1.i386.rpm http://jfontain.free.fr/moodss-15.6-1.spec Enjoy! -- Jean-Luc Fontaine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php