Mysql engines: Revision history

From wikinotes

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

8 September 2022

4 September 2022

  • curprev 21:0221:02, 4 September 2022Will talk contribs 531 bytes +531 Created page with "Each table can have it's own engine,<br> performance may suffer if a join is made across two engine types. {| class="wikitable" |- | 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..."