Live MySQL load graph

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
impulse()
Forum Regular
Posts: 748
Joined: Wed Aug 09, 2006 8:36 am
Location: Staffordshire, UK
Contact:

Live MySQL load graph

Post 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.
impulse()
Forum Regular
Posts: 748
Joined: Wed Aug 09, 2006 8:36 am
Location: Staffordshire, UK
Contact:

Re: Live MySQL load graph

Post 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.
User avatar
Zoxive
Forum Regular
Posts: 974
Joined: Fri Apr 01, 2005 4:37 pm
Location: Bay City, Michigan

Re: Live MySQL load graph

Post 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)
Post Reply