Analyzing MySQL Slow Log: Identifying Disk I/O and Semi‑Sync Replication Bottlenecks

This article walks through a systematic analysis of MySQL slow‑log entries, correlating them with error‑log flush events, disk‑I/O monitoring, and semi‑synchronous replication traces to pinpoint performance bottlenecks and provide practical troubleshooting steps.

Database MonitoringDisk I/OSemi-sync replication

0 likes · 20 min read

Analyzing MySQL Slow Log: Identifying Disk I/O and Semi‑Sync Replication Bottlenecks

NetEase Game Operations Platform

Aug 24, 2019 · Databases

MongoDB Index Optimization for High‑Write CMDB Workloads and Slow‑Log Reduction

This article analyzes the performance bottlenecks of a MongoDB‑based CMDB under high write concurrency, explains index structures and storage, demonstrates how to identify and eliminate full‑table scans and redundant multikey indexes, and shows the resulting reduction in slow‑log volume and CPU usage.

Index OptimizationMongoDBdatabase

0 likes · 36 min read

MongoDB Index Optimization for High‑Write CMDB Workloads and Slow‑Log Reduction