Pixelated a phpBB Template by SkaidonDesigns
 
Cheapest Web Software Support Area Forum Index www.cheapestwebsoftware.com
Play with the Best, be the Best!
Kaktusan Cash
FAQ
Search
Memberlist
Usergroups
Profile
Log in to check your private messages
Log in

The Mightiest Webmaster Solutions Ever
Rocket Pinger
Rocket Pinger
Links Organizer
Links Organizer
Cheapest Adult Scripts
Cheapest Adult Scripts
Blogs Automater
Blogs Automater

Haven't registered yet? Do it here now!
prune settings...

 
Post new topic   Reply to topic    Cheapest Web Software Support Area Forum Index -> Blogs Organizer
View previous topic :: View next topic  
Author Message
cessation



Joined: 02 Jan 2009
Posts: 44

PostPosted: Tue Feb 01, 2011 12:13 am    Post subject: prune settings... Reply with quote
Hi Kaktusan,
I was editing the prune settings from 4 months to 1 month. I noticed the boinstats table didn't drop in size though. That table should've shrunk quite a bit in size right? Does it take time to shrink or something?


Thanks
Back to top
View user's profile Send private message

Author Message
Atanasis
Owner


Joined: 22 May 2004
Posts: 4284
Location: The Net

PostPosted: Tue Feb 01, 2011 9:50 am    Post subject: Reply with quote
the pruner mechanism is trigerred at midnight only by the bocron.php cronjob

Thats why you didn't see the result immediately
_________________
Thanks,
Kaktusan

Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger ICQ Number

Author Message
cessation



Joined: 02 Jan 2009
Posts: 44

PostPosted: Tue Feb 01, 2011 11:31 am    Post subject: Reply with quote
Is there a way to do it manually? If I empty the boinstats table will the script still work?

I'm having problems at midnight with my VPS. So I'm trying to stop everything that doesn't need to be running.


Thanks
Back to top
View user's profile Send private message

Author Message
Atanasis
Owner


Joined: 22 May 2004
Posts: 4284
Location: The Net

PostPosted: Tue Feb 01, 2011 9:43 pm    Post subject: Reply with quote
yes, you can manually empty the tables - boinstats, boinkeywords and boiplogs
_________________
Thanks,
Kaktusan

Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger ICQ Number

Author Message
cessation



Joined: 02 Jan 2009
Posts: 44

PostPosted: Wed Feb 02, 2011 9:04 pm    Post subject: Reply with quote
Also is there a way to not optimize tables every 9 minutes? Is it important to run that query?

Thanks
Back to top
View user's profile Send private message

Author Message
Atanasis
Owner


Joined: 22 May 2004
Posts: 4284
Location: The Net

PostPosted: Wed Feb 02, 2011 9:53 pm    Post subject: Reply with quote
no there is no way to stop the optimizing. It is good to have it running as it reduces the load on the mysql a lot
_________________
Thanks,
Kaktusan

Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger ICQ Number

Display posts from previous:   
Post new topic   Reply to topic    Cheapest Web Software Support Area Forum Index -> Blogs Organizer All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2002 phpBB Group