Fandom

The Sysadmin Wiki

MySQL

157pages on
this wiki
Add New Page
Talk0 Share

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

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.