Tagged articles
Performance Troubleshooting
15 articles · Page 1 of 1
This guide explains how to use Windows Task Manager to diagnose system freezes, identify resource-hogging processes, end unresponsive programs, monitor CPU/memory/disk usage, manage startup items, and leverage advanced tabs like Details and Services, with practical tips and exam-focused insights.
Performance TroubleshootingProcess ManagementResource Monitor
0 likes · 8 min read

This guide provides a systematic approach to diagnosing Linux server slowdowns by distinguishing CPU, memory, disk, and network bottlenecks through evidence-based metric analysis, command-line tools, and practical examples covering load interpretation, PSI, I/O latency, and safe remediation practices.
CPULinuxMemory
0 likes · 31 min read

This article explains how frequent G1 Mixed GC pauses, not Redis slowness, cause distributed lock waits by stalling lock-holding threads, and details a six-step troubleshooting process linking GC logs, business logs, and heap analysis to identify large objects, compensation tasks, and unbounded local caches as root causes.
Distributed LocksG1 GCHumongous Objects
0 likes · 19 min read

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

Even with less than 30 QPS and normal DB CPU, a connection pool can run out in two hours because connections are held too long—often due to leaks, long‑running transactions, or async misuse—so the root cause must be traced back to the application code rather than just slow SQL.
Connection LeakHikariCPJDBC
0 likes · 9 min read

This article walks readers through each section of the top command output—system overview, process list, CPU, memory, and I/O metrics—explaining what the values mean, how to interpret warnings, and which interactive shortcuts and command-line options help quickly pinpoint performance bottlenecks.
CPULinuxMemory
0 likes · 7 min read

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

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 usageLinuxOperations
0 likes · 7 min read

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

This article details a step‑by‑step analysis of a server experiencing sustained high load, uncovering a stuck NFS mount and an overactive Zabbix monitoring job, and explains how targeted process termination and monitoring adjustments reduced the load from 85 to normal levels.
LinuxNFSPerformance Troubleshooting
0 likes · 6 min read

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

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.
BackendLoggingPerformance Troubleshooting
0 likes · 17 min read

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.
MySQLPerformance TroubleshootingSemi-sync Replication
0 likes · 20 min read

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

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 AverageOperationsPerformance Troubleshooting
0 likes · 8 min read
