Jump to content


Photo

InnoDB vs MyISAM


  • Please log in to reply
2 replies to this topic

#1 bcamp1973

bcamp1973
  • Members
  • PipPipPip
  • Advanced Member
  • 133 posts

Posted 27 October 2006 - 04:18 PM

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!

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 27 October 2006 - 04:55 PM

From searches/book links:

PDF supplement of "The Definitive Guide to MySQL 5"
MyISAM v.s. InnoDB
Details and Comparison
http://www.innodb.com
Restrictions on InnoDB

Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 bcamp1973

bcamp1973
  • Members
  • PipPipPip
  • Advanced Member
  • 133 posts

Posted 27 October 2006 - 07:05 PM

good stuff!  thanks! :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users