0

Possible Duplicate:
MyISAM versus InnoDB

what is the difference between innodb and myisam ? i see both of them as a type of engine in my mysql database.

Community
  • 1
  • 1
justjoe
  • 5,454
  • 9
  • 44
  • 64
  • http://stackoverflow.com/questions/277440/mysql-myisam-vs-inno-db – OMG Ponies Aug 26 '10 at 01:17
  • http://stackoverflow.com/questions/1970160/should-i-always-prefer-mysql-innodb-over-myisam – OMG Ponies Aug 26 '10 at 01:17
  • try this [http://serverfault.com/questions/54897/what-is-the-difference-between-innodb-and-myisam](http://serverfault.com/questions/54897/what-is-the-difference-between-innodb-and-myisam) – Jaime Aug 26 '10 at 01:13

1 Answers1

3

The main difference is that InnoDB supports transactions, but MyISAM does not.

Mat
  • 202,337
  • 40
  • 393
  • 406
Eka Rudito
  • 30
  • 1
  • 4
  • referential integrity too. But Full Text Search is only supported on MyISAM... – OMG Ponies Aug 26 '10 at 01:11
  • Typically MyISAM is used for logging tables, while InnoDB is much better suited for tables with important data that needs to maintain integrity. – Zoidberg Aug 26 '10 at 01:13