FUDforum: How To » fud_read table huge

Home » FUDforum » How To » fud_read table huge

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

fud_read table huge [message #25472]

Thu, 09 June 2005 09:20

sdefranc

Messages: 28
Registered: May 2002
Location: Australia

Karma:

Junior Member

Hi all,

We're been running a pretty old version of FUD for a while now - 2.3.8. I've noticed lately the performance getting worse, so I thought I'd check out the database.

The major bottleneck seems to revolve around the fud_read table, which is now massive - around 519MB in size.

What is the purpose of this table? From what I can tell, it just records when a post was last read, or something like that? Is there any reason for it to be so big? What are the consequences of just blowing away that table Twisted Evil

Forum stats are as follows:

Our users have posted a total of 665976 messages inside 68347 topics.
We have 10743 registered user(s)

Thanks
Sam

[Updated on: Thu, 09 June 2005 09:20]

Report message to a moderator

[Message index]

		fud_read table huge By: sdefranc on Thu, 09 June 2005 09:20
		Re: fud_read table huge By: Ilia on Thu, 09 June 2005 13:34
		Re: fud_read table huge By: sdefranc on Thu, 09 June 2005 20:12
		Re: fud_read table huge By: sdefranc on Thu, 09 June 2005 21:29
		Re: fud_read table huge By: Ilia on Fri, 10 June 2005 15:25

Previous Topic:	Mailing List- Using a Reply-able email sending account
Next Topic:	finduser.tmpl

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 18:00:34 GMT 2024

Total time taken to generate the page: 0.03757 seconds