Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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
Question added by Rashid Anwar , senior php developer , sparx it solution pvt ltd.
Date Posted: 2014/03/03
mohammed al shareif
by 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
by 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

More Questions Like This