Error pages due to large PhpBB DB file?

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

PhpNuke version: v6.7 (modded)
PhpBB version: v2.0.6
PhpBB DB size: 776MB

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

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.

I've checked (3 times in the last month) with my host (site5.com), and they say everything looks fine. Myself, I didn't change anything in the last month. the only thing that came in mind is the size of PhpBB's DB, which is over 750MB!

Can this be the problem? What's phpbb's DB file recommended size anyway? if not, what should I check? do you have any idea where to start looking for a problem?

Thanks in advance!

Sells PC To Pay For Divorce Joined: Posts: 5661

well looking at your phpbb i dont see how you can get a database of 776MB ..
And if you go into phpmyadmin..whats the largest table ?

Posted: Tue Sep 20, 2005 2:27 pm

Oops, 776 MB AND EVRYTHING LOOKS FINE !How do you make your backups ? We have only 6.56 MB, but if I backup I have tu use phpMyAdmin.

Posted: Tue Sep 20, 2005 2:30 pm

I see the surprised faces... I should have told you I also use the attach_mod, so the files uploaded might affect the DB size, right?

Posted: Tue Sep 20, 2005 2:33 pm

No not realy....
attachments are stored in a folder..
So whats your largest table ?

Posted: Tue Sep 20, 2005 2:34 pm

hitwalker, am trying to find out. somewhy I have troubles logging in...

Posted: Tue Sep 20, 2005 2:35 pm

btw, would gzip help?

Posted: Tue Sep 20, 2005 2:36 pm

a litle ,not much....maybe a few seconds in load..
and would make backups easier...

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

Use phpMyAdmin and run a REPAIR on your database and then OPTIMIZE the database.

Posted: Tue Sep 20, 2005 2:55 pm

nuke_msanalysis_online = 486.7mb !

Posted: Tue Sep 20, 2005 2:57 pm

ahh...empty it...

Posted: Tue Sep 20, 2005 2:59 pm

Quote:

Use phpMyAdmin and run a REPAIR on your database and then OPTIMIZE the database.

Thanks. currently running...

Posted: Tue Sep 20, 2005 3:01 pm

well it doesnt mean it will solve your problem but its useless to keep track of your visits in this way..try to change the settings in ms analysis.....etc...

Posted: Tue Sep 20, 2005 3:42 pm

Quote:

try to change the settings in ms analysis

How do I keep the table smaller? couldn't find anything in the admin screen...

Posted: Tue Sep 20, 2005 4:01 pm

Hi...
well im not sure if the function is in the standard version..
But that table just keeps track of your members online and when,what time etc...
Its realy not that usefull..
I suggest you contact Mat of matyscripts and ask him how to prevent this ..
I use ms analysis pro and allthough i would like to see it different ,the pro has a "msanalysis_online" of one hour.
After that the table is emptied.

Posted: Tue Sep 20, 2005 4:02 pm

Ok, I've emptied the table. now the biggest table is nuke_bbsearch_wordmatch = 39.5MB, that's after I've emptied nuke_IP_Tracking = 193MB...

Posted: Tue Sep 20, 2005 4:07 pm

Quote:

I suggest you contact Mat of matyscripts and ask him how to prevent this ..

Thanks, I've found it just now.
Dunno how come I've over looked it last time..

Posted: Tue Sep 20, 2005 4:07 pm

well nuke_bbsearch_wordmatch is for you to decide if you wanna keep it,its just some statistics...
words,keywords used to search your forums..

Posted: Tue Sep 20, 2005 5:14 pm

ring_c wrote:

Ok, I've emptied the table. now the biggest table is nuke_bbsearch_wordmatch = 39.5MB, that's after I've emptied nuke_IP_Tracking = 193MB...

You need to keep that Smile

Posted: Tue Sep 20, 2005 11:02 pm

Quote:

You need to keep that

Dear Raven (long time no talk, btw), do you refer to nuke_bbsearch_wordmatch or to nuke_IP_Tracking to keep?

Posted: Tue Sep 20, 2005 11:08 pm

Keep the WordSearch. If you run NukeSentinel and have IP Tracking on then you don't need that table and you should turn all other IP tracking off.

Posted: Tue Sep 20, 2005 11:10 pm

Guys, is there a way to schedule this repair+optimize thingy? it seems to have helped a lot!

Posted: Tue Sep 20, 2005 11:17 pm

Quote:

Keep the WordSearch. If you run NukeSentinel and have IP Tracking on then you don't need that table and you should turn all other IP tracking off.

Hmmm... I do use NukeSentinel, and as you could see I also use IP Tracking (is there a way to truncate the saved information for this one?). I've disabled MS-Analysis yseterday, after seeing the monstrous size its table got to... is that what you meant? any other advice I could use?

Posted: Tue Sep 20, 2005 11:17 pm

You normally should not have to REPAIR. MySQL will let you know when you need that, by not working ROTFL

The Optimize could be scheduled via a cron job. It's available from your Nuke Admin Control Panel. Just remember to run it once a month or so.

Posted: Tue Sep 20, 2005 11:20 pm

ring_c wrote:

Quote:

Keep the WordSearch. If you run NukeSentinel and have IP Tracking on then you don't need that table and you should turn all other IP tracking off.

Hmmm... I do use NukeSentinel, and as you could see I also use IP Tracking (is there a way to truncate the saved information for this one?). I've disabled MS-Analysis yseterday, after seeing the monstrous size its table got to... is that what you meant? any other advice I could use?

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