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...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.