Last Updated: February 25, 2016
· alfuken

InnoDB vs MyISAM

TL;DR: writes.count > reads.count ? InnoDB : MyISAM;

There’s a lot of articles all over teh internets about comparing InnoDB vs MyISAM, but this note is rather like ‘note to self’. TL;DR says it all.

Decision QA:

InnoDB if:
* your table is going to be inserted, deleted, and updated much much more than it is going to be selected
* you prefer/require relational database design

MyISAM if:
* you need full-text search
* disk-space or ram is an issue
* in doubt?..