surion Posted May 9, 2007 Share Posted May 9, 2007 hi all to be able to use transactions we re thinking about changing from MyISAM to InnoDB tables i know about the fact that conversion should not be used n stuf, i ve read alot of it on these pages http://dev.mysql.com/doc/refman/5.0/en/innodb-overview.html http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html BUT, is there any people here who have experience with the use of innodb-tables? and for those with experience, can you give me in short some reasons why i... ...SHOULD use innodb? ...SHOULD NOT use innodb? Quote Link to comment Share on other sites More sharing options...
effigy Posted May 9, 2007 Share Posted May 9, 2007 I've used them. InnoDB offers transactions, row level locking, foreign key constraints, and crash recovery. Some drawbacks are tablespace administration, no full-text indexes, no GIS data, and a larger cost if you purchase support. 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.