Sep 12, 2016 · Databases

What’s New in MySQL 5.7? InnoDB, JSON, and Feature Highlights

This article walks through the major MySQL 5.7 enhancements—including InnoDB buffer‑dump improvements, multi‑threaded page cleaning, dynamic buffer‑pool resizing, global tablespaces, default DYNAMIC row format, native partitioning, truncate‑undo logs, native JSON support, sys schema, optimizer hints, trigger upgrades, syslog integration, and virtual columns—providing practical steps, examples, and usage tips for DBAs.

Database FeaturesInnoDBJSON

0 likes · 12 min read

What’s New in MySQL 5.7? InnoDB, JSON, and Feature Highlights

Qunar Tech Salon

Mar 11, 2016 · Databases

InnoDB Storage Formats, System Pages, IO Subsystem, and Buffer Pool Management in MySQL 5.7

This article explains MySQL 5.7 InnoDB's traditional compressed storage format, system page structures, external storage pages, encrypted and R‑TREE pages, the IO subsystem including asynchronous AIO handling and read‑ahead strategies, as well as buffer pool initialization, management, and concurrency control.

IO SubsystemInnoDBMySQL 5.7

0 likes · 25 min read

InnoDB Storage Formats, System Pages, IO Subsystem, and Buffer Pool Management in MySQL 5.7