How to Display MySQL Storage Engines
- 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!
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. 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.
Related Articles:
![Avatar for J. Mays](/static/b9bfb850e038ebe4b3c49dd278744eee/9ca7a/b0da076b6e8552394da33fe3381a19fc.png)
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!
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.
Latest Articles
How to install PyTorch on Linux (AlmaLinux)
Read ArticleInnovative armor — exploring ThreatDown’s impact on cyber defense
Read ArticleControlling PHP settings with a custom php.ini file
Read ArticleLinux dos2unix command syntax — removing hidden Windows characters from files
Read ArticleChange cPanel password from WebHost Manager (WHM)
Read Article