Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
My SQL support differnt types of Storage Engine to store data, what is the best and optimal for your need.
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.
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.
