bcamp1973 Posted October 27, 2006 Share Posted October 27, 2006 I'm bulding a multi-user CMS and I'm interested in using transactions and row level locking (InnoDB only as i understand it?). I've always built sites using MyISAM. I'm using MySQL 4.1.15. Can someone breakdown the benefits/gotchas of using INNODB for me? I want to make sure if i make that switch that I'm not going to get bit :) Thanks! Quote Link to comment Share on other sites More sharing options...
effigy Posted October 27, 2006 Share Posted October 27, 2006 From searches/book links:[url=http://www.apress.com/ApressCorporate/supplement/1/10011/1590595351-2977.pdf]PDF supplement of "The Definitive Guide to MySQL 5"[/url][url=http://wiki.dreamhost.com/index.php/MyISAM_versus_InnoDB_tables]MyISAM v.s. InnoDB[/url][url=http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html]Details and Comparison[/url][url=http://www.innodb.com]http://www.innodb.com[/url][url=http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html]Restrictions on InnoDB[/url] Quote Link to comment Share on other sites More sharing options...
bcamp1973 Posted October 27, 2006 Author Share Posted October 27, 2006 good stuff! thanks! :) 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.