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.