Going through era of IoT with MySQL 5.7
summary
MySQL 5.7 adds native JSON with indexing so JSON queries become indexable and much faster than TEXT storage, and the optimizer moves to a cost-based planner with generated columns and a query rewrite plugin for on‑the‑fly SQL fixes. Benchmarks show up to 1.6 million QPS and ~100,000 connects/sec on large NUMA servers. InnoDB gains include online buffer pool resizing, native partitioning, separate undo tablespaces and faster bulk index load. Replication gets GTID online, multi‑source replication, a labs group‑replication cluster, MySQL Router and parallel mysqldump replacement (mysqlpump).
AI-written summary · about
chapters (18)
- 0:00Intro
- 1:25What is MySQL 57
- 2:29MySQL 57 work
- 3:12MySQL 57 performance
- 5:47Improve Optimizer
- 7:42Query Rewrite
- 9:21JSON Support
- 9:45Query Time
- 10:27SIS Schema
- 11:46GIS
- 13:49Online Processing
- 15:28Index Creation
- 15:44Replication
- 18:30GTID
- 18:50Multisource replication
- 21:02Group replication
- 22:22MySQL Router
- 23:40MySQL Repository
