MySQL 5.5 new Feature Experience

Since the new MySQL version (5.6) has been used in the work, it has been used for 5.1; To facilitate optimization, experience the new version of the features

1 CPU multi-core processing

Previously this parameter was innodb_file_io_threads, 5.5 according to read and write changed to two parameters, the advantage is that the number of CPUs can be set according to read and write, but still do not support dynamic modification.

Mysql> Show variables like '%io_thread% ';

+-------------------------+-------+

| variable_name | Value |

+-------------------------+-------+

| Innodb_read_io_threads | 4 |

| Innodb_write_io_threads | 4 |

+-------------------------+-------+

2 rows in Set (0.00 sec)

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/7C/wKioL1UKf0yQp-aUAADy6Mf4V7A516.jpg "style=" float: none; "title=" read.jpg "alt=" Wkiol1ukf0yqp-auaady6mf4v7a516.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/82/wKiom1UKfiKwHw2IAADiDddGyZ4808.jpg "style=" float: none; "title=" write.jpg "alt=" Wkiom1ukfikwhw2iaadidddgyz4808.jpg "/>

Verification method: Show engine InnoDB status \g

2 improve the ability to brush dirty pages and merge insertions to improve I/O processing

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/82/wKiom1UKfwqgH8rVAAFGYNa_V-I212.jpg "title=" io.jpg "alt=" Wkiom1ukfwqgh8rvaafgyna_v-i212.jpg "/>

3 Brush Dirty page ability to improve

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/5B/7D/wKioL1UKgLawVNhhAADZOQQRyUo873.jpg "title=" Flush.jpg "alt=" Wkiol1ukglawvnhhaadzoqqryuo873.jpg "/>

4 buffer pool Thermal data survival time adjustment

such as mysqldump, such as a one-time operation can reduce the PCT, so that the block more into the new blocks zone, retain thermal data

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/5B/82/wKiom1UKgE6yMOO9AAL91ZGmKvQ837.jpg "title=" Old.jpg "alt=" Wkiom1ukge6ymoo9aal91zgmkvq837.jpg "/>

Update later

5 support for multiple buffer pool instances

Reference: "MySQL Management Way"

This article is from the "Wilson Work Memo" blog, declined reprint!

MySQL 5.5 new Feature Experience