dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: How to Change the Storage Engine in MySQL

Learn how to change the storage engine used in MySQL to improve application performance.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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.

ALTER TABLE CITIES ENGINE = 'MYISAM';

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.

 

Visit the DevX Tip Bank

 





   
Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Thanks for your registration, follow us on our social networks to keep up-to-date