How to Display MySQL Storage Engines

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.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

What are the XWEBHosting Name Servers (NS)?

So let’s say your server is online, it has been secured with ServerGuard™, and...

Apache Optimization

The default Apache settings that cPanel sets upon install are definitely something that can be...

Restore Your WordPress Database with WP-CLI

This article is a follow up to a previous article on the process of backing up a WordPress...

Fighting Spam on cPanel Servers

On cPanel servers there are a several different tools that are built into cPanel that can be used...

Error: Failed to connect to ’127.0.0.1:7199′: Connection refused (Cassandra) [SOLVED]

Error While Using Cassandra’s ‘nodetool’ This error may occur when using the ‘nodetool’ command,...

Powered by WHMCompleteSolution