MySQL Live Query Monitor

Posted on 2005-04-22
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.


Question by:Joe
    1 Comment
    LVL 33

    Accepted Solution


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now