Tagged articles

slow log

3 articles · Page 1 of 1

May 8, 2026 · Databases

Slow Queries Causing Outages? Build a Cloud‑Native Distributed MySQL Slow‑Log Platform from Scratch

This article walks through the design and implementation of a production‑grade, cloud‑native MySQL slow‑log collection and analysis platform, covering everything from MySQL slow‑log fundamentals and multi‑node ingestion to Kafka buffering, Go‑based parsing, SQL fingerprinting, Elasticsearch and ClickHouse storage, alerting, APM integration, and a phased rollout roadmap.

Cloud NativeKafkaKubernetes

0 likes · 35 min read

Slow Queries Causing Outages? Build a Cloud‑Native Distributed MySQL Slow‑Log Platform from Scratch

Aikesheng Open Source Community

Sep 20, 2022 · Databases

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/OMySQL

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.

DatabaseMongoDBindex optimization

0 likes · 36 min read

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