SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Wizard WorldNews's Avatar
    Join Date
    Nov 2007
    Posts
    1,033
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Is there a program for continously seeing what MySQL processes are running

    Greetings,

    Is there a program like Linux Top that allows one to see on a continuous, that is self refreshing basis, the MySQL Processes that are running and how
    much CPU each process is using and for how long it is running and thus
    inform one as to the MySQL processes that are taking too long so that one
    can kill them?

    Just to be clear a command like this:
    mysqladmin -u root -h localhost -p processlist
    will not do the job, since the above command gives you a snap shot of when
    it was issued and does not run on a continuous basis as for example Linux
    Top does. To be even further clear, I am looking for a PC based desktop
    software that like Putty has a MySQL equivalent Top function that provides
    to one on a continuous basis information about what MySQL processes are running on ones server.

    Regards,

    Anoox search engine volunteer

    www.anoox.com

  2. #2
    SitePoint Evangelist
    Join Date
    May 2006
    Location
    Denmark
    Posts
    407
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can't you just use watch to watch the output of that command?

    Code:
    watch -n 1 mysqladmin -u root -h localhost -p processlist

  3. #3
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  4. #4
    SitePoint Wizard WorldNews's Avatar
    Join Date
    Nov 2007
    Posts
    1,033
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Daniel0 View Post
    Can't you just use watch to watch the output of that command?

    Code:
    watch -n 1 mysqladmin -u root -h localhost -p processlist
    Hi,

    The above command does not work at all!
    It just hangs after issuing it.

    Regards,

    Anoox search engine volunteer

    www.anoox.com

  5. #5
    SitePoint Wizard WorldNews's Avatar
    Join Date
    Nov 2007
    Posts
    1,033
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by longneck View Post
    Hi,

    But I need a software that runs on my Desktop PC and on a continuous basis
    shows all the MySQL processes that are running on the selected MySQL Server.

    I mean the above program only comes in tar.gz file which means that it will
    not install/run on a PC!

    Regards,

    Anoox search engine volunteer

    www.anoox.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •