| Author |
Message |
ring_c
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
 Posted:
Tue Sep 20, 2005 1:59 pm |
 
|
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! |
|
|
 
|
|
hitwalker
Sells PC To Pay For Divorce
Joined:
Posts: 5661
|
| Posted:
Tue Sep 20, 2005 2:23 pm |
|
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 ? |
|
|
|
|
|
Susann
Moderator
Joined: Dec 19, 2004
Posts: 3143
Location: Germany:Moderator German NukeSentinel Support
|
| 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. |
Last edited by Susann on Tue Sep 20, 2005 2:31 pm; edited 1 time in total |
|
|
|
|
ring_c
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
| 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? |
|
|
|
|
|
hitwalker
Sells PC To Pay For Divorce
Joined:
Posts: 5661
|
| Posted:
Tue Sep 20, 2005 2:33 pm |
|
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
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
| Posted:
Tue Sep 20, 2005 2:34 pm |
|
hitwalker, am trying to find out. somewhy I have troubles logging in... |
|
|
|
|
|
ring_c
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
| Posted:
Tue Sep 20, 2005 2:35 pm |
|
|
|
|
|
hitwalker
Sells PC To Pay For Divorce
Joined:
Posts: 5661
|
| Posted:
Tue Sep 20, 2005 2:36 pm |
|
a litle ,not much....maybe a few seconds in load..
and would make backups easier... |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| Posted:
Tue Sep 20, 2005 2:39 pm |
|
Use phpMyAdmin and run a REPAIR on your database and then OPTIMIZE the database. |
|
|
 
|
|
ring_c
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
| Posted:
Tue Sep 20, 2005 2:55 pm |
|
nuke_msanalysis_online = 486.7mb ! |
|
|
|
|
|
hitwalker
Sells PC To Pay For Divorce
Joined:
Posts: 5661
|
| Posted:
Tue Sep 20, 2005 2:57 pm |
|
|
|
|
|
ring_c
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
| 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... |
|
|
|
|
|
hitwalker
Sells PC To Pay For Divorce
Joined:
Posts: 5661
|
| 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... |
|
|
|
|
|
ring_c
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
| 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... |
|
|
|
|
|
hitwalker
Sells PC To Pay For Divorce
Joined:
Posts: 5661
|
| 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. |
|
|
|
|
|
ring_c
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
| 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... |
|
|
|
|
|
ring_c
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
| 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.. |
|
|
|
|
|
hitwalker
Sells PC To Pay For Divorce
Joined:
Posts: 5661
|
| 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.. |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| 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  |
|
|
|
|
|
ring_c
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
| 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? |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| 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. |
|
|
|
|
|
ring_c
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
| 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! |
|
|
|
|
|
ring_c
Involved
Joined: Dec 28, 2003
Posts: 276
Location: Israel
|
| 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? |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| 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 
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
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| 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. |
|
|
|
|
|
|
|
|
|
![[Valid RSS]](http://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
:: 
::
