Mysql engines

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