Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sign in to follow this  
jkarnes

Paypal Msql "copying To Tmp" Query Bringing Down Whole Machine

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Can you post the entire SQL query?


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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×