MySQL Forums
Forum List  »  Backup

Re: MyISAM VS InnoDB table types
Posted by: Kathy Mazur Worden
Date: January 02, 2007 09:54AM

To see what engine your existing table are, run:
show table status;
Engine is listed second.

MyISAM has been the default storage engine since 3.23. To see what your server is setup to use for the default engine, run:
show variables like 'storage_engine';

Options: ReplyQuote

Written By
December 26, 2006 09:22AM
Re: MyISAM VS InnoDB table types
January 02, 2007 09:54AM

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.