[HELP] 2.5.6 is putting a load in my server
 

I already made a post about this but there seems to be no interest on this and I'm not sure but I think it is a bug.

My site is a busy site but the latest version, 2.5.6, is putting a high load to my server, sometimes bringing my server to not working condition.

All the mysql processes show something like these:

| 4315 | xxxxxx | localhost | xxxxxxx | Query | 0 | Locked | UPDATE vbb_games_league SET mid='2122',gid='16',position='1560',points='0',cat ='1' WHERE gid=16 AND |
| 4411 | xxxxxx | localhost | xxxxxxx | Query | 0 | Locked | UPDATE vbb_games_league SET mid='1831',gid='16',position='1476',points='0',cat ='1' WHERE gid=16 AND |

And this processes become so intense that the load of the server go to the top. If I shut down the arcade the server behaves without a problem.

Right now, if there is no answer for this could someone tolde me if it is safe to roll back to 2.5.5 and if so, I will only need to upload the files from that version and overwrite the product, right?

I'm also having server load problems since upgrading but I didn't think it could possibly be the arcade. For me it's probably just a coincidence.

What are you using to show you your MySQL processes that are causing trouble? Is it an SSH command? Let me know, I'd like to try it myself and maybe we can verify if it's our arcades that's doing it.

I can't believe it, I turned off the arcade and my server load went back to normal. The server stopped crashing every twenty minutes.

How can I fix this? My arcade was working fine before I updated from ibproarcade made by Chris to the newer version.

Is it possible that the arcades database is corrupt and I just need to fix them? Or is this just a bug in the arcade period?

Yes, you need to use ssh and log into mysql and at the mysql> prompt type: show processlist; .

In the last days I being tryng to figure out a solution, maybe it is my imagination since I did this yesterday and weekends at my server are not very busy, but since I enter the score tools section of the Arcade Control panel and run all the updates there my server have being kind of stable running the arcade without high loads, but as I told you, I did this yesterday and I don't know for sure if this is the fix.

Thanks. You don't know how much your thread helped me out. You saved me a lot of time, money, and grief. My server was going haywire. MySQL was crashing my server every 45 minutes and I had no idea it was the arcade because the previous arcade never had a single problem.

Ever since closing the arcade everything is fine but now I have a few hundred daily arcade users emailing me asking when the arcade is coming back. :cry:

It's too risky right now to open it back up.

The worst thing here my friend is that no one seems to pay attention to this problem, , maybe I'm wrong and the developers are looking for a solution, my server never have any problem in the past with the arcade but after upgrading to the latest version all the problems started, I think the developers fix something related to the tournament system but this fix puts a high load on busy sites, I hope they come with a solution soon.

Out of curiousity have you set the arcade scores to auto-prune?

I haven't upgraded to the latest version of the arcade yet but I did notice once before that the server loads were very high before I disabled auto-pruning

No I have not. I only save my users top scores so there wasn't any reason to use the auto prune feature.

I should also point out that when I first upgraded the arcade it was loading REALLY slow. And I am on very high speed broadband and everything usually loads fast for me. I reduced the amount of games per page from 50 to 20 and it loaded a bit faster bit it was still really slow.

No, I don't have auto-prune active on my arcade.

If you don't have autopruning active, make sure to save only users top score per game, not every score !

That is written in the AdminCP-Settings and somehow important, as by saving every score and never pruning it, scores-table grows too large and will slow everything down

I only save the users top score. That's the one I've always done it and it's the reason why I don't use autopruning.