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! Link to comment https://forums.phpfreaks.com/topic/25322-innodb-vs-myisam/ 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] Link to comment https://forums.phpfreaks.com/topic/25322-innodb-vs-myisam/#findComment-115461 Share on other sites More sharing options...
bcamp1973 Posted October 27, 2006 Author Share Posted October 27, 2006 good stuff! thanks! :) Link to comment https://forums.phpfreaks.com/topic/25322-innodb-vs-myisam/#findComment-115520 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.