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.