Results 1 to 3 of 3

Thread: mytop - See What's Slowing Your MySQL Server

  1. #1
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,329 Times in 1,259 Posts

    mytop - See What's Slowing Your MySQL Server

    mytop is an interesting and useful little utility program for monitoring your MySQL server.

    In concept it is very similar to Unix's top command, which shows you the top processes (in terms of CPU usage) on your Unix system.

    Here's a sample of program output from just a moment ago:
    Code:
    MySQL on mercury (5.1.32-log)                                                                                                                      up 1+17:31:48 [20:29:26]
     Queries: 15.0   qps:    0 Slow:     0.0         Se/In/Up/De(%):    45761547/00/00/00 
                 qps now:    1 Slow qps: 0.0  Threads:    7 (   4/   1) 2875/00/00/00 
     Key Efficiency: 100.0%  Bps in/out:   0.0/  0.2   Now in/out:  16.8/ 1.5k
     Master: mysqlLOGb.000007/158175944 do:  ign: 
    
          Id      User         Host/IP         DB      Time    Cmd Query or State                                                                                              
          --      ----         -------         --      ----    --- ----------                                                                                                  
      798824      root         jupiter netbuilder         0  Query show full processlist                                                                                       
      798893      root         jupiter netbuilder         0  Query DELETE FROM blab_online WHERE usr_id=1 OR (1240194566-rtime)>12                                             
      798894      root         jupiter tech-faq-p         0  Query SELECT proxy FROM pl_proxy WHERE id = 33976                                                                 
      798852      root         jupiter netbuilder         1  Query select cache from carpautocache where id="9f4ad1ed051de475f72e2aa7b64e1ec6"                                 
      798890      root         jupiter tech-faq-p         1  Sleep                                                                                                             
      798864      root         jupiter howtodothe         6  Sleep                                                                                                             
      798851      root         jupiter netbuilder         9  Sleep
    As you may be able to tell, mytop is getting this data from the MySQL SHOW PROCESSLIST and SHOW STATUS commands. mytop refreshes this data automatically and presents it in a more usable format.

    None of this is exactly easy to read, but if you're troubleshooting a nasty MySQL performance issue you'll take the time to work through it.
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

  2. #2
    yangyang's Avatar
    yangyang is offline Sky Marshal
    Join Date
    Dec 2008
    Location
    kavoir.com
    Posts
    69
    Blog Entries
    4
    Thanks
    1
    Thanked 3 Times in 3 Posts
    A more general command is 'top'. My host doesn't come with 'mytop'.
    I'm an entrepreneur at Kavoir LLC. My latest venture is about useful data sets.

  3. #3
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,329 Times in 1,259 Posts
    top is good for monitoring server processes, but has no visibility inside MySQL.

    Won't your host allow you to install applications?
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

Similar Threads

  1. Are PPC slowing your loading time?
    By Franc Tireur in forum PPC
    Replies: 3
    Last Post: 28 February, 2012, 10:43 AM
  2. MySQL or MSSQL Server
    By Auryx in forum Databases
    Replies: 3
    Last Post: 26 March, 2011, 20:54 PM
  3. Replies: 4
    Last Post: 23 January, 2010, 09:52 AM
  4. Replies: 0
    Last Post: 12 January, 2010, 00:11 AM
  5. Replies: 17
    Last Post: 30 June, 2009, 20:35 PM

Tags for this Thread

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
  •