Re: Innodb vs myisam
- Date: Wed, 2 Apr 2008 09:18:11 -0700
- From: "Rob Wultsch" <wultsch@xxxxxxxxx>
- Subject: Re: Innodb vs myisam
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)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx