Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

What is the best storage engine for MySQL?

My SQL support differnt types of Storage Engine to store data, what is the best and optimal for your need.

user-image
Question ajoutée par Jainesh Dalicha , System Administrator , The Beast Apps
Date de publication: 2017/08/17
Asif Abdul salam
par Asif Abdul salam , System Administrator , A Small Orange

Mysql supports different storage engines , out of which the most prominently used one are innodb and Myisam , both of them has there on advantage and disadvantage .

MyISAM is suitable for small project.

InnoDB  does not support FULLTEXT index while MyISAM supports , which make the search fast

InnoDB is better option while you are dealing with larger database because it supports transactions, volume .

InnoDB supports row-level locking which means inserting and updating is much faster as compared with MyISAM.

 

 

Mohammad kasid
par Mohammad kasid , ICT Engineer (Sr. Database Administrator) , Ericsson Global India Ltd.

Mysql supports different storage engines like InnoDB , MyISAM, Memory, Balck Hole, Archieve, federated 

But InnoDB is suited well in most of the cases as It has added advantage of trasanction. from 5.6 version onwards it support full text searching as well. 

More Questions Like This

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