Table types or storage engines in MySQL

MySQL supports many types of tables or storage engines that can store your data in a way that best fits the requirements of your application. Each table type / engine has its own advantages, disadvantages, and specific purpose. When you create a new table, you can tell MySQL which table type / engine it should use for the table. This section introduces MySQL’s storage engines, outlining the purpose, advantages, and disadvantages of each.

Table Types or Engines Related Categories

MyISAM Engine | Merge Engine | InnoDB Engine | Memory Engine | BDB Engine | Federated Engine | Archive Engine | CSV Storage | Blackhole Engine | Example Engine

Table Types or Engines Related FAQs

What is default table type of MySQL?

How to convert a table from one type to another in MySQL?

What are transaction-safe tables and not transaction-safe tables in MySQL?

How to get storage engines available on MySQL server?

What is the fastest storage engine in MySQL?