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

• Added sleep code that adds a pause after each database process. (Thanks KirbyDE)

Enjoy!

[Ghostsuit]

I think a PHP script might ground to a halt on my database but nice hack.

[Gamingforce]

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.

[Phalynx]

usefull, thanks! *install*

[Skyline_GT]

so this is similer to the repair feature in vb?

[SaN-DeeP]

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,

[sabret00the]

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:

    $tempcount++; 


add this, so it will add a second of pause:

PHP Code:

for ($i=0; $i < 1000; $i++) {
   // do nothing, 1000 times
} 


[Andreas]

Originally Posted by nexialys

PHP Code:

    $tempcount++; 


add this, so it will add a second of pause:

PHP Code:

for ($i=0; $i < 1000; $i++) {
   // do nothing, 1000 times
} 


Erm ... that causes unnecessary CPU load (if PHP isn't smart enough to just skip this).

Better use

PHP Code:

sleep(1); 


hum, ya, i forgot sleep()... thanks KirbyDE