Bug Table Locking Issue?

[Haltech]

Ok, it started the other day. I finally upgraded vbshout to the 6.0.8 and then user tagging to 3.0.4. Then the site began to really take a hit. Load values were on par with each other, but mysql user was pegging 800%. Checked out the mysql process log and found this below:

| mazdaspe_msf | Query | 60 | Sending
| data | SELECT t.* FROM credits_transaction AS t LEFT JOIN 
| credits_event AS e ON (t.eventid = e.eventid) WHE |
 | 41987 | mazdaspe_tarren | localhost | mazdaspe_msf | Query | 58 | Sending
| data | SELECT t.* FROM credits_transaction AS t LEFT JOIN 
| credits_event AS e ON (t.eventid = e.eventid) WHE |
 | 42062 | mazdaspe_tarren | localhost | mazdaspe_msf | Query | 46 | Sending
| data | SELECT t.* FROM credits_transaction AS t LEFT JOIN 
| credits_event AS e ON (t.eventid = e.eventid) WHE |
 | 42105 | mazdaspe_tarren | localhost | mazdaspe_msf | Query | 41 | Sending
| data | SELECT t.* FROM credits_transaction AS t LEFT JOIN 
| credits_event AS e ON (t.eventid = e.eventid) WHE |
 | 42117 | mazdaspe_tarren | localhost | mazdaspe_msf | Query | 39 | Sending
| data | SELECT t.* FROM credits_transaction AS t LEFT JOIN 
| credits_event AS e ON (t.eventid = e.eventid) WHE |
 | 42236 | mazdaspe_tarren | localhost | mazdaspe_msf | Query | 23 | Sending
| data | SELECT t.* FROM credits_transaction AS t LEFT JOIN 
| credits_event AS e ON (t.eventid = e.eventid) WHE |
 | 42355 | mazdaspe_tarren | localhost | mazdaspe_msf | Query | 5 | Sending
| data | SELECT t.* FROM credits_transaction AS t LEFT JOIN 
| credits_event AS e ON (t.eventid = e.eventid) WHE |

How do i go about fixing this? Thanks

 

[Haltech]

Hmm, well i will advise anyone with a large forum, stay away from the credit system.. By not being able to purge the DB from transactions, this is what you will have happen to you. 1.5gb in size... your asking for trouble.

 

[Fillip H.]

What's your Process Transactions in Realtime setting set to?

Also, you can purge transactions by running queries to that table or just truncating it completely.

At some point in the not too distant future we'll be working on a rewrite of that mod which should hopefully solve that issue

 

[Darkwaltz4]

You can try this: https://www.dragonbyte-tech.com/f63/slows-down-forum-dramatically-2844/index3.html#post23904

It has been great at speeding up that particular database query.

 

[Haltech]

Well, i had to remove it. My backup went from 58 mins to 12 removing the credit system because of that transaction log. Its a real killer. We enjoyed the mod until it about took down the forum in a year. Hopefully your rewrite comes soon and we can look at it in the future. Thanks