Programmer XiaoFu
Author

Programmer XiaoFu

xiaofucode.com – a programmer learning guide driven by the pursuit of profit

111
Articles
0
Likes
419
Views
0
Comments
Recent Articles

Latest from Programmer XiaoFu

100 recent articles max
Programmer XiaoFu
Programmer XiaoFu
Mar 5, 2025 · Databases

From 12 s to 200 ms: 6 MySQL Deep‑Pagination Tricks for 20 M Orders

When a MySQL order table with 20 million rows is paginated using a large OFFSET, query latency can explode from seconds to minutes, but applying six concrete techniques—cursor pagination, deferred join, covering index, table partitioning, precomputed pages, and Elasticsearch integration—can shrink response time to a few hundred milliseconds.

Covering IndexElasticsearchMySQL
0 likes · 9 min read
From 12 s to 200 ms: 6 MySQL Deep‑Pagination Tricks for 20 M Orders
Programmer XiaoFu
Programmer XiaoFu
Feb 12, 2025 · Industry Insights

DeepSeek’s Hype Triggers Programmer Layoffs

The rapid rise of DeepSeek’s code‑generation AI has led to significant layoffs among programmers, prompting a shift in career strategy toward embracing AI tools, focusing on non‑automatable skills, and continuous learning to stay relevant in the evolving software industry.

AI automationDeepSeekcareer advice
0 likes · 4 min read
DeepSeek’s Hype Triggers Programmer Layoffs
Programmer XiaoFu
Programmer XiaoFu
Feb 5, 2025 · Backend Development

Elegant Ways to Capture Exceptions from Java ThreadPool Tasks

This article explains why tasks submitted with ExecutorService.submit hide exceptions while execute prints them, demonstrates how Future.get() can retrieve hidden errors, and presents three practical solutions—inline try‑catch, a custom ThreadFactory with UncaughtExceptionHandler, and overriding afterExecute—to reliably handle thread‑pool exceptions in Java.

ExceptionHandlingExecutorServiceFuture
0 likes · 15 min read
Elegant Ways to Capture Exceptions from Java ThreadPool Tasks
Programmer XiaoFu
Programmer XiaoFu
Dec 26, 2024 · Backend Development

Avoid Misusing Spring Event: 6 Hard‑Earned Best Practices from a Real‑World Failure

The article recounts a production incident caused by improper use of Spring Event, explains why graceful shutdown, correct startup timing, suitable business scenarios, and reliability measures such as retries and idempotency are essential, and presents six concrete best‑practice recommendations to prevent similar failures.

Graceful ShutdownIdempotencyKafka
0 likes · 11 min read
Avoid Misusing Spring Event: 6 Hard‑Earned Best Practices from a Real‑World Failure
Programmer XiaoFu
Programmer XiaoFu
Dec 18, 2024 · Industry Insights

ByteDance and Kuaishou Launch Anti‑Jargon Campaign: From WC Posters to Clear Communication

ByteDance and Kuaishou have launched an “anti‑jargon” campaign, posting restroom cartoons that urge employees to abandon buzzwords like “赋能” and “抓手,” arguing that such jargon hampers clear communication, reduces efficiency, and fuels overtime, while also serving as a status symbol within the tech industry.

ByteDanceKuaishoucommunication
0 likes · 5 min read
ByteDance and Kuaishou Launch Anti‑Jargon Campaign: From WC Posters to Clear Communication
Programmer XiaoFu
Programmer XiaoFu
Dec 12, 2024 · Backend Development

4 Elegant Ways to Transfer Data Between Async Threads in Spring Boot

The article compares four techniques—manual ThreadLocal copying, TaskDecorator, InheritableThreadLocal, and Alibaba's TransmittableThreadLocal—for passing user context and other data from parent to child threads in Spring Boot async execution, recommending the TaskDecorator and TransmittableThreadLocal approaches for production use.

@AsyncJavaSpring Boot
0 likes · 13 min read
4 Elegant Ways to Transfer Data Between Async Threads in Spring Boot
Programmer XiaoFu
Programmer XiaoFu
Dec 4, 2024 · Information Security

Designing Elegant and Secure Third‑Party APIs: Key Practices and Pitfalls

The article presents a comprehensive design for third‑party APIs that protects against data tampering, replay attacks, and unauthorized access by using AK/SK key pairs, timestamp and nonce signatures, TLS encryption, fine‑grained permission models, rate limiting, idempotency handling, versioning, standardized response formats, and detailed implementation examples in Java.

AK/SKAPI SecurityTIMESTAMP
0 likes · 32 min read
Designing Elegant and Secure Third‑Party APIs: Key Practices and Pitfalls
Programmer XiaoFu
Programmer XiaoFu
Nov 27, 2024 · Databases

Why Does MySQL CPU Spike to 900%? Diagnosis and Fixes

The article explains how to troubleshoot extreme CPU usage in MySQL and Java processes, detailing step‑by‑step diagnostics with top, show processlist, jstack, and practical fixes such as adding missing indexes, disabling slow logs, using caches, and correcting busy‑loop code to bring CPU consumption back to normal levels.

CPUIndexingJava
0 likes · 11 min read
Why Does MySQL CPU Spike to 900%? Diagnosis and Fixes