Shulou(Shulou.com)06/01 Report--

This article mainly introduces how mysql specifies the storage engine, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

The method of specifying the engine in mysql: 1, when creating a table, you can specify the storage engine through ENGINE, adding "engine= storage engine;" at the end of the create statement; 2, when modifying the table, you can use the "alter table table name engine= storage engine;" to specify the storage engine.

Storage engine, or table type (table_type)

According to the needs of the application, users can choose how to store data, index, whether to use transactions and so on. Choosing the right storage engine can effectively improve the performance of the database and the efficiency of data access. Multiple tables in another database can use the combination of different engines to meet a variety of performance and practical needs.

MySQL supports many storage engines, including MyISAM, InnoDB, BDB, MEMORY, MERGE, EXAMPLE, NDB Cluster, ARCHIVE, etc., among which InnoDB and BDB support transaction security. It also supports some third-party storage engines, such as TokuDB (high write performance and high compression storage engine) and Infobright (column storage engine).

Mysql specifies the storage engine

The first way to change the storage engine is to change the MySQL configuration file, as shown in the following figure, find the my.ini file

Open a line to find the line shown in the following figure, where you can modify the storage engine to what you need, as shown in the following figure

Next, we can also modify it through the SQL statement, as shown in the following figure

In the process of creating a table, you can specify the storage engine through ENGINE and add engine=MyISAM at the end of the create statement

Next, look at the table creation statement through the Show statement, and you will find that the storage engine has been modified to MyISAM, as shown in the following figure

In addition, we can also modify the existing table storage engine through the alter table statement, as shown in the following figure

After modification, check the storage engine for verification through the Show statement, as shown in the following figure

Extended data

View the storage engine used by the current table

Mysql > show create table emp

Or

Mysql > show table status like 'emp'\ G

View the storage engines supported by the current database

Mysql > show engines\ G; Thank you for reading this article carefully. I hope it will be helpful for everyone to share how mysql specifies the content of the storage engine. At the same time, I also hope you can support us, pay attention to the industry information channel, and find out if you have any problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.