Administration Database MySQL

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:

MySQL_Storage_Engines

 

Typically the default storage engine will be set to MyISAM. This storage engine normally provides the best combination of performance and functionality, although it lacks transaction capabilities and uses table-level locking. Sometimes on higher traffic applications InnoDB is much better for performance and scalability.

Related Articles

  • LAMP STACK

    What is a LAMP Stack? “LAMP stack is a popular open source web platform commonly used to run dynamic web sites and servers. It includes Linux, Apache, MySQL, and PHP/Python/Perl...
  • Identify the process that is using some specific port

    Sometimes, you may encounter a situation where you see some ports being used by some service, but you cannot exactly determine which application/service is using it. This article talks about how...
  • How can I convert my MyISAM tables to InnoDB?

    If you want to convert a MyISAM table to InnoDB, the process is fairly easy, but you can do something extra to speed things up. Before converting the table, adjust...
  • Prevent hot linking of images.

    Hot linking is displaying an image on a website by linking to the same image on another website, rather than saving a copy of it on the website on which...