Skip to content
Tagged articles

MySQL 5.7

6 articles · Page 1 of 1
Raymond Ops
Raymond Ops
Oct 13, 2026 · Databases

MySQL 8.0 Upgrade Guide: 20 Critical Migration Pitfalls from 5.7

This comprehensive guide details 20 critical technical checks for migrating from MySQL 5.7 to 8.0, covering authentication plugins, character sets, reserved words, strict SQL modes, replication setup, backup validation, and cutover procedures with executable SQL and bash examples.

AuthenticationDatabase MigrationDatabase Upgrade
0 likes · 23 min read
MySQL 8.0 Upgrade Guide: 20 Critical Migration Pitfalls from 5.7
dbaplus Community
dbaplus Community
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.

InnoDBJSONMySQL 5.7
0 likes · 12 min read
What’s New in MySQL 5.7? InnoDB, JSON, and Feature Highlights
Qunar Tech Salon
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.

Buffer PoolCompressionIO Subsystem
0 likes · 25 min read
InnoDB Storage Formats, System Pages, IO Subsystem, and Buffer Pool Management in MySQL 5.7