Mysql engines

From wikinotes
Revision as of 02:59, 8 September 2022 by Will (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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