mySQL process list - state = Locked???

Discussion in 'MySQL' started by netpox, Aug 18, 2008.

0
  1. #1
    When i login to the root for the server and go to mysql process list i see a lot of processes that are connected to photo handling and the sate is Locked with over 500 seconds of each one.

    I see there is one process that the state says: Copying to tmp table
    I read online that if this is taking long it might lock up other queries causing your server to perform slow and only solution is to restart mysql servers.

    Right now i have over 100 queries that say Locked and one that says Copying to tmp table....each time i have to restart the mysql services but this happens every 10 minutes as i have enough traffic to cause this problem.

    How can i fix this?
     
    netpox, Aug 18, 2008 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Increase the value of tmp_table_size in my.cnf and restart server.
     
    mwasif, Aug 23, 2008 IP
  3. nirajkum

    nirajkum Active Member

    Messages:
    815
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #3
    You dont have enough memory for temporary operation . You need to increase the size as suggested above
     
    nirajkum, Aug 23, 2008 IP