Sleeping mysql queries and optimize database

Discussion in 'MySQL' started by nes_jr429, May 6, 2013.

0
  1. #1
    Hello everyone, how can I trace sleeping mysql queries on my database? And what terminal can I use to execute commands in my remotes mysql database to optimize it? thanks... :)
     
    nes_jr429, May 6, 2013 IP
  2. xrvel

    xrvel Notable Member

    Messages:
    918
    Likes Received:
    30
    Best Answers:
    2
    Trophy Points:
    225
    #2
    you can execute the query below to trace sleeping queries
    SHOW FULL PROCESSLIST
    Code (markup):
     
    xrvel, Jul 1, 2013 IP
  3. macfraser

    macfraser Member

    Messages:
    81
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #3
    There is also a query log feature in mysql that you can use to find troublesome queries. It is great for finding slow / non optimized queries. However you do need to configure it to start logging. Here are the documents. http://dev.mysql.com/doc/refman/5.1/en/query-log.html
     
    macfraser, Jul 4, 2013 IP
  4. nes_jr429

    nes_jr429 Member

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #4
    thanks for your replies, I'll try these.. cheers.. :)
     
    nes_jr429, Jul 4, 2013 IP