|
Haven't registered yet? Do it here now!
|
cessation
Joined: 02 Jan 2009 Posts: 44
|
|
|
|
|
|
|
Posted: Tue Feb 01, 2011 12:13 am Post subject: prune settings... |
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
Atanasis Owner
Joined: 22 May 2004 Posts: 4284 Location: The Net
|
|
|
|
|
|
|
Posted: Tue Feb 01, 2011 9:50 am Post subject: |
|
|
|
|
|
|
|
|
|
|
the pruner mechanism is trigerred at midnight only by the bocron.php cronjob
Thats why you didn't see the result immediately _________________ Thanks,
Kaktusan
|
|
|
|
|
|
|
|
cessation
Joined: 02 Jan 2009 Posts: 44
|
|
|
|
|
|
|
Posted: Tue Feb 01, 2011 11:31 am Post subject: |
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
Atanasis Owner
Joined: 22 May 2004 Posts: 4284 Location: The Net
|
|
|
|
|
|
|
Posted: Tue Feb 01, 2011 9:43 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
yes, you can manually empty the tables - boinstats, boinkeywords and boiplogs _________________ Thanks,
Kaktusan
|
|
|
|
|
|
|
|
cessation
Joined: 02 Jan 2009 Posts: 44
|
|
|
|
|
|
|
Posted: Wed Feb 02, 2011 9:04 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
Also is there a way to not optimize tables every 9 minutes? Is it important to run that query?
Thanks |
|
|
|
|
|
|
|
Atanasis Owner
Joined: 22 May 2004 Posts: 4284 Location: The Net
|
|
|
|
|
|
|
Posted: Wed Feb 02, 2011 9:53 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
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
|
|
|
|
| |