![]() |
Nightly Database Optimizer
[ Feature Description ]
This is a simple, very easy to install hack that automatically optimizes your database daily! The optimizer uses MySQL's 'optimize table' function. In simple terms, you can look at the optimize command as a hard drive defragmenter. It reclaims lost space and defragments the database file. By default, this modification runs the optimize script nightly at 3:22 AM (which statistically on my board is the least busiest time). You can run it weekly, monthly or whenever you want by changing the settings under the Scheduled Task Manager. The script includes all the tables that get heavy daily activity. You can easily add other tables if you wish by opening up the dboptimize.php file and simply adding extra table names to the end of the list. [ Version Fix Log ] 1.00 -> 1.01 - July 28, 2004
|
I think a PHP script might ground to a halt on my database but nice hack.
|
The optimization happens at off peak times and content is still accessible during the optimization process. I have a board with almost a million posts and it works fine.
|
usefull, thanks! *install*
|
so this is similer to the repair feature in vb?
|
thnx for nice hack GamingForce.
but just a small query is this useful for small boards ? lets say which have 50,000 - 60,000 posts ? Regards, |
how long have you been running it gaming force as i would fear that it would currupt some data one in a freak accident that would cos me :(
|
to make the script to not stuck the server and the db process, inside the code, just after
PHP Code:
PHP Code:
|
Quote:
Better use PHP Code:
|
hum, ya, i forgot sleep()... thanks KirbyDE
|
All times are GMT. The time now is 08:24 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|