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

This article mainly introduces the characteristics of Innodb in mysql. It is very detailed and has certain reference value. Friends who are interested must finish reading it.

1. Insert buffers to merge multiple inserts into one operation.

The performance loss caused by random IO can be reduced.

2. Double-write mechanism to avoid data confusion caused by only half writing when refreshing dirty pages.

3. Adaptive hashing. If it is observed that building a hash index can improve performance, then build an hash index in the buffer pool.

4. Read ahead and predict which pages will be read and read into the buffer pool.

Example

Create table T1 (an int not null primary key, b int not null,c int not null,d varchar (32)) engine=InnoDB;create table T2 (an int not null primary key, b int not null,c int not null,d varchar (32)) engine=MyISAM; insert into T1 (arecalogical brecincec mai d) values (1pr 1pr 1pr 1pl Zhe a'); insert into T1 (areco bpl c recorder d) values (3pr 2pr c') values (3pr 2pr 2je c'); insert into T1 (arecy bje cje pr d) values (2pr 2pl c recorder d) Insert into T1 (4) values (4); insert into T1 (1) values (6); insert into T1 (1) values (7); insert into T1 (3) values (9); and values (11). Insert into T1 (values); insert into T2 (values); values (1pm); insert into T2 (pint 1) values (3); insert into T2 (2) values (2); insert into T2 (4) values Insert into T2 (values); insert into T2) values); insert into T2 (aforma2 brecince3) values); insert into T2 (arecalbrecrence3) values); all the contents of this article "what are the characteristics of Innodb in mysql"? thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.