Re: Innodb vs myisam

["Krishna Chandra Prajapati" <prajapatikc@xxxxxxxxx>]

Hi,
I have executed ANALYZE TABLE for myisam tables, but still myisam is showing
more scanning of rows as compared to innodb. What does ANALYZE TABLE command
exactly do for myisam storage engine.

Thanks
Krishna


On Wed, Apr 2, 2008 at 9:48 PM, Rob Wultsch <wultsch@xxxxxxxxx> wrote:

> On Wed, Apr 2, 2008 at 8:52 AM, Jay Pipes <jay@xxxxxxxxx> wrote:
>
> > The MyISAM isn't scanning more rows.  It's that the InnoDB "rows" output
> in EXPLAIN is an estimate and the MyISAM one is accurate...
> >
> > -jay
>
> Also, if he was testing one storage engine vs another he might have
> dumped the table and reimported with the new engine. If he did not
> ANALYZE TABLE for a myisam then EXPLAIN will give large row counts in
> my experience.
>
> --
> Rob Wultsch
> wultsch@xxxxxxxxx
> wultsch (aim)
>



-- 
Krishna Chandra Prajapati