ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is the difference between database engines like Innodb and MyISAM etc?

The best way to design a database is first to find out all entities and All attributes of a entity and  relationship between them.Then make table according to your entity and columns according to its attributes and maintain relationship using foreign keys.

user-image
تم إضافة السؤال من قبل Julfkar Moh Umar , Sr. Software Engineer , Aakash Edutech Private Limited
تاريخ النشر: 2016/01/09
مستخدم محذوف‎
من قبل مستخدم محذوف‎

First major difference I see is that InnoDB implements row-level lock while MyISAM can do only a table-level lock. You will find better crash recovery in InnoDB. However, it doesn't haveFULLTEXTsearch indexes until v5.6, as does MyISAM. InnoDB also implements transactions,foreign keys and relationship constraints while MyISAM does not.

المزيد من الأسئلة المماثلة