Thread: Add-On Releases - gXboxLive - Xbox Live Leaderboard
View Single Post
  #503  
Old 01-28-2008, 10:29 AM
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Location: Telford, England
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi there,
I installed this over the weekend and because we already have over 3,700 members with gamer tags set up, the system was beavering away to add them. I think most were added over the course of the weekend.
Unfortunately our forums were really struggling this morning.
The gXboxLive mod was absolutely strangling the database server.
Quote:
10317 | admin | 192.168.0.1:58892 | vbulletin | Query | 1 | Locked | UPDATE gxboxlive SET `rank` = '1718', `error` = '0' WHERE `userid` = '146703'

| 11234 | admin | 192.168.0.2:60502 | vbulletin | Query | 2 | Sending data | SELECT
COUNT(user.userid) AS `usercount`,
SUM(gxboxlive.score) AS `score`,
SUM(gxboxlive.reput |
| 11235 | admin | 192.168.0.2:60503 | vbulletin | Query | 1 | Locked | SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroup |
| 11236 | admin | 192.168.0.1:59416 | vbulletin | Query | 2 | Sending data | SELECT
COUNT(user.userid) AS `usercount`,
SUM(gxboxlive.score) AS `score`,
SUM(gxboxlive.reput |
and as soon as I deactivated the mod, the server instantaneously sprang back to life.

Any clues as to what it is about the mod was causing this and how we can improve the situation?
Thanks.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01307 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete