InnoDB vs. MyISAM Edit
The advantages of the different types of tables are in short:
- Faster reads
- Fulltext indexes
- Faster edits
- Foreign key constraints
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'