Nightly Database Optimizer
Mod Version: 1.00, by Gamingforce
This modification is in the archives.
| vB Version: 3.0.3 | Rating:  (0 vote - 0 average) |
Installs: 35 |
| Released: 28 Jul 2004 | Last Update: Never | Downloads: 30 |
 Not Supported
|
||
[ 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
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
- Added sleep code that adds a pause after each database process. (Thanks KirbyDE)
Download
This modification is archived and cannot be downloaded.