Nov 11, 2025 · Databases

How to Tame MySQL CPU Spikes: A Complete 4‑Step Emergency Guide

When MySQL CPU usage spikes to 500%, this guide walks you through a four‑step emergency process—quickly stopping the overload, diagnosing the root cause, applying targeted SQL and configuration optimizations, and setting up monitoring to prevent future spikes—ensuring service stability and performance.

CPU optimizationDatabase MonitoringSlow query analysis

0 likes · 8 min read

How to Tame MySQL CPU Spikes: A Complete 4‑Step Emergency Guide

Java Backend Technology

Apr 5, 2020 · Databases

How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion

This article walks through diagnosing severe SLA alerts caused by slow queries on a huge MySQL table, using pt‑query‑digest and tcpdump to uncover index misuse, then proposes new composite and single‑column indexes, demonstrates online DDL versus pt‑osc, and shows how batch deletions and efficient backup/restore dramatically reduce execution time and replication lag.

Batch DeleteOnline DDLSlow query analysis

0 likes · 16 min read

How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion