ANALYZE/OPTIMIZE TABLE are not necessary with proper mysql settings.