leeoniya Posted September 29, 2011 Report Share Posted September 29, 2011 according to http://dev.mysql.com/doc/refman/5.5/en/sto...ne-setting.html If you omit the ENGINE option, the default storage engine is used. The default engine is InnoDB as of MySQL 5.5.5 (MyISAM before 5.5.5).i'm not sure if this was an oversight, or intentional behavior. InnoDB should NOT be disabled, and in fact should have been the default since way-back: Uniform Server v5.7.0 regards,leon Quote Link to comment Share on other sites More sharing options...
BobS Posted October 3, 2011 Report Share Posted October 3, 2011 Actually, the reason is for portability and separation of installed apps. If you have two apps that both use InnoDB, the data is mixed in the ibdata1 file. This makes it more difficult to do simple data moves, where the MyISAM data is kept in each db's subdirectory. The application plugins make use of this to simplify installation. The other reason is that's the way it's been for a long time. Regards,BobS Quote Link to comment Share on other sites More sharing options...
leeoniya Posted October 3, 2011 Author Report Share Posted October 3, 2011 Actually, the reason is for portability and separation of installed apps. If you have two apps that both use InnoDB, the data is mixed in the ibdata1 file. This makes it more difficult to do simple data moves, where the MyISAM data is kept in each db's subdirectory. The application plugins make use of this to simplify installation. The other reason is that's the way it's been for a long time. Regards,BobS this seems like the solution needed for portability, no? http://dev.mysql.com/doc/refman/5.0/en/inn..._file_per_table Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.