MySQL 8.0 to 8.4: New Features and Migration Guide
Explore MySQL 8.0 and 8.4 LTS features: window functions, CTE, JSON enhancements, roles, instant ADD COLUMN, and migration from MySQL 5.7.
Quick Navigation
Mysql — Topic Index
Topic index generated on 2026-08-03 — grouped article list
Mysql — Topic Index
Below is an index of articles grouped by topic. Click a heading to jump to the section.
Database
- MySQL 8.0 to 8.4: New Features and Migration Guide
- MySQL for AI Applications: Vector Storage, JSON, and ML Integration
- MySQL Internals: InnoDB, Storage Engine, and Query Processing
- MySQL Operations: Backup, Replication, and High Availability
- MySQL: The Complete Guide to the World’s Most Popular Open Source Database
Uncategorized
- MySQL Index Types: A Complete Guide to Indexing Strategy
- placeholder
- SQL Fundamentals: Queries, Schema Design, Relationships & Normalization
If you find missing articles or inaccurate groupings, run ./scripts/update_index.py with appropriate flags.
MySQL for AI Applications: Vector Storage, JSON, and ML Integration
Comprehensive guide to using MySQL for AI workloads including vector embeddings, JSON document storage, ML model management, and production AI pipelines.
MySQL Internals: InnoDB, Storage Engine, and Query Processing
Deep dive into MySQL architecture. Understand InnoDB storage engine, buffer pool, MVCC, query execution, and transaction management internals.
MySQL Operations: Backup, Replication, and High Availability
Learn MySQL administration: backup strategies, point-in-time recovery, replication, MySQL InnoDB Cluster, ProxySQL, and production monitoring.
MySQL: The Complete Guide to the World's Most Popular Open Source Database
Master MySQL from installation to advanced queries. Learn data types, constraints, indexes, and SQL operations with practical examples.
placeholder
Compare ORMs and query builders across languages: SQLAlchemy, Prisma, TypeORM, Eloquent, and Django ORM.
SQL Fundamentals: Queries, Schema Design, Relationships & Normalization
Master SQL fundamentals: SELECT, JOINs, subqueries, window functions, and query optimization for relational databases.
MySQL Index Types: A Complete Guide to Indexing Strategy
A complete guide to MySQL index types — B-tree, full-text, spatial, hash, composite — with creation syntax, use cases, and optimization strategies.