Myisam
MyISAM is a non-transactional storage engine for MySQL
Tokudb
TokuDB is a storage engine for MySQL that is designed for high performance on write-intensive workloads while providing high compression and schema flexibility.
Slower disk usage
Example |
---|
"At the beginning the insert performance of innodb is almost 50 times slower than myisam and tokudb is 40 times slower than myisam" from question Why TokuDB and InnoDB insert is so slow compared to MyISAM |
"From my personal use i experienced about 5 - 10 times less disk usage due to tokudb s compression and it s much much faster than myisam or innodb" from question Storage engine for large amounts of constantly inserted data which should be available instantly |
Others
Example |
---|
Most of other options listed in your screenshot are either special-purpose storage engines which are not suitable for general use memory example federated archive csv and blackhole or are not available in standard builds of mysql most of the rest inifinidb brighthouse and tokudb;the lone exception is myisam which is an older mysql storage engine which does not support transactions is more prone to corruption and generally tends to perform worse than innodb from question What MySQL storage engine i should on MMO/Multiplayer game? |