Mysql engines

From wikinotes

Each table can have it's own engine,
performance may suffer if a join is made across two engine types.




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