MySQL: examine load, monitor

Zeno McDohl · 02-03-2010, 10:50 AM

I notice the MySQL process is typically one of the top processes and I would like to examine it to see what databases/queries are the main cause of this.

What are some tools I can use to do this? I did a Google and found some stuff like mtop but they are outdated and don't support MySQL 5.x

TB0ne · 02-03-2010, 11:00 AM

Quote:

Originally Posted by Zeno McDohl

I notice the MySQL process is typically one of the top processes and I would like to examine it to see what databases/queries are the main cause of this.

What are some tools I can use to do this? I did a Google and found some stuff like mtop but they are outdated and don't support MySQL 5.x

The MySQL site has many. MySQLadmin is one I use, but there are others as well.

Zeno McDohl · 02-03-2010, 01:30 PM

I looked at the MySQL site but it seems like the stuff seems to be for Enterprise edition, and I'm looking for something free.

The only thing I see in MySQLadmin that would be useful to me is proc stat, but even that hardly shows anything because typically the queries don't last long enough to show up there.

chrism01 · 02-03-2010, 06:38 PM

show processlist

and friends from http://dev.mysql.com/doc/refman/5.0/en/show.html eg http://dev.mysql.com/doc/refman/5.0/...og-events.html & http://dev.mysql.com/doc/refman/5.0/en/mysqlbinlog.html