mySQL processes - please help!

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

  1. #1
    My website seems to be very slow to load and goes down for the past 1 or 2 months. I'm running it on a dedicated server and it used to be all fine until just recently.

    When i login to the root for the server and go to mysql process list i see a lot of same processes.

    Here is an example:

    Query 121 Locked UPDATE photo SET total_views=total_views+1, last_view_date=NOW() WHERE photo_id='495'

    Query 116 Locked SELECT photo_server_url,photo_ext,l_width,l_height,t_width,t_height,s_width,s_height FROM photo WHER

    Query 109 Locked SELECT photo_server_url,photo_ext,l_width,l_height,t_width,t_height,s_width,s_height FROM photo WHER

    Query 97 Locked SELECT photo_server_url,photo_ext,l_width,l_height,t_width,t_height,s_width,s_height FROM photo WHER

    After a while if i dont restart my services i get hundreds of those statements...all of them say locked..what does that mean?
     
    netpox, Aug 18, 2008 IP