Shulou(Shulou.com)05/31 Report--

This article shows you what MySQL5.7 does in the InnoDB layer performance optimization and new features, the content is concise and easy to understand, absolutely can make your eyes bright, through the detailed introduction of this article, I hope you can get something.

Performance optimization:

Transaction: transaction object pool; optimized read-write transaction list scan to Memcpy; remove read-only transaction list; Cache Read view; implicit lock conversion optimization to reduce large lock holding time; transaction priority

Temporary table: independent temporary table space; independent undo; does not record redo; does not do fsync; uses innoDB temporary table as the intermediate result table of the optimizer

Buffer Pool: multiple page cleaner threads; more efficient flush strategy

Redo Log: fix problems with read-on-write through padding; default CRC32 checksum; adds version information in log format

Memcached: fix a series of performance bottlenecks

Index lock, adding SX lock type to allow read load when the index is split

TRUNCATE operations guarantee atomicity through file logs

Index Rename and modification of varchar length can be done immediately.

Bottom-up index creation is more efficient

AHI partition

What's new:

Partition tables: push down to the engine layer to reduce memory allocation and lay the foundation for future concurrent query, foreign key and full-text index support; support IMPORT/EXPORT

General tablespace: supports multiple tables to be stored in one Ibd file

Buffer pool: can be online resize

Undo: supports truncate operation of undo files when opening independent undo tablespaces

Larger page size, starting to support 32k and 64k page

Spatial Index/GIS: support for more complete GIS features; InnoDB R-TREE implementation

Virtual Column: support for virtual columns and index creation on virtual columns

Data file encryption

Full-text indexing: a more Chinese-friendly word segmentation plug-in

Other: transparent page compression; Sandisk/FusionIO Atomic Writes; allows larger index prefix

Performance schema: monitor memory allocation; monitor DDL execution

The above are the performance optimizations and new features that MySQL5.7 has done in the InnoDB layer. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are 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.