How to Display MySQL Storage Engines Print

  • 1

How to Display MySQL Storage Engines

From the MySQL command line, issue the following command:

SHOW ENGINES;


You should receive a result similar to:

How to Display MySQL Storage Engines


Typically the default storage engine will be set to <reference_page_text>MyISAM. It is a derivative of the original ISAM engine type supported in early versions of the MySQL system. This storage engine provides the best combination of performance and functionality, although it lacks transaction capabilities and uses table-level locking.


Was this answer helpful?

« Back