nisha_singh
webdev2011
nrpatel_04
7php
learnphp123
Views : 534
Clicks : 23
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.
iCan
dishaWant to have your say? just login
Be first to show your opinion !!!