nisha_singh
disha
iCan
kulu208
realin
Views : 112
Clicks : 18
How often should you use OPTIMIZE TABLE?
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.
Need to hire a great PHP developer? Want to change your job? Visit our Job's Section
Want to have your say? just login
Be first to show your opinion !!!