MySQL Query Tuning Archives - Percona

Where the open source database community meets: Use code PERCONA75 and secure your spot for Percona Live. Register

Downloads

Blog

Contact Us

percona goat

Percona Blog - Tag - MySQL Query Tuning

Marcelo Altmann

Reducing High CPU on MySQL: a Case Study

October 3, 2018

Finding Table Differences on Nullable Columns Using MySQL Generated Columns

September 25, 2018

Why Optimization derived_merge can Break Your Queries

Webinar: How to Analyze and Tune MySQL Queries for Better Performance

EXPLAIN FORMAT=JSON wrap-up

February 29, 2016

EXPLAIN FORMAT=JSON: nested_loop makes JOIN hierarchy transparent

February 22, 2016

EXPLAIN FORMAT=JSON: cost_info knows why optimizer prefers one index to another

February 9, 2016

EXPLAIN FORMAT=JSON: buffer_result is not hidden!

January 29, 2016

EXPLAIN FORMAT=JSON knows everything about UNIONs: union_result and query_specifications

Far
Enough.

Said no pioneer ever.

Get Started

Open source database software from experts who stand with you in production. Forever free from lock-in and other corporate BS.

Connect

© 2026 Percona All Rights Reserved

|

|

|

|

Security Center

MySQL, PostgreSQL, InnoDB, MariaDB, MongoDB and Kubernetes are trademarks for their respective owners.

© 2026 Percona All Rights Reserved