The Arcive of vBulletin Modifications Site.

slow load time for arcade.php and high mysql load · **Released**: 02-13-2008

Hello, we're testing ibproarcade on our forums which are currently offline. We have around 150.000 users though the server is dedicated to the forums. We're seeing load go high and arcade.php taking various seconds to load and this is with just 3-4 admins looking around as they're not active to the public. Any idea what the cause could be? VB otherwise seems to be very quick and responsive, just arcade, most noticeably on homepage seems to slow down considerably.

thanks in advance

MrZeropage · #2 02-13-2008, 07:16 PM

having alot of users needs to follow some rules:

- do not display too many games per page
- save only users top score
- activate score-pruning (e.g. 7 or 14 days)

gamershell · #3 02-13-2008, 07:32 PM

we have save only top score
we are only 4 playing the games yet
I set it to 12 games per pages but even at 8 it wasn't visibly faster

any possible setup bug or any way to memcache results?

thanks again

MrZeropage · #4 02-14-2008, 09:02 AM

did you convert from an existing v3arcade or was it a fresh, clean and empty installation of ibProArcade ?

gamershell · #5 02-14-2008, 09:17 AM

Quote:

Originally Posted by MrZeropage

did you convert from an existing v3arcade or was it a fresh, clean and empty installation of ibProArcade ?

fresh, clean and empty
v.2.6.6+
v.3.6.8 patch 2

thanks once more

--------------- Added [DATE]1202987973[/DATE] at [TIME]1202987973[/TIME] ---------------

another thing, listing games in admincp is blazin quick instead

MrZeropage · #6 02-14-2008, 12:44 PM

how many rows do you have in DB-table "games_scores" ?
how many games do you have installed ?

gamershell · #7 02-14-2008, 01:00 PM

92 in games_scores
around 40 games now and 6 categories

MrZeropage · #8 02-15-2008, 07:23 AM

this is a very SMALL installation, there are arcades having 10.000 users, about 500 games ect. and absolutely no problem.

Does a "play game"-page load faster ?

gamershell · #9 02-15-2008, 08:30 AM

I know it's small, I'm shocked seeing it slow, it doesn't really make sense; Games load quick, basically it's only index and index per category pages that are slow.

Would it be possible to memcache results? My worry is that getting server up, just a dozen people hitting arcade meantime will lead to a crash.

Can't the 150,000 users be the problem?

Which queries are relying on users on these pages, maybe some commenting out would do...?

--------------- Added [DATE]1203086376[/DATE] at [TIME]1203086376[/TIME] ---------------

removing the queries to ibf_members to fetch avatars made it quick loading