Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > ibProArcade Archive
slow load time for arcade.php and high mysql load Details »»
slow load time for arcade.php and high mysql load
Version: , by gamershell gamershell is offline
Developer Last Online: Jan 2011 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 02-13-2008 Last Update: Never Installs: 0
 
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 02-13-2008, 07:16 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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)
Reply With Quote
  #3  
Old 02-13-2008, 07:32 PM
gamershell gamershell is offline
 
Join Date: Feb 2008
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #4  
Old 02-14-2008, 09:02 AM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

did you convert from an existing v3arcade or was it a fresh, clean and empty installation of ibProArcade ?
Reply With Quote
  #5  
Old 02-14-2008, 09:17 AM
gamershell gamershell is offline
 
Join Date: Feb 2008
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MrZeropage View Post
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
Reply With Quote
  #6  
Old 02-14-2008, 12:44 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

how many rows do you have in DB-table "games_scores" ?
how many games do you have installed ?
Reply With Quote
  #7  
Old 02-14-2008, 01:00 PM
gamershell gamershell is offline
 
Join Date: Feb 2008
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

92 in games_scores
around 40 games now and 6 categories
Reply With Quote
  #8  
Old 02-15-2008, 07:23 AM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 ?
Reply With Quote
  #9  
Old 02-15-2008, 08:30 AM
gamershell gamershell is offline
 
Join Date: Feb 2008
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:18 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05505 seconds
  • Memory Usage 2,265KB
  • Queries Executed 24 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (8)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete