...

View Full Version : InnoDB or MyISAM table types?



javinpaul
06-01-2011, 02:04 PM
Hi Guys, This is Javin here just joined this forum. I have worked in mysql so thought to start posting from this forum. my question is when should we use InnonDB and when should we use MyISAM engines ?

Thanks
Javin

bazz
06-01-2011, 02:28 PM
if your query will joining tables, you are better off using INNODB. That engine supports foreign key constraints, which help maintain referential integrity.
bazz

javinpaul
06-01-2011, 05:11 PM
are you sure , MyISAM doesn't support referential integrity , this seems very surprising to me because foreign key is something must have feature or am I missing something, Also is there any way to change the title of post, I received warning for meaning less title , this is for Moderators , Thanks.

guelphdad
06-01-2011, 06:11 PM
I think posts can be edited for a certain time. I have corrected it for you to something more descriptive.

Foreign key constraints ARE NOT supported by MyISAM engine as Bazz points out. You can create them but they are not enforced as they would be on INNODB table type.

Also note that CHECK constraints ARE NOT supported by any engine of MySQL at this time.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum