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

  • Scanning for rootkits and possible exploits – RKHunter

    Rootkits are malicious softwares that are installed by intruders to gain access to your server once the security of the server has been breached.  Intruders can leave some malicious softwares...
  • Reset MySQL Password

    Resetting a MySQL Root Password is one of the easiest things to do. However, finding documentation on how to do so can be challenging.   We as system administrators, have...
  • 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...