MySQL Live Query Monitor

We have a PHP application that we are running that has some slow performance time.  It seems to be getting slower as the DB grows, so I am thinking we are in need of indexes somewhere.  We did not write the application, and trying to find the query's in the code is very time consuming.

Is there any monitor for mysql that would analyze the querys being run on the server, and show execution times?  It would also be nice if the tool could provide index recomendations.

I have looked at mtop, and mysqltools, but have not had much success with either.  When trying to run the analyzer from mysql tools, I was getting windows access violation error messages.


LVL 16
Who is Participating?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.