jkarnes Posted June 16, 2007 Share Posted June 16, 2007 For a while now we have been having this problem and I could really use some help figuring out what the cause is. Seemingly at random, the following query will cause MYSQL to simply stop functioning and backs up so many threads that it consumes all available memory and CPU usage on my VPS and drags the whole thing to a stop. "select o.orders_status,p.* from orders o LEFT JOIN paypalipn_txn p on p.item_number = o.orders_id AN" This creates a "copying to tmp table" process in SQL that freezes and everything is toast. Quote Link to comment Share on other sites More sharing options...
wendys Posted June 26, 2008 Share Posted June 26, 2008 I think we're having exactly the same problem. :angry: Our site was very unstable today so I contacted our hosting company. They informed me about this paypalipn_txn query and said that our site is using 200% of the CPU. I've no clue about the whole thing. Anyone has any idea? Wendy Quote Link to comment Share on other sites More sharing options...
dynamoeffects Posted June 26, 2008 Share Posted June 26, 2008 Can you post the entire SQL query? Quote Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail. Link to comment Share on other sites More sharing options...
New 
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.
Note: Your post will require moderator approval before it will be visible.