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


Tip of the Day
Language: SQL
Expertise: Intermediate
Jun 6, 2019

WEBINAR:

On-Demand

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


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.

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.

M S Sridhar
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Thanks for your registration, follow us on our social networks to keep up-to-date