BestHub
Sign in
Tagged articles

Performance Troubleshooting

12 articles · Page 1 of 1
LuTiao Programming
LuTiao Programming
Sep 11, 2026 · Backend Development

API Latency Spike to 8s: Not Slow SQL, But Long Transactions Holding DB Connections

An API's sudden latency spike from 200ms to 8 seconds was traced not to slow SQL but to database connection pool exhaustion caused by @Transactional methods holding connections during external HTTP calls to a payment service; splitting transactions and moving external calls outside the transaction boundary resolved the issue.

Database Connection PoolHikariCPPerformance Troubleshooting
0 likes · 15 min read
API Latency Spike to 8s: Not Slow SQL, But Long Transactions Holding DB Connections
Cloud Architecture
Cloud Architecture
Apr 16, 2026 · Databases

EXPLAIN ANALYZE: The CT Scan That Triggers a Query Performance Revolution

When a core order‑query suddenly slowed from milliseconds to seconds, the team discovered that using PostgreSQL’s EXPLAIN ANALYZE revealed hidden plan regressions, outdated statistics, and index misuse, leading to a systematic, production‑grade methodology for diagnosing and fixing query performance issues.

EXPLAIN ANALYZEPerformance TroubleshootingPostgreSQL
0 likes · 32 min read
EXPLAIN ANALYZE: The CT Scan That Triggers a Query Performance Revolution
Open Source Linux
Open Source Linux
Nov 3, 2025 · Operations

Master Linux ‘top’: Decode System Metrics and Boost Performance

This guide walks you through every line of the Linux top command output, explaining system summaries, CPU and memory metrics, process details, and advanced shortcuts, so you can quickly diagnose performance bottlenecks and become proficient at real‑time system troubleshooting.

CPU usageLinuxPerformance Troubleshooting
0 likes · 7 min read
Master Linux ‘top’: Decode System Metrics and Boost Performance
DataFunTalk
DataFunTalk
Oct 6, 2025 · Big Data

How Bilibili Tackles Massive Big‑Data Task Failures with AI Assistants

This article explains Bilibili's large‑scale big‑data platform architecture, the huge volume of offline and real‑time tasks it handles, common failure and slowdown causes, and why the company is exploring AI‑driven assistants to help engineers troubleshoot these issues efficiently.

AI assistantBilibiliPerformance Troubleshooting
0 likes · 5 min read
How Bilibili Tackles Massive Big‑Data Task Failures with AI Assistants
Tencent Cloud Developer
Tencent Cloud Developer
Nov 9, 2023 · Backend Development

Troubleshooting Golang GC Performance Issues Causing Request Timeout Spikes

The article details how a Go service’s default GOGC setting caused overly frequent garbage‑collection pauses that spiked request timeouts, and how adjusting GOGC dynamically with debug.SetGCPercent and setting memory limits reduced GC CPU usage, extended pause intervals, and eliminated timeout spikes.

GC optimizationGOGCGo Memory Management
0 likes · 20 min read
Troubleshooting Golang GC Performance Issues Causing Request Timeout Spikes
vivo Internet Technology
vivo Internet Technology
Apr 19, 2023 · Backend Development

Investigation of Midnight Interface Timeout in Vivo E‑commerce Activity System

The article details how a midnight interface timeout in Vivo’s e‑commerce activity system was traced to a logging bottleneck: a synchronous Log4j call blocked all threads while a cron‑driven log‑rotation script copied a 2.6 GB file, and the issue was resolved by switching to asynchronous logging with a non‑blocking appender.

BackendPerformance TroubleshootingTomcat
0 likes · 17 min read
Investigation of Midnight Interface Timeout in Vivo E‑commerce Activity System
Aikesheng Open Source Community
Aikesheng Open Source Community
May 25, 2022 · Operations

Diagnosing High CPU Load Caused by Frequent Short‑Lived Processes in a MongoDB Environment Using execsnoop

The article describes how a MongoDB test environment on a single VM experienced persistent high CPU load despite low visible QPS, how the root cause was traced to thousands of short‑lived processes spawned by Zabbix monitoring, and how execsnoop was used to identify and eliminate the offending processes.

CPU loadLinux monitoringMongoDB
0 likes · 6 min read
Diagnosing High CPU Load Caused by Frequent Short‑Lived Processes in a MongoDB Environment Using execsnoop
Efficient Ops
Efficient Ops
Jan 18, 2018 · Operations

Understanding Linux Load Average: Reading, Interpreting, and Using It for Troubleshooting

This article explains what Linux load average measures, how to view the 1‑, 5‑, and 15‑minute values, interprets the numbers using traffic analogies, presents stress‑test scenarios across different CPU cores, and shows how load average guides effective troubleshooting of CPU and I/O bottlenecks.

Load AveragePerformance Troubleshootingoperations
0 likes · 8 min read
Understanding Linux Load Average: Reading, Interpreting, and Using It for Troubleshooting