Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
ring_c
Involved
Involved



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

PostPosted: Tue Sep 20, 2005 11:39 pm Reply with quote

Quote:

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

Thanks...
 
View user's profile Send private message Visit poster's website
ring_c







PostPosted: Thu Sep 22, 2005 2:53 pm Reply with quote

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?
 
hitwalker
Sells PC To Pay For Divorce



Joined:
Posts: 5661

PostPosted: Thu Sep 22, 2005 3:07 pm Reply with quote

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..
 
View user's profile Send private message
ring_c







PostPosted: Thu Sep 22, 2005 3:10 pm Reply with quote

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







PostPosted: Thu Sep 22, 2005 3:18 pm Reply with quote

no
 
chatserv
Member Emeritus



Joined: May 02, 2003
Posts: 1389
Location: Puerto Rico

PostPosted: Thu Sep 22, 2005 4:36 pm Reply with quote

I would need to know what the actual errors are.
 
View user's profile Send private message Visit poster's website
ring_c







PostPosted: Thu Sep 22, 2005 4:43 pm Reply with quote

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







PostPosted: Thu Sep 22, 2005 4:44 pm Reply with quote

Hi cs... Smile

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...
 
ring_c







PostPosted: Thu Sep 22, 2005 4:49 pm Reply with quote

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.
 
chatserv







PostPosted: Thu Sep 22, 2005 5:14 pm Reply with quote

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.
 
Raven
Site Admin/Owner



Joined: Aug 27, 2002
Posts: 17088

PostPosted: Thu Sep 22, 2005 5:51 pm Reply with quote

Spend some time reading the support forums at [ Only registered users can see links on this board! Get registered or login! ] 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" [ Only registered users can see links on this board! Get registered or login! ]
 
View user's profile Send private message
hitwalker







PostPosted: Thu Sep 22, 2005 6:07 pm Reply with quote

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.
 
ring_c







PostPosted: Thu Sep 22, 2005 11:24 pm Reply with quote

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







PostPosted: Thu Sep 22, 2005 11:41 pm Reply with quote

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







PostPosted: Fri Sep 23, 2005 5:36 am Reply with quote

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

Rushing to the hospital...
 
hitwalker







PostPosted: Fri Sep 23, 2005 8:27 am Reply with quote

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







PostPosted: Sat Sep 24, 2005 11:27 am Reply with quote

Well, it's a girl!
 
Raven







PostPosted: Sat Sep 24, 2005 11:31 am Reply with quote

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







PostPosted: Sat Sep 24, 2005 11:37 am Reply with quote

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
 
chatserv







PostPosted: Sat Sep 24, 2005 12:56 pm Reply with quote

Congrats ring_c
 
ring_c







PostPosted: Sat Sep 24, 2005 1:12 pm Reply with quote

Thanks, ChatServ!
 
ring_c







PostPosted: Thu Sep 29, 2005 8:29 am Reply with quote

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!
 
ring_c







PostPosted: Sat Oct 01, 2005 12:40 pm Reply with quote

Quote:

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

Please? anyone?
 
ring_c







PostPosted: Tue Oct 11, 2005 2:41 am Reply with quote

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







PostPosted: Tue Oct 11, 2005 4:00 am Reply with quote

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 .
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
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
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©