How to set up storage engine in MySQL

Today, I will talk to you about how to set up the storage engine in MySQL. Many people may not know much about it. In order to make you understand better, the editor has summarized the following for you. I hope you can get something according to this article.

MySQL Settings Storage engine

1) query storage engine

Use SELECT to confirm the session storage engine:

SELECT @ @ default_storage_engine

L confirm the storage engine for each table:

? SHOW CREATE TABLE City\ G

? SHOW TABLE STATUS LIKE 'CountryLanguage'\ G

? SELECT TABLE_NAME, ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'City' AND TABLE_SCHEMA =' world_innodb'\ G

L displays the storage engines supported by the system

Mysql > show engines

Mysql > select * from information_schema.ENGINES

2) set storage engine

Set the server storage engine in the startup configuration file:

[mysqld]

Default-storage-engine=

Use the SET command to set up the current customer session:

SET @ @ storage_engine=

The storage_engine parameter is discarded after 5.7.5, and the replacement parameter is: default_storage_engine

L use the CREATE TABLE statement to specify:

CREATE TABLE t (I INT) ENGINE =

After reading the above, do you have any further understanding of how to set up the storage engine in MySQL? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.