How to Change the Storage Engine in MySQL

How to Change the Storage Engine in MySQL

Every table in MySQL will have a storage engine that offers certain capabilities. Some storage engines offer performance, some of them transaction support, and so on.

By default, all tables will be created with InnoDB, which supports transactions.

Your requirement could be such that for a given table, or set of tables, transactions may not be needed???which in turn increases the performance of data retrieval.

This can be done efficiently using the following command.


In the above command, we are changing the engine from InnoDB to MyISAM, which will decrease the time of data retrieval, thereby improving the overall performance of the application.

In the past, we have also seen the SHOW ENGINES;?command that will display all the available and supported engines in the given version of MySQL. You can use the required engine as per your application need.


Share the Post: