Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
[forums-announce] Update on forums performance
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index News & Announcements
View previous topic :: View next topic  
Author Message
klieber
Administrator
Administrator


Joined: 17 Apr 2002
Posts: 3657
Location: San Francisco, CA

PostPosted: Fri Sep 26, 2003 11:15 pm    Post subject: [forums-announce] Update on forums performance Reply with quote

Folks --

Quick update on the recent performance issues with the forums. The problems stem from the fact that our keyword table (which is used to facilitate searching) is over 1.5GB and searches on this table bring mysql to its knees. The database server is already a dual Xeon machine with 4GB of RAM, so unless someone out there has a spare 8-processor machine sitting around, we're going to have to find alternate solutions to this problem.

One solution that we've avoided at all costs up until this point is culling old posts from the database. One of the primary strengths of the forums has been its outstanding archive of information. However, we've reached a point where we simply cannot scale any more and keep the forums in a usable state.

So, we're going to look at implementing a "two forums" solution where one forum will contain "live" recent information and another forum will contain older (currently anticipated to be 6+ months) posts and be read-only.

This will allow us to keep older posts while maintaining a reasonable level of responsiveness for the rest of the forums.

This is not an ideal solution, but we do feel it is the best solution given our resources and circumstances. As always, users are welcome to post their feedback in the Gentoo Forums Feedback forum.

--kurt
_________________
The problem with political jokes is that they get elected
Back to top
View user's profile Send private message
klieber
Administrator
Administrator


Joined: 17 Apr 2002
Posts: 3657
Location: San Francisco, CA

PostPosted: Mon Sep 29, 2003 10:41 pm    Post subject: Reply with quote

A minor update:

We tweaked a few things here and there and moved the apache part of the forums over to a new server. Things like "view posts in last 24 hours" should be working now. If you notice any other oddities or problems, please raise them in the feedback forum.

--kurt
_________________
The problem with political jokes is that they get elected
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index News & Announcements All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum