List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 27 2006 3:42am
Subject:Re: Order to run ANALYZE, OPTIMIZE and CHECK
View as plain text  
In the last episode (Oct 27), wolverine my said:
> Given the commands like ANALYZE, OPTIMIZE and CHECK, what is the
> preference order to execute these commands?

OPTIMIZE calculates statistics as it rebuilds the table, so there's no
need to run an ANALYZE pass after it.  You shouldn't ever need to run a
CHECK unless your OS or MySQL crashes often. in which case you should
be filing bug reports :)

-- 
	Dan Nelson
	dnelson@stripped
Thread
Order to run ANALYZE, OPTIMIZE and CHECKwolverine my27 Oct
  • Re: Order to run ANALYZE, OPTIMIZE and CHECKDan Nelson27 Oct
    • Re: Re: Order to run ANALYZE, OPTIMIZE and CHECKDan Buettner27 Oct