Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


jkarnes

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.

Link to comment
Share on other sites

  • 1 year later...

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...