How to Display MySQL Storage Engines

Reading Time: < 1 minute
Pre-Flight Check
  • These instructions are intended for displaying a list of the installed MySQL storage engines.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.

If you’re not already logged into MySQL, visit our tutorial on connecting to MySQL!

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 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.

Avatar for J. Mays

About the Author: J. Mays

As a previous contributor, JMays shares his insight with our Knowledge Base center. In our Knowledge Base, you'll be able to find how-to articles on Ubuntu, CentOS, Fedora and much more!

Latest Articles

10 Python Tips and Tricks for Data Science Projects

Read Article

How to Upload Information to VMware through SFTP

Read Article

Accessing Man Pages on Ubuntu 16.04 LTS

Read Article

Premium Business Email Pricing FAQ

Read Article

Microsoft Exchange Server Security Update

Read Article