How to Display MySQL Storage Engines
From the MySQL command line, issue the following command:
SHOW ENGINES;
You should receive a result similar to:
Typically the default storage engine will be set to MyISAM. This storage engine normally provides the best combination of performance and functionality, although it lacks transaction capabilities and uses table-level locking. Sometimes on higher traffic applications InnoDB is much better for performance and scalability.
