1
   

major phpbb_search_wordmatch problems

 
 
Reply Tue 9 Aug, 2005 05:19 am
Please don't flame me I am no guru with this and have to pass info back to my site developer who doesn't know a whole lot about phpbb.

I have PHPBB version 2.0.15 and the only mod I have is this optimization one. I am having major issues with the phpbb_search_wordmatch table, to the point where there is an automated rebuild of the tables being done every 30 mins.

What happens is someone will go to post, edit, delete etc, out of the blue it will come up with a debug error, requiring the repair to fix this, but it happens more frequently as my forum is growing bigger, i.e. several times a day on a very busy forum - not going down well! I have over 2,000 members but this is not the problem... apparently the wordmatch table is crapping itself at a size of 4,717,085. Now I don't know if this is normal, my developer seems to think it's far, far too big and we have no idea how to fix this. This may not be an issue with the Mod but I can't get a response or find anyone else who has this issue in phpbb forums. Do I just add another Mod to cut back search options so it will store less? Help!!!

Running MySQL 4.1.13
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 1 • Views: 7,926 • Replies: 4
No top replies

 
BellyBelly
 
  1  
Reply Tue 9 Aug, 2005 05:34 pm
PLEASE HELP!!! The Forums have been down three hours and the host is able to connect to the database but the forums are coming up as critical error: could not connect to database. My site works fine apart from this. Here's the post I posted on PHPBB:

"I've been getting lots of errors for some time now (more frequently as my site gets bigger) with the wordmatch table. The admins believe this is happening when people are running a search on the site, not all the time but when it happens, it's during a search. Here is the error report:

myisamchk: MyISAM file
/usr/local/var/db/mysql41/belly_forum/phpbb_search_wordmatch.MYI
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 3 clients are using or haven't closed the table
properly
myisamchk: error: Size of datafile is: 35281184 Should be: 3529464

I am running version 2.0.15 and have had this error on lesser versions too. I have no mods apart from the able-to-know optimisation mod, and am desperate to stop this from happening. Posts get lost, deleted and the members are really unhappy with this long term problem which is becoming more frequent. Any ideas?

Database runs on MySQL 4.1 and Apache 2.x - I don't have any problems on the server with anything else except the forums. No other sites have any issues either. So it's something with phpbb."
0 Replies
 
Craven de Kere
 
  1  
Reply Wed 10 Aug, 2005 08:59 pm
This isn't really a phpbb issue so much as a simple database issue in my opinon.

You should try optimizing the table and running other mysql repair utilities on it.

If you don't know how to do this, you should really hire someone who does. This is not the time to try to wing it.
0 Replies
 
BellyBelly
 
  1  
Reply Wed 10 Aug, 2005 09:22 pm
Thank-you very much for the reply. So you are confident it isn't the mod or PHPBB? I have been hearing a great deal from my host/developer who thinks it is one of the two or a combination - I would say they are very anti-phpbb.

I think I know how to optimise it, the same was as you would repair a table, I can optimise it? Select the table and optimise? What other tools do you suggest?

It's so frustrating, I know something is so wrong somewhere and it's hard not having the words to relay the problem... I am just sick of the problem as are the members and this table shouldn't be corrupting all the time. The guys on PHPBB have replied the last 24 hours and feel that it's a DB issue - the developer doesn't understand why it has 5 million rows and thinks its far too excessive? Can't seem to get much more than that.

Can the search utility be restricted so the table wont need to be so big? Or is it not necessary? I've noticed lots of large forums, phpbb or others, seem to have troubles with their search and some of my competitors with various forums have been going to google to have site searches instead.
0 Replies
 
Craven de Kere
 
  1  
Reply Wed 10 Aug, 2005 09:31 pm
BellyBelly wrote:
Thank-you very much for the reply. So you are confident it isn't the mod or PHPBB? I have been hearing a great deal from my host/developer who thinks it is one of the two or a combination - I would say they are very anti-phpbb.


phpbb may well be involved, but it's not the reason. Developers who don't investigate real reasons often point to a scapegoat.

Quote:
I think I know how to optimise it, the same was as you would repair a table, I can optimise it? Select the table and optimise?


Yes.

Quote:
What other tools do you suggest?


I am uncomfortable suggesting DBA tasks to you over the net, being that neither of us are DBAs.

But if you are determined to go it on your own see here:

http://dev.mysql.com/doc/mysql/en/table-maintenance.html

Quote:
It's so frustrating, I know something is so wrong somewhere and it's hard not having the words to relay the problem... I am just sick of the problem as are the members and this table shouldn't be corrupting all the time. The guys on PHPBB have replied the last 24 hours and feel that it's a DB issue - the developer doesn't understand why it has 5 million rows and thinks its far too excessive? Can't seem to get much more than that.


The developer has a small point, phpbb's wordmatch is made in a way that is very database intensive.

However, that is just a matter of economy, not the cause of the problem. Of course, with greater economy you give fewer chances for said problems to occur.

Quote:
Can the search utility be restricted so the table wont need to be so big?


Yes, however this can mean complicated modification of phpbb and locking yourself into a method (i.e. mysql fulltext search) that won't allow you to easily go back.

Quote:

Or is it not necessary? I've noticed lots of large forums, phpbb or others, seem to have troubles with their search and some of my competitors with various forums have been going to google to have site searches instead.


The indexing of so many words is always a bit problematic. But Google will never be as fresh as an index that's always up to date. The problem is that keeping it up to date is database intensive.

Google doesn't do live indexing, it has other machines building indexes than the one you use to search and then rolls out the updates.

phpbb does not have this kind of scalability, nor do any other forum software packages.
0 Replies
 
 

Related Topics

In How much time a website can be developed? - Question by aussiejumpingcastle
Webdevelopment and hosting - Question by harisit2005
Showing an Ico File - Discussion by Brandon9000
how to earn money in internet - Discussion by rizwanaraj
The version 10 bug. Worse then Y2K! - Discussion by Nick Ashley
CSS Border style colors - Question by meesa
There is no Wisdom in Crowds - Discussion by ebrown p
THANK YOU CRAVEN AND NICK!!! - Discussion by dagmaraka
I'm the developer - Discussion by Nick Ashley
 
  1. Forums
  2. » major phpbb_search_wordmatch problems
Copyright © 2021 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 06/22/2021 at 07:41:07