Mysql which engine

It is good for distributed environments. No storage engine is ideal for all circumstances. Some perform best under certain conditions and perform worse in other situations. There are tradeoffs than must be considered. A more secure solution takes more resources; it might be slower, take more CPU time, and disk space. MySQL is very flexible in the fact that it provides several different storage engines. Some of them, like the Archive engine, are created to be used in specific situations.

In some cases the answer is clear. Whenever we are dealing with some payment systems, we are obliged to use the most secure solution. We cannot afford to loose such sensitive data. InnoDB is the way to go. Only InnoDB supports foreign key referential integrity constraint and if we plan to use this constraint, then the choice is clear. If we do not specify the storage engine explicitly, then the default storage engine is used. Data Manipulation Statements. Parenthesized Query Expressions.

The Subquery as Scalar Operand. Comparisons Using Subqueries. Restrictions on Subqueries. Transactional and Locking Statements. Statements That Cause an Implicit Commit. Restrictions on XA Transactions.

Replication Statements. Functions which Configure the Source List. Alternative Storage Engines. Setting the Storage Engine.

Static Fixed-Length Table Characteristics. Compressed Table Characteristics. Pluggable Storage Engine Architecture. The Common Database Server Layer. InnoDB Cluster. InnoDB ReplicaSet. Error Messages and Common Problems. My MySQL database contains several tables using different storage engines specifically myisam and innodb.

How can I find out which tables are using which engine? Bit of a tweak to Jocker's response I would post as a comment, but I don't have enough karma yet :. Will open all info for all tables in less , press -S to chop overly long lines. You can even change it from there using the drop-down options list. PS: This guide is based on version 4. Can't guarantee the same path for very older versions.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 13 years ago.