List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:July 1 2002 8:49pm
Subject:Re: MySQL AB: Need documentation clarification
View as plain text  
On Tue, Jun 11, 2002 at 03:58:14PM -0700, Jeff Kilbride wrote:
> > both InnoDB and MyISAM keep also dynamically statistics about tables. In
> > most cases running ANALYZE TABLE does not bring any benefit in query
> > optimization.
> 
> Personally, I'm pretty shocked to hear you say this. I was under the
> impression that running ANALYZE TABLE was a "good thing" and helped
> ensure the key distribution for the table in question was up to
> date.

You're correct.  There are times when the MyISAM table handler looses
touch with what the table really contains.  Running ANALYZE or
OPTIMIZE will fix that.

Jeremy
-- 
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.51: up 32 days, processed 706,777,053 queries (248/sec. avg)
Thread
MySQL AB: Need documentation clarificationErv Young11 Jun
  • Re: MySQL AB: Need documentation clarificationDan Nelson11 Jun
    • RE: MySQL AB: Need documentation clarificationJon Frisby11 Jun
Re: MySQL AB: Need documentation clarificationHeikki Tuuri11 Jun
Re: MySQL AB: Need documentation clarificationHeikki Tuuri11 Jun
Re: MySQL AB: Need documentation clarificationJeff Kilbride12 Jun
  • Re: MySQL AB: Need documentation clarificationJeremy Zawodny1 Jul