MySQL 5 7 + JSON
summary
MySQL 5.7 adds a native JSON data type, about twenty server-side JSON functions and generated columns so JSON fragments become indexable. Validation happens on insert, storage is binary for fast reads, and a 200k‑document San Francisco parcel test runs a naive scan in 1.25s vs 12.85s when using JSON instead of TEXT and drops to 0.06s with an index on a generated column. Limitations include virtual columns lacking fulltext/GIS and full partial‑write support; type changes may rebuild tables.
AI-written summary · about
chapters (15)
- 0:00Introduction to MySQL 5.7
- 2:15Release and QA processes
- 4:31MySQL Labs and roadmap
- 5:34Performance and management
- 8:03Enterprise and community
- 8:48Native JSON data type
- 11:03Advantages of JSON type
- 12:52JSON functions
- 15:15JSON performance demo
- 20:31Generated columns
- 26:10Q&A on generated columns
- 32:37Advanced JSON functions
- 38:13JSON vs traditional data
- 43:34Future JSON roadmap
- 45:13Closing Q&A
related talks
44mAdventures in MySQL
40mMaking the most out of MySQL
39mMaking the most out of MySQL
24mGoing through era of IoT with MySQL 5.7
30mJSON support in MySQL
19mJSON Support: news, non-news, and the bigger picture
50mMySQL 8.0: SQL and NoSQL Scalability
29mHow De-normalizing Your Data with JSON Can Boost Query Performance