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

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

متابعة

What are the advantages of using Innodb over MyIASM storage engine in addition to transaction safe and foreign key constraint supports in innodb?

user-image
تم إضافة السؤال من قبل Rashid Anwar , senior php developer , sparx it solution pvt ltd.
تاريخ النشر: 2014/03/03
mohammed al shareif
من قبل mohammed al shareif , Team Leader , Beecell

for small databases and systems MyIasm is faster than InnoDB , 

 

but if your database could be increase and be largrer teh innoDB will be faster ,

 

innoDB lock record but myIsam support table level locking 

 

in addition of that innoDB able to create relations and triggers 

Hasan Hameed
من قبل Hasan Hameed , Freelance Web Developer , RicknSid

Other two advantages are:

  • InnoDB supports row level locking, while MyIASM supports table level locking
  • InnoDB writes data to pages in PK order

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