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

How to Install the Xfce Desktop Environment on Ubuntu 14.04 LTS

By default XWeb servers running Ubuntu 14.04 don’t include a graphical desktop environment. It’s...

How to Create a Self-signed SSL Certificate on Ubuntu

An SSL certificate is an electronic ‘document’ that is used to bind together a public...

How to List Compiled PHP Modules from Command Line

Pre-Flight Check These instructions are intended specifically for listing compiled PHP modules...

How To Install Git on Ubuntu 14.04

Introduction Git is an open source, distributed version control system (VCS). It’s...

How To Install Apache Tomcat 7 on Ubuntu 14.04

Step 1a: Install Tomcat with apt-get Easy… just one command! apt-get install tomcat7...

Powered by WHMCompleteSolution