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.


About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist