Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par Rashid Anwar , senior php developer , sparx it solution pvt ltd.
Date de publication: 2014/03/03
mohammed al shareif
par 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
par 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