BestHub
Sign in
Tagged articles
6 articles
Page 1 of 1
IT Services Circle
IT Services Circle
May 12, 2026 · Databases

How to Diagnose and Resolve Online Slow SQL That Causes CPU Spikes

When a MySQL‑driven application shows sudden CPU spikes, this guide walks through a step‑by‑step process—using top/htop, SHOW PROCESSLIST, enabling slow‑query logs, analyzing EXPLAIN output, killing offending queries, adding appropriate indexes, rewriting joins, and establishing preventive monitoring—to quickly identify and fix the root cause.

CPU SpikePerformance tuningSQL optimization
0 likes · 12 min read
How to Diagnose and Resolve Online Slow SQL That Causes CPU Spikes
Xiao Liu Lab
Xiao Liu Lab
Feb 12, 2026 · Information Security

When fail2ban Became a Monero Miner: Detection, Removal, and Prevention

A temporary test server on Tianyi Cloud was compromised by a malicious XMRig miner masquerading as fail2ban, causing CPU usage to skyrocket; the article details how the intrusion was discovered, the forensic steps taken, and a comprehensive remediation and hardening guide to prevent similar attacks.

CPU SpikeFail2banIncident Response
0 likes · 9 min read
When fail2ban Became a Monero Miner: Detection, Removal, and Prevention
Java Backend Technology
Java Backend Technology
Oct 8, 2023 · Operations

How I Traced a Sudden CPU Spike to JVM GC Issues in a Container

After receiving an alarm that a production container’s CPU usage surged past 90%, I investigated the JVM metrics, discovered excessive young and full GCs in a single pod, and walked through the detailed troubleshooting steps—including top, thread analysis, jstack, and code fixes—that resolved the issue.

CPU SpikeJVMJava
0 likes · 7 min read
How I Traced a Sudden CPU Spike to JVM GC Issues in a Container