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? Link to comment https://forums.phpfreaks.com/topic/50631-innodb/ 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. Link to comment https://forums.phpfreaks.com/topic/50631-innodb/#findComment-248983 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.