Page 1 of 1

Live MySQL load graph

Posted: Fri Mar 07, 2008 8:21 am
by impulse()
Hi,

I'm looking for something that will represent the MySQL load on multiple servers. I've Googled about but I haven't found anything promising. Hopefully somebody has done this before?

Thanks.

Re: Live MySQL load graph

Posted: Fri Mar 07, 2008 9:21 am
by impulse()
The only idea I have at the moment is to run

Code: Select all

$top = exec("top | grep 'mysqld');
and use string functions to pull out the percentage.

Re: Live MySQL load graph

Posted: Fri Mar 07, 2008 9:45 am
by Zoxive
I just searched for a while and found a few things, because pretty soon here I too will need something similar.

http://www.mysql.com/news-and-events/ne ... 00301.html

http://jeremy.zawodny.com/mysql/mytop/
(Its in the Ubuntu repository's sweet)

http://www.gossamer-threads.com/blog/my ... onitoring/
(No examples but pretty cool graphs)