Re: Mysql performance monitoring?
On Fri, Jul 13, 2001 at 09:40:55AM -0200, Mario Witte wrote: > I'm searching for a tool which will provide statistics about the > usage of a mysql-server like avg queries/minute, cpu load etc. Other folks have made good suggestions. If you want something quick and interactive, mytop may give you some of the information you're looking for. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW MySQL 3.23.29: up 28 days, processed 213,628,847 queries (88/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 performance monitoring?
Hi Mario, If you want to see what the MRTG page with check out mrtg-mysql-load: Links to the extension and a live demo for a couple of test servers are at http://www.bitbybit.dk/mysqlfaq Works good for me at http://bsd2.icarz.com/mrtg/index.html (bottom graphs). I also use something called NetSaint. This will be re-released under a new name, but this along with NRPE (a netsaint add on) does most everything I need for monitoring and notification. And this stuff all works through a browser. Although moods looks pretty cool too. GL Ken - Original Message - From: "Mario Witte" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 13, 2001 10:05 AM Subject: Re: Mysql performance monitoring? > Cricket looks great, I think I'll have to try it ASAP. > For the moment I just found a utility called mrtg-mysql which puts > mysql-stats into mrtg. Statistics aren't very extensive but enough for the > moment. > > -- > Mario Witte <[EMAIL PROTECTED]> > > > > On 2001.07.13 07:19:08 -0200 Van wrote: > > Mario Witte wrote: > > > > > > Hello, > > > I'm searching for a tool which will provide statistics about the usage > > of a > > > mysql-server like avg queries/minute, cpu load etc. > > > > > > I've tried mysqler and liked it, but couldn't get it to start as a > > daemon. > > > Are there any similar tools out there? > > > > > > Thanks in Advance, > > > -- > > Maria: > > > > Might be some folks working on it at mrtg, but, I think that one died. > > > > SNMP stuff is over kill for that, but, would add some value. > > > > http://myops.sourceforge.net/ is a start I've made, with the intentions > > of > > incorporating mysql monitoring, but, alas, so much to do, and, so little > > time. > > Some work has been done, but, I haven't had the time to port it to > > anything > > useful, yet. Mostly, some c apps, still sitting on my workstation. > > > > If you like the approach at the link above, I'd love to hear some > > suggestions. > > There are also a couple other projects that might be brewing on > > sourceforge, > > but, you'll have to search around a little. > > > > Also, check out Cricket, which is the next evolution of mrtg. They might > > have > > some contributors dealing with this subject. > > > > Hope that gives you some ideas. I like the question a lot. > > > > Best Regards, > > Van > > -- > > = > > Linux rocks!!! http://www.dedserius.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 > > - 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 performance monitoring?
Van writes: > Mario Witte wrote: > > > > Hello, > > I'm searching for a tool which will provide statistics about the usage of a > > mysql-server like avg queries/minute, cpu load etc. > > > > I've tried mysqler and liked it, but couldn't get it to start as a daemon. > > Are there any similar tools out there? > > > > Thanks in Advance, > > -- > Maria: > > Might be some folks working on it at mrtg, but, I think that one died. > > SNMP stuff is over kill for that, but, would add some value. > > http://myops.sourceforge.net/ is a start I've made, with the intentions of > incorporating mysql monitoring, but, alas, so much to do, and, so little time. > Some work has been done, but, I haven't had the time to port it to anything > useful, yet. Mostly, some c apps, still sitting on my workstation. > > If you like the approach at the link above, I'd love to hear some suggestions. > There are also a couple other projects that might be brewing on sourceforge, > but, you'll have to search around a little. > > Also, check out Cricket, which is the next evolution of mrtg. They might have > some contributors dealing with this subject. > > Hope that gives you some ideas. I like the question a lot. > > Best Regards, > Van > -- > = > Linux rocks!!! http://www.dedserius.com/ > = Ken Menzel has obtained some beautifull results with MRTG -- 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 performance monitoring?
Cricket looks great, I think I'll have to try it ASAP. For the moment I just found a utility called mrtg-mysql which puts mysql-stats into mrtg. Statistics aren't very extensive but enough for the moment. -- Mario Witte <[EMAIL PROTECTED]> On 2001.07.13 07:19:08 -0200 Van wrote: > Mario Witte wrote: > > > > Hello, > > I'm searching for a tool which will provide statistics about the usage > of a > > mysql-server like avg queries/minute, cpu load etc. > > > > I've tried mysqler and liked it, but couldn't get it to start as a > daemon. > > Are there any similar tools out there? > > > > Thanks in Advance, > > -- > Maria: > > Might be some folks working on it at mrtg, but, I think that one died. > > SNMP stuff is over kill for that, but, would add some value. > > http://myops.sourceforge.net/ is a start I've made, with the intentions > of > incorporating mysql monitoring, but, alas, so much to do, and, so little > time. > Some work has been done, but, I haven't had the time to port it to > anything > useful, yet. Mostly, some c apps, still sitting on my workstation. > > If you like the approach at the link above, I'd love to hear some > suggestions. > There are also a couple other projects that might be brewing on > sourceforge, > but, you'll have to search around a little. > > Also, check out Cricket, which is the next evolution of mrtg. They might > have > some contributors dealing with this subject. > > Hope that gives you some ideas. I like the question a lot. > > Best Regards, > Van > -- > = > Linux rocks!!! http://www.dedserius.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 performance monitoring?
Mario Witte wrote: > > Hello, > I'm searching for a tool which will provide statistics about the usage of a > mysql-server like avg queries/minute, cpu load etc. > > I've tried mysqler and liked it, but couldn't get it to start as a daemon. > Are there any similar tools out there? > > Thanks in Advance, > -- Maria: Might be some folks working on it at mrtg, but, I think that one died. SNMP stuff is over kill for that, but, would add some value. http://myops.sourceforge.net/ is a start I've made, with the intentions of incorporating mysql monitoring, but, alas, so much to do, and, so little time. Some work has been done, but, I haven't had the time to port it to anything useful, yet. Mostly, some c apps, still sitting on my workstation. If you like the approach at the link above, I'd love to hear some suggestions. There are also a couple other projects that might be brewing on sourceforge, but, you'll have to search around a little. Also, check out Cricket, which is the next evolution of mrtg. They might have some contributors dealing with this subject. Hope that gives you some ideas. I like the question a lot. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.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 performance monitoring?
On Friday 13 July 2001 13:40, Mario Witte wrote: > Hello, > I'm searching for a tool which will provide statistics about the usage of a > mysql-server like avg queries/minute, cpu load etc. > > I've tried mysqler and liked it, but couldn't get it to start as a daemon. > Are there any similar tools out there? > > Thanks in Advance, moodss at http://jfontain.free.fr/ - 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