Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MySQL Live Query Monitor

Posted on 2005-04-22
1
Medium Priority
?
477 Views
Last Modified: 2006-11-18
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
0
Comment
Question by:Joe
1 Comment
 
LVL 33

Accepted Solution

by:
snoyes_jw earned 2000 total points
ID: 13844144
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question