Practical DevOps Architecture
Jan 4, 2021 · Databases
New MySQL 8 Features: Invisible Indexes, Persistent Settings, UTF8MB4, CTEs, and Window Functions
This article introduces several MySQL 8 enhancements—including invisible indexes for performance testing, the SET PERSIST command for durable configuration changes, default UTF8MB4 encoding, Common Table Expressions for clearer queries, and window functions for ranking and aggregation—illustrated with practical SQL examples.
IndexesMySQLPersistent Settings
0 likes · 6 min read