somedude Posted February 13, 2007 Share Posted February 13, 2007 My host is suspending my account due to our site causing too much load on the server. Support has given us a series of sql statements that are apparently the cause of the problem. This is one of about a dozen, they all refer to this particular delete statement. | 459 | ouruser_Dbadmin | localhost | ouruser_masterDB | Query | 0 | Locked | DELETE FROM this_table WHERE this_id = '11712659715853' | Can anybody decipher this? What does 459 mean? What does Locked mean? Any help would immmmensely appreciated. Quote Link to comment https://forums.phpfreaks.com/topic/38265-sql-causing-massive-server-load/ Share on other sites More sharing options...
btherl Posted February 13, 2007 Share Posted February 13, 2007 Do you have an index on this_id ? I don't know what the other columns mean, but that statement should run ultra-fast with an index, but terribly slow without one. If it was waiting on a locked table then it shouldn't cause load, so I doubt that's the case. Depending on what they mean by "load". Do you know if the statement is running a long time, or if the problem is that you have lots of statements waiting to be executed? Quote Link to comment https://forums.phpfreaks.com/topic/38265-sql-causing-massive-server-load/#findComment-183386 Share on other sites More sharing options...
fenway Posted February 13, 2007 Share Posted February 13, 2007 This is the output from SHOW PROCESSLIST -- check the refman for interpretation. Quote Link to comment https://forums.phpfreaks.com/topic/38265-sql-causing-massive-server-load/#findComment-183628 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.