Error pages due to large PhpBB DB file?

Involved Joined: Dec 28, 2003 Posts: 276 Location: Israel

Quote:

Just turn the Tracking on in NukeSentinel and turn all other tracking applications off and empty their associated tables.

Thanks...

Posted: Thu Sep 22, 2005 2:53 pm

Ok, after reducing the DB size to a total of ~95mb, users are still saying there are still problems with posting msgs.

They do indicate there's less errors now, but stil say they get an error page from time to time.

I was still wondering about 2 large tables:
nuke_bbsearch_wordmatch = 40.3MB
nuke_bbsearch_wordlist = 7.3MB

Can/Should/Mustn't I truncate these tables? if so, will it help reducing errors?

Sells PC To Pay For Divorce Joined: Posts: 5661

well i cannot find hard evidence why you should trash it but raven seemd against it.
Chatserv is the forum magician ,maybe a pm to him could help..

Posted: Thu Sep 22, 2005 3:10 pm

Why do I need to keep 40mb of search words history?!
I know I don't need it. is there any module needing it?

Posted: Thu Sep 22, 2005 3:18 pm

Posted: Thu Sep 22, 2005 4:36 pm

I would need to know what the actual errors are.

Posted: Thu Sep 22, 2005 4:43 pm

No real errors, just page not found after posting a message to a forum..

Posted: Thu Sep 22, 2005 4:44 pm

Hi cs...

Well from his first post...

Quote:

Lately, users complain about error pages after posting messages in forums.
it can take upto 2-3 attempts to post a message to the forums successfuly.

and

The thing is that not always phpbb saves the message, so going back is not always a good solution, especially when trying to send long responses.

So i get the idea there aren't realy "errors" but the forum isnt performing well...

Posted: Thu Sep 22, 2005 4:49 pm

Quote:

So i get the idea there aren't realy "errors" but the forum isnt performing well...

Right. Sorry, if the "error pages" expression was missleading...

And BTW, thanks for jumping in, ChatServ.

Posted: Thu Sep 22, 2005 5:14 pm

Exactly, the first post mentioned error pages so that's why i asked, easier to solve problems when you have these, in your case i guess performance is being hurt by the sheer size of the db as happens to users of standalone phpBB, and it's always caused by the search tables, they can get really big in no time even on low traffic sites.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Spend some time reading the support forums at http://phpbb.com and quit the guessing, guys. You truncate those tables and Search will not work until you rebuild the tables.

Search on wordmatch

Just 1 "for instance" http://www.phpbb.com/phpBB/viewtopic.php?t=250822&highlight=wordmatch

Posted: Thu Sep 22, 2005 6:07 pm

well this might help to...

The most popular method for reducing the size of the phpbb_search_wordmatch table is to add lots of stopwords (ie- words which are not indexed for the purposes of searching) and then go through a two-step process of removing those words from the wordlist table and then removing the related entries from the wordmatch table. There have been threads on that specific procedure as well.

Posted: Thu Sep 22, 2005 11:24 pm

Quote:

The most popular method for reducing the size of the phpbb_search_wordmatch table is to add lots of stopwords (ie- words which are not indexed for the purposes of searching) and then go through a two-step process of removing those words from the wordlist table and then removing the related entries from the wordmatch table. There have been threads on that specific procedure as well.

Hmmm, thanks guys. Any idea how to do so?

Posted: Thu Sep 22, 2005 11:41 pm

Spend some time on the phpbb boards. There is such a wealth of information there.

Posted: Fri Sep 23, 2005 5:36 am

This will have to wait. my wife's starting to deliver our 3rd baby.
Thanks though.

Rushing to the hospital...

Posted: Fri Sep 23, 2005 8:27 am

ill bet they say ..."clear the table"....lol
good luck...

Posted: Sat Sep 24, 2005 11:27 am

Well, it's a girl!

Posted: Sat Sep 24, 2005 11:31 am

- We congratulate you both and trust that all is going well!

Posted: Sat Sep 24, 2005 11:37 am

Yeah, thanks alot!!!
Wify is still at the hospital, and I have to manage with my other 2 kids.
Anyway, it all went well, and they both feel good.

See why I didn't/don't/won't have time to read all the info? Smile

Posted: Sat Sep 24, 2005 12:56 pm

Congrats ring_c

Posted: Sat Sep 24, 2005 1:12 pm

Thanks, ChatServ!

Posted: Thu Sep 29, 2005 8:29 am

1. Thanks for all the greetings!
2. I've read some (very long) threads in phpbb's site. Ok, I understand the size of nuke_bbsearch_wordmatch is causing the slow posting and/or error pages.

I also understnad that if I erase the table, I won't be able to use the search option. So I thought taking advantage of the local google search, so I tried testing it by searching my site with a few of the recent posts (not too recent. I tried looking for 2-3 days old posts), but to my dissapointment, it couldn't find the posts. posts about 2 weeks, it manage to locate.

So... what's your suggestion then? Should I empty the search tables? Which search engine can/should I use instead?

TIA!

Posted: Sat Oct 01, 2005 12:40 pm

Quote:

Should I empty the search tables? Which search engine can/should I use instead?

Please? anyone?

Posted: Tue Oct 11, 2005 2:41 am

Should I get down on my knees and beg?
I realy have been reading some threads on the phpbb site. didn't find something to reduce the size of that table. even the mod to rebuild the table, is reported to create even larger tables!

I currnently truncate none of my forums. Will truncating forums will reduce the size of the search table as well, or will it only result in lose of posts, without reducing those problematic tables?

And again - is there another way to search the forums? some external util maybe?

Posted: Tue Oct 11, 2005 4:00 am

well to be honest...
i shouldnt touch the tables.
the things ive read and seen by now makes me believe that its not a good idea to mess around with the tables.
but if your looking for a good solution i suggest you post this at the phpbb forum .