Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

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
Question ajoutée par Julfkar Moh Umar , Sr. Software Engineer , Aakash Edutech Private Limited
Date de publication: 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.

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?