BestHub
Sign in
Engineer Tang's Implementation Study Notes
Author

Engineer Tang's Implementation Study Notes

Old Tang | Pseudo-full-stack tech player: writes code without going bald, manages projects without going crazy, delivers without staying up late. No formal tutorials here, only a "slacking-off" practical manual that cures system pain points. Focuses on Shell, SQL, Java, and delivery, turning complexity into simplicity and making efficiency fun.

68
Articles
0
Likes
90
Views
0
Comments
Recent Articles

Latest from Engineer Tang's Implementation Study Notes

68 recent articles
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Aug 18, 2026 · Cloud Native

Troubleshoot Pod Frequent Restarts in 60 Seconds: OOMKilled vs Misconfigured Health Checks

A practical guide to diagnose Kubernetes pod frequent restarts by distinguishing OOMKilled from liveness probe failures, using kubectl describe, logs, and events, then fixing via memory limit adjustments or probe parameter tuning (initialDelaySeconds, periodSeconds, timeoutSeconds, failureThreshold), while avoiding common pitfalls like confusing liveness/readiness probes or depending on external dependencies for health checks.

KubernetesLiveness ProbeMemory Limits
0 likes · 8 min read
Troubleshoot Pod Frequent Restarts in 60 Seconds: OOMKilled vs Misconfigured Health Checks
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Aug 11, 2026 · Databases

MySQL Large Table Optimization: 5 Strategies for 100M+ Row Queries

This article presents a five-step practical guide for optimizing MySQL queries on tables exceeding 100 million rows, covering index optimization, SQL rewriting, cursor-based pagination, table structure improvements including partitioning, and architectural upgrades like read-write separation and sharding, with concrete code examples and performance comparisons.

Index OptimizationLarge TablesMySQL
0 likes · 12 min read
MySQL Large Table Optimization: 5 Strategies for 100M+ Row Queries
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Aug 6, 2026 · Backend Development

Connection Pool Exhausted? It's Likely Leaked Connections, Not Database Limits

This guide diagnoses database connection pool exhaustion by distinguishing connection leaks from genuine high concurrency, demonstrating log analysis for HikariCP and Druid, verifying leaks via SHOW PROCESSLIST and pool metrics, fixing code with try-with-resources, tuning key HikariCP parameters, and enabling leak detection to pinpoint exact leak locations.

DruidHikariCPbackend development
0 likes · 10 min read
Connection Pool Exhausted? It's Likely Leaked Connections, Not Database Limits
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Jul 30, 2026 · Databases

MySQL Index Ignored? Implicit Type Conversion Causes Full Table Scan

A MySQL query on a varchar column with an unquoted numeric literal triggered implicit type conversion, forcing a full scan of 2 million rows instead of an index lookup; adding quotes cut latency from 19 seconds to 50 ms. The article explains the mechanism, lists four other common index-invalidation patterns, and provides a quick EXPLAIN-based diagnosis checklist.

EXPLAINIndex OptimizationMySQL
0 likes · 7 min read
MySQL Index Ignored? Implicit Type Conversion Causes Full Table Scan
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Jul 21, 2026 · Operations

Disk Full but du Shows Less? Hidden Deleted Files Held Open by Processes

When df reports 98% disk usage but du accounts for only 50%, the missing space is typically held by a process that deleted a file but kept its file descriptor open; this article demonstrates how to locate the offending process with lsof, reclaim space instantly via /proc/pid/fd, and prevent recurrence by truncating logs instead of removing them.

disk troubleshootingfile descriptorslinux
0 likes · 6 min read
Disk Full but du Shows Less? Hidden Deleted Files Held Open by Processes
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Jul 17, 2026 · Operations

Fix 'Cannot Assign Requested Address': Two Kernel Tweaks to Recycle TIME_WAIT Fast

The article explains that 'Cannot assign requested address' errors under high concurrency stem from slow TIME_WAIT recycling, not port exhaustion, and shows how enabling tcp_tw_reuse and tcp_timestamps instantly solves it without a restart, while warning against the deprecated tcp_tw_recycle.

High ConcurrencyLinux kernelTCP tuning
0 likes · 5 min read
Fix 'Cannot Assign Requested Address': Two Kernel Tweaks to Recycle TIME_WAIT Fast