Mysql engines
From wikinotes
Each table can have it's own engine,
performance may suffer if a join is made across two engine types.
Documentation
InnoDB https://dev.mysql.com/doc/refman/5.7/en/innodb-storage-engine.html
Notes
innodb write/concurrency optimized (row lock on write) myisam read optimized (table lock on write) memory slow, only supports hash indexes, used for temporary tables. federated defers reads/writes to other databases. slow on joins, aggregates, etc. blackhole writes not persisted. csv csvs written to a special directory automatically become tables