[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?

[James T Brock]

*bump*

[Gemma]

I'll PM you a link

[James T Brock]

Thank you Gemma.

[juanchi]

Originally Posted by Gemma

I'll PM you a link

Can I have also that link, thanks.

[James T Brock]

Going back to 2.5.5 actually worked. So yes whatever new changes were implemented in 2.5.6 are what is causing the server issues. I hope this is corrected for the next upgrade.

[Gemma]

Originally Posted by juanchi

Can I have also that link, thanks.

Okey

PM Sent

[MrZeropage]

I think I found the code that causes a higher serverload, just waiting for confirmation of that.

Well, "it's not a bug, it's a feature"
It is a feature I implemented and if that was the reason I will do a switch in AdminCP to turn it on/off ... Until v2.5.7+ is out I will provide a QuickFix for that here

[James T Brock]

Thanks MrZeropage. I'm currently using version 2.5.5 without any problems but it would be nice to have some of the new features of 2.5.6 such as guest being allowed to play games. I was looking forward to that feature.

But since my current arcade works and isn't crashing my server I'm fine with waiting however long it takes.

edit: I do find this odd that it completely crashes my dedicated server (3.2 pentium with 2 gigs of ram) and yet a lot of people on shared hosts use this arcade without any problems? Just my luck.

[MrZeropage]

I think you have alot of members and posts in your forum, that is why the load is so high with v2.5.6+

If you want, I can give you my idea of the fix (just one single line has to be changed) and you test this after upgrading to v2.5.6+ again - I bet that it will be good then

[James T Brock]

Originally Posted by MrZeropage

I think you have alot of members and posts in your forum, that is why the load is so high with v2.5.6+

If you want, I can give you my idea of the fix (just one single line has to be changed) and you test this after upgrading to v2.5.6+ again - I bet that it will be good then

One million posts and fifteen thousand members. Though I never have more than 15 users in the arcade at one time. I noticed that it would crash with only three or four users playing games so I assumed that the size of my forum has nothing to do with it.

I'll take that "fix" if you don't mind, but like I said...since my current arcade now works I'm more than fine with waiting however long it takes for an official release fixing this.