Re: InnoDB to MyISAM
This might have the answer:
http://forums.mysql.com/read.php?24,355844,356641
A word of caution on Engine changing: Indexes have some subtle differences.
InnoDB's PRIMARY KEY is "clustered"; MyISAM's is not.
InnoDB's Secondary keys have to drill down the primary key; MyISAM does not.
InnoDB's secondary indexes have the PK implicitly in the leaf nodes in the index; this may lead to InnoDB "Using index". MyISAM does not.
MyISAM does not require a PK.
Subject
Views
Written By
Posted
4722
June 08, 2010 03:28PM
Re: InnoDB to MyISAM
2292
June 09, 2010 07:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.