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!

[Mickie D]

thanks

installed and clicked

[Gamingforce]

1.00 -> 1.01 - July 28, 2004

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

To update, simply upload the new dboptimize.php script found in the zip attachment in the first post of this thread.

[Gamingforce]

Originally Posted by 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,

It's useful regardless of the amount of posts your board has.

[Zoints]

What is the difference between this and the vbulletin repair/optize function that is built in (other than being automatic of course).

Thanks.

[Zachery]

Originally Posted by thegunowner149

What is the difference between this and the vbulletin repair/optize function that is built in (other than being automatic of course).

Thanks.

I dont think there is one, at least not that i can tell.

[Highlander]

its automatic thats different and it uses the sleep command

[Erwin]

I'm not too sure of running an optimize table function automatically like this. There is a small but real risk of database corruption. Make sure you run a backup script daily as well if you're going to do this before optimizing your tables (something you should always do anyway).

[Gamingforce]

I've never heard of database corruption through the optimize function?

[Erwin]

Originally Posted by Gamingforce

I've never heard of database corruption through the optimize function?

Neither have I - in fact, OPTIMIZE TABLE has REPAIR built-in, so if a table is corrupted this will repair it as well. However, unless you are going to switch off your forums, running OPTIMIZE on a live database runs a small risk of something wrong happening. That's all I'm saying.

[tcs]

Erwin is correct. The hack is good and I will run it knowing the dangers. Wouldn't take much to add a repair to it before optimize.