<div>
<div class="content wysiwyg-content">
We have a PHP application that we are running that has some slow performance time. &nbsp;It seems to be getting slower as the DB grows, so I am thinking we are in need of indexes somewhere. &nbsp;We did not write the application, and trying to find the query's in the code is very time consuming.<br />
<br />
Is there any monitor for mysql that would analyze the querys being run on the server, and show execution times? &nbsp;It would also be nice if the tool could provide index recomendations.<br />
<br />
I have looked at mtop, and mysqltools, but have not had much success with either. &nbsp;When trying to run the analyzer from mysql tools, I was getting windows access violation error messages.<br />
<br />
Thanks,<br />
<br />
Joe
</div>
</div>


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.

Thanks,

Joe

MySQL Live Query Monitor

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.