Programmer XiaoFu
Author

Programmer XiaoFu

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

104
Articles
0
Likes
73
Views
0
Comments
Recent Articles

Latest from Programmer XiaoFu

100 recent articles max
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.

AsyncConcurrencyJava
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 securityREST API
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.

CPUJavaLinux
0 likes · 11 min read
Why Does MySQL CPU Spike to 900%? Diagnosis and Fixes
Programmer XiaoFu
Programmer XiaoFu
Nov 22, 2024 · Backend Development

15 Must-Know SpringBoot Startup Extension Points – Which Have You Used?

This article enumerates fifteen common SpringBoot startup extension points, explains their positions in the bean lifecycle, illustrates each with concrete code snippets and usage scenarios, and provides a visual call‑order diagram to help developers harness these hooks for custom initialization and middleware development.

BeanLifecycleExtensionPointsJava
0 likes · 18 min read
15 Must-Know SpringBoot Startup Extension Points – Which Have You Used?
Programmer XiaoFu
Programmer XiaoFu
Nov 19, 2024 · Backend Development

When Stream Makes Your Java Code Look Ugly: Pitfalls and Clean‑up Tips

The article examines how Java Stream and Lambda, while designed for concise and expressive code, often become sources of unreadable and hard‑to‑maintain implementations, and it offers concrete refactoring techniques, proper use of Optional, and cautions about ParallelStream performance.

Code styleLambdaOptional
0 likes · 8 min read
When Stream Makes Your Java Code Look Ugly: Pitfalls and Clean‑up Tips
Programmer XiaoFu
Programmer XiaoFu
Nov 16, 2024 · Backend Development

How Leading Companies Implement Distributed Caching – Lessons and Pitfalls

The article examines the benefits and hidden risks of using distributed caches, analyzes real‑world failure cases from Facebook, Google and AWS, and provides detailed strategies to mitigate availability and consistency problems through careful refresh policies, incremental updates, and compensation mechanisms.

availability riskcache consistencycache design
0 likes · 19 min read
How Leading Companies Implement Distributed Caching – Lessons and Pitfalls
Programmer XiaoFu
Programmer XiaoFu
Nov 14, 2024 · Backend Development

Designing Elegant API Controllers: Security, Idempotency, and Best Practices

This guide walks through building robust API controller interfaces by covering request signing, RSA encryption, IP whitelisting, rate limiting, parameter validation, unified response formats, exception handling, logging, idempotent design, request size limits, stress testing, asynchronous processing, data masking, and comprehensive documentation.

API designbackendidempotency
0 likes · 15 min read
Designing Elegant API Controllers: Security, Idempotency, and Best Practices
Programmer XiaoFu
Programmer XiaoFu
Nov 4, 2024 · Backend Development

How to Build an Unbeatable Weekly Hot‑Comment Ranking with Redis

The article shows how to avoid database pressure by recording daily comment counts in Redis sorted sets, merging the seven daily sets into a weekly ranking with a union command, and exposing the result through a Spring Boot service and a custom Freemarker tag, complete with code examples and screenshots.

FreemarkerSorted SetSpring Boot
0 likes · 17 min read
How to Build an Unbeatable Weekly Hot‑Comment Ranking with Redis
Programmer XiaoFu
Programmer XiaoFu
Oct 30, 2024 · Databases

How to Boost Pagination Queries for a Million Products by 10×

This article walks through nine practical techniques—default filters, smaller page sizes, fewer joins, index tuning, straight_join, data archiving, efficient count(*), ClickHouse offloading, and read/write splitting—to dramatically improve the performance of pagination APIs handling millions of product records.

ClickHouseMySQLPagination
0 likes · 11 min read
How to Boost Pagination Queries for a Million Products by 10×