Views : 244 Clicks : 20

How often should you use OPTIMIZE TABLE?

By iCan via www.xaprb.com
Submitted On February 8, 2010

Many times I’ve heard people advise on “best practices” for a MySQL database. This often includes routine maintenance, such as “you should run OPTIMIZE TABLE on all of your InnoDB tables once a week to defragment them for better performance.”

But this advice is unsubstantiated and could even be detrimental.

 0 Comments   Tags: Database

Wanted: Senior Software Engineer at Solutions Beyond Pvt Ltd (Chandigarh). See this and other great job listings on the jobs page.

Freshly Arrived

1. Simple movie search using PHP, jQuery and themoviedb.org API
2. Running PHPUnit with the IBM i
3. Timing PHP script execution time
4. Social Share/Vote Button plugin for joomla content
5. New Wordpress Plugin: Escape HTML

Getting Hotter

1. Integrating Dreamweaver CS5 and Joomla 1.5 OR Joomla 1.6
2. Scaling WordPress on Microsoft
3. More WordPress Useless Stats And Graphs
4. jQuery and Ajax Best Demos Part-7
5. Writing Clean CSS3 Code