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

[firstrebel]

Originally Posted by MrZeropage

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

Good point. My vb_games_scores table has nearly 9000 entries. If I enable autopruning say after 5 days I presume only score over 5 days old get zapped?

Bob

[juanchi]

Originally Posted by James T Brock

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.

I only save top scores also, sorry but there have to be a BUG with the latest version, and I think the problem is related to something that have to do with this table vbb_games_league, what is this table for? it keeps tracks of the arcade statistics? I can see the record of this table increase by the second, if this is related to tournaments I have to say that I'm not running tournaments on my site and I had never created a torunament in my arcade.

Can I roll back to 2.5.5.

[James T Brock]

Originally Posted by juanchi

if this is related to tournaments I have to say that I'm not running tournaments on my site and I had never created a torunament in my arcade.

Same here. I edited all references to tournaments from my arcades skin.

MrZeropage doesn't seem to care about this problem since it only affects people with a lot of traffic.

[Gemma]

Hmmm....the games_league table stores of the information for the Leaderboard.

It sounds like the 'bug fix' to make the League Table auto-update may be causing a strain on server loads

MrZeropage doesn't seem to care about this problem since it only affects people with a lot of traffic.

There is no need for quotes like that!

[juanchi]

Originally Posted by Gemma

There is no need for quotes like that!

Well there is definitley no need for a quote like that and I apreciate all the hard work done by MrZeropage but I understand also the frustation of James T Brock since I'm also expierincing this problem and maybe many others that don't have the time to look into this forums. When this problem started on my server the last thing I will think that could be causing the problem will be the arcade.

[James T Brock]

Originally Posted by Gemma

There is no need for quotes like that!

Well I don't mean to be rude but he pretty much ignored us even though it's a major problem that crashes an entire dedicated server. No one is even answering juanchi's question about whether or not it's possible to go back to a previous version.

[MrZeropage]

Originally Posted by James T Brock

MrZeropage doesn't seem to care about this problem since it only affects people with a lot of traffic.

Thanks :hurt:

I was on vacation until 23rd May so don't blame me for not being here within a second

even though it's a major problem that crashes an entire dedicated server. No one is even answering juanchi's question about whether or not it's possible to go back to a previous version.

ibProArcade is running on several dedicated Servers, even some I personally administrate. No problem there at all.

If you want to switch back to v2.5.5+ it is no problem, just overwrite all .php-files and you're done


For further investigation on your problem I'll need access to your FTP and ACP so I can trace that bug ...

[Kacela]

Not for this issue, but I had another perplexing issue that I needed MrZeropage's assistance with. I gave him AdminCP access and FTP access, and he sorted my problem quickly. I guess what I'm saying is that in addition to being trustworthy and capable, he will not "ignore" a users problem.

He has spent many hours recoding a superior arcade for us to use, and gives us outstanding suppport, all for free (although, I have sent him thanks via paypal in the past ).

I think it unfair to bash him like that. Just PM MrZeropage the info for AdminCP access and FTP access (he has his own accounts on my board), and he can probably sort your problem quickly.

[Neo_obs]

I agree he is a great guy and even when I may be annoying he never ignores me it just might take him awhile and i understand he is a busy man

[James T Brock]

Anyone know where I can download the older version of ibproarcade? I just ran a repair on my database but when I reopened the arcade it almost brought my server down again. And the only person playing games was me.