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 1:59 pm Reply with quote

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!
 
View user's profile Send private message Visit poster's website
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Tue Sep 20, 2005 2:23 pm Reply with quote

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 ?
 
View user's profile Send private message
Susann
Moderator


Joined: Dec 19, 2004
Posts: 3191
Location: Germany:Moderator German NukeSentinel Support

PostPosted: Tue Sep 20, 2005 2:27 pm Reply with quote

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.


Last edited by Susann on Tue Sep 20, 2005 2:31 pm; edited 1 time in total 
View user's profile Send private message
ring_c
PostPosted: Tue Sep 20, 2005 2:30 pm Reply with quote

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?
 
hitwalker
PostPosted: Tue Sep 20, 2005 2:33 pm Reply with quote

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


Last edited by hitwalker on Tue Sep 20, 2005 2:37 pm; edited 1 time in total 
ring_c
PostPosted: Tue Sep 20, 2005 2:34 pm Reply with quote

hitwalker, am trying to find out. somewhy I have troubles logging in...
 
ring_c
PostPosted: Tue Sep 20, 2005 2:35 pm Reply with quote

btw, would gzip help?
 
hitwalker
PostPosted: Tue Sep 20, 2005 2:36 pm Reply with quote

a litle ,not much....maybe a few seconds in load..
and would make backups easier...
 
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

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

Use phpMyAdmin and run a REPAIR on your database and then OPTIMIZE the database.
 
View user's profile Send private message
ring_c
PostPosted: Tue Sep 20, 2005 2:55 pm Reply with quote

nuke_msanalysis_online = 486.7mb !
 
hitwalker
PostPosted: Tue Sep 20, 2005 2:57 pm Reply with quote

ahh...empty it...
 
ring_c
PostPosted: Tue Sep 20, 2005 2:59 pm Reply with quote

Quote:

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

Thanks. currently running...
 
hitwalker
PostPosted: Tue Sep 20, 2005 3:01 pm Reply with quote

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...
 
ring_c
PostPosted: Tue Sep 20, 2005 3:42 pm Reply with quote

Quote:

try to change the settings in ms analysis

How do I keep the table smaller? couldn't find anything in the admin screen...
 
hitwalker
PostPosted: Tue Sep 20, 2005 4:01 pm Reply with quote

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.
 
ring_c
PostPosted: Tue Sep 20, 2005 4:02 pm Reply with quote

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...
 
ring_c
PostPosted: Tue Sep 20, 2005 4:07 pm Reply with quote

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..
 
hitwalker
PostPosted: Tue Sep 20, 2005 4:07 pm Reply with quote

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..
 
Raven
PostPosted: Tue Sep 20, 2005 5:14 pm Reply with quote

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
 
ring_c
PostPosted: Tue Sep 20, 2005 11:02 pm Reply with quote

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?
 
Raven
PostPosted: Tue Sep 20, 2005 11:08 pm Reply with 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.
 
ring_c
PostPosted: Tue Sep 20, 2005 11:10 pm Reply with quote

Guys, is there a way to schedule this repair+optimize thingy? it seems to have helped a lot!
 
ring_c
PostPosted: Tue Sep 20, 2005 11:17 pm Reply with quote

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?
 
Raven
PostPosted: Tue Sep 20, 2005 11:17 pm Reply with quote

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.
 
Raven
PostPosted: Tue Sep 20, 2005 11:20 pm Reply with quote

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