List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:June 11 2002 11:49am
Subject:Re: MySQL AB: Need documentation clarification
View as plain text  
For the mail filter: SQL database

----- Original Message -----
From: "Heikki Tuuri" <Heikki.Tuuri@stripped>
To: <mysql@stripped>
Sent: Tuesday, June 11, 2002 2:47 PM
Subject: Re: MySQL AB: Need documentation clarification


> Erv,
>
>
> ----- Original Message -----
> From: "Erv Young" <res04ft9@stripped>
> Newsgroups: mailing.database.mysql
> Sent: Tuesday, June 11, 2002 3:49 AM
> Subject: MySQL AB: Need documentation clarification
> > 2)  Also, the discussion of ANALYZE TABLE at
> > http://www.mysql.com/doc/A/N/ANALYZE_TABLE.html leaves the user of
InnoDB
> > tables in limbo.  If this doesn't work on InnoDB tables, what takes its
> > place, or why does its place not need to be taken?
>
> both InnoDB and MyISAM keep also dynamically statistics about tables. In
> most cases running ANALYZE TABLE does not bring any benefit in query
> optimization.
>
> > Thanks.
> >
> > --Erv Young
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> ---
> InnoDB - transactions, hot backup, and foreign key support for MySQL
> See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
>
>


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