FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Database size and "hang time"
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Database size and "hang time" [message #25527] Sat, 11 June 2005 22:32 Go to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
Our database has about 200,000 messages stored. The vast majority are in one forum/category. When one posts a message or reply to that forum/category, the forum "hangs" for quite some time before the message is posted. That is, it takes a very long time for the page displayed to change, even though, when it does, it says it took only .03 seconds to generate the page. This "hang time" also results from admin actions, such as deleting messages and topics, and merging topics. There is no "hang time" for any actions in any of the other forums/categories.

How large a database is in use in other FUD forums? Could the database size be the reason for the "hang time"? Would it help if the database was split, making the main database much smaller (and putting the older messages into a separate database outside of FUD)?
Re: Database size and "hang time" [message #25537 is a reply to message #25527] Sun, 12 June 2005 17:19 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
We've got a forum running on this machine with over 700,000 messages are not experiencing any such problems.

One solution you may want to try is to try to avoid having a single forum containing the vast majority of messages in a bulletin board. Often when making a post, forum needs to rebuild the topic 'view', which may explain a slight delay if you have tens of thousands of topics.

Another solution is to increase the MySQL buffer sizes so it does not need to use temporary files.


FUDforum Core Developer
Re: Database size and "hang time" [message #25539 is a reply to message #25537] Sun, 12 June 2005 20:30 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
Ilia wrote on Sun, 12 June 2005 10:19

One solution you may want to try is to try to avoid having a single forum containing the vast majority of messages in a bulletin board. Often when making a post, forum needs to rebuild the topic 'view', which may explain a slight delay if you have tens of thousands of topics.


Here's an idea: If I created a forum called "Deep Archive", would it be possible to move all messages from prior to a certain date into it? That forum could be set so no one could post or reply, but it would be available for searches. This would take the load off the one forum which contains the vast majority of messages.

If this is possible, how could those older messages be moved to the "Deep Archive" forum? Is there a way to do it using the Admin CP?
Re: Database size and "hang time" [message #25545 is a reply to message #25539] Mon, 13 June 2005 02:07 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You can do it via SQL, forum's built-in "move" functionality only works for one thread at a time.

FUDforum Core Developer
Re: Database size and "hang time" [message #25566 is a reply to message #25545] Tue, 14 June 2005 00:27 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
Our forum server has 768megs of ram and it's on a T-1 (1.54mps). The server isn't over taxed with processes, utilization of the processor is less than 10% at any given time, and memory usage is never over 30%.

I'm just trying to find a reason for the excessive "hang time" we're getting.
Re: Database size and "hang time" [message #25570 is a reply to message #25566] Tue, 14 June 2005 01:31 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Check your MySQL config, in particular sort size and temporary table size values.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Double posts and multiple topics
Next Topic: How to do Simplified Chinese search?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 11:04:09 GMT 2024

Total time taken to generate the page: 0.02052 seconds