FUDforum: How To » Database size and "hang time"

Home » FUDforum » How To » Database size and "hang time"

Show: Today's Messages :: Polls :: Message Navigator

Database size and "hang time" [message #25527]

Sat, 11 June 2005 22:32

BobB

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)?

Report message to a moderator

Re: Database size and "hang time" [message #25537 is a reply to message #25527]

Sun, 12 June 2005 17:19

Ilia

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

Report message to a moderator

Re: Database size and "hang time" [message #25539 is a reply to message #25537]

Sun, 12 June 2005 20:30

BobB

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?

Report message to a moderator

Re: Database size and "hang time" [message #25545 is a reply to message #25539]

Mon, 13 June 2005 02:07

Ilia

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

Report message to a moderator

Re: Database size and "hang time" [message #25566 is a reply to message #25545]

Tue, 14 June 2005 00:27

BobB

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.

Report message to a moderator

Re: Database size and "hang time" [message #25570 is a reply to message #25566]

Tue, 14 June 2005 01:31

Ilia

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

Report message to a moderator

Previous Topic:	Double posts and multiple topics
Next Topic:	How to do Simplified Chinese search?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 02:56:53 GMT 2024

Total time taken to generate the page: 0.02063 seconds