MySQL data analysis storage engine example explanation

Today we are going to talk about the MySQL storage engine. As a friend who works in the data analysis industry, I always say that we don’t need to go into detail about what the MySQL storage engine is, as long as we understand it.

1. Introduce cases

There are two people, Zhang Ma Hu and Li Xiaoxin, who are bicycle managers at the subway entrance. Every day many people come to store and retrieve bicycles. Zhang Mahu's management method is to store the items on his own without recording what car it is. Li is very careful. When he parks or retrieves his bike, he records the characteristics of the person who parks the bike and the characteristics of the bike. When someone comes to pick up the bike, he has to carefully check whether the characteristics of the person and the bike correspond.

think:
Who handles business faster, Zhang Mahu or Li Xiaoxin? Who is safer in bicycle management, Zhang or Ma Hu? Databases have different storage and management methods for the same data. In MySQL, we call such a thing a storage engine.

The name storage engine exists only in the mysql database. There is a corresponding mechanism in Oracle, but it is not called a storage engine. In Oracle, it is called the storage method of the table.

MySQL supports many storage engines, each of which has its own data storage method. At the same time, each storage engine has its own advantages and disadvantages. Therefore, you need to choose a storage engine that suits you at the right time.

2. View the system's default storage engine and default character set

-- MySQL versions 5.0 and above support 9 storage engines.
-- There is no need to write a semicolon after this code.
mysql> show engines \G

-- View the system's current default storage engine.
mysql> show variables like '%storage_engine%';

-- View the system default character set.
mysql> show variables like '%char%';

3. Common storage engines

1) MyISAM: does not support transactions. (Zhang Ma Hu)

Advantages and disadvantages of MyISAM:

2) InnoDB: supports transactions. (Li Xiaoxin)

Advantages and disadvantages of InnoDB:

3) MEMORY (just understand this)

Advantages and disadvantages of MEMORY:

4. Just understand the picture below

The above is the detailed content of the example explanation of MySQL data analysis storage engine. For more information about MySQL data analysis storage engine, please pay attention to other related articles on 123WORDPRESS.COM!