ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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
تم إضافة السؤال من قبل Jainesh Dalicha , System Administrator , The Beast Apps
تاريخ النشر: 2017/08/17
Asif Abdul salam
من قبل 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
من قبل 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. 

المزيد من الأسئلة المماثلة