FANDOM


InnoDB vs. MyISAM Edit

The advantages of the different types of tables are in short:

MyISAM

  • Faster reads
  • Fulltext indexes

InnoDB

  • Faster edits
  • Foreign key constraints
  • Transactions

The type can be set on each table. It's also possible to have a table with multiple types, if the database is replicated. The original table would have the InnoDB type with faster edits and the replicated table(s) would have MyISAM, which has faster reads.

MySQL Monitoring Edit

This will show current MySQL processes. The n = seconds between screen refresh.

# mysqladmin proc stat
# watch -n 5 'mysqladmin proc stat'

External links Edit