Unlock MySQL 8.0: 8 Hidden Optimization Tricks You Must Know

This article reveals eight powerful, lesser‑known MySQL 8.0 features—including window functions, descending indexes, generated columns, invisible indexes, optimizer hints, resource groups, LATERAL JOIN, and multi‑valued JSON indexes—showing how they dramatically improve query performance and simplify complex SQL tasks.

Invisible IndexLATERAL JOINResource Group

0 likes · 12 min read

Unlock MySQL 8.0: 8 Hidden Optimization Tricks You Must Know

Tencent Database Technology

Aug 2, 2021 · Databases

MySQL 8.0 Resource Groups: Overview and Implementation

This article introduces MySQL 8.0's resource group feature, detailing its concepts, configuration commands, query hint usage, and the underlying implementation including new parser classes, platform APIs, runtime components, performance schema integration, and persistence mechanisms, with code examples throughout.

ParserPerformance SchemaResource Group

0 likes · 17 min read

MySQL 8.0 Resource Groups: Overview and Implementation

Aikesheng Open Source Community

Jul 19, 2019 · Databases

Using MySQL 8.0 Resource Groups to Isolate Long‑Running Queries

The article explains how MySQL 8.0 resource groups can be used to confine CPU‑intensive queries such as ORDER BY RAND() to specific CPU cores, preventing them from monopolizing server resources, and provides step‑by‑step commands, script alternatives, and known limitations.

CPU LimitingDatabase AdministrationResource Group

0 likes · 5 min read

Using MySQL 8.0 Resource Groups to Isolate Long‑Running Queries