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

  • 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...
  • Setting files as immutable.

    Wouldn’t it be nice if we can set files so that even root cannot modify or delete it ? Both FreeBSD and Linux come with commands that allows us to...
  • Monitoring MySQL

    Monitoring MySQL servers can be difficult in a way that a novice won’t be able to monitor MySQL that easily. MySQL gives a comprehensive list of variables to check your server’s health...
  • 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...