Professional architect sharing high‑quality architecture insights. Topics include high‑availability, high‑performance, high‑stability architectures, big data, machine learning, Java, system and distributed architecture, AI, and practical large‑scale architecture case studies. Open to ideas‑driven architects who enjoy sharing and learning.
This article measures the heap memory allocated by a single SpringBoot HTTP and RPC request using JMeter load testing and detailed GC logs, revealing that even tiny payloads can consume around 34 KB of heap, and discusses how request size, logging, and JVM settings affect memory usage and GC frequency.
This guide explains a comprehensive API encryption scheme that combines symmetric and asymmetric cryptography, HTTPS principles, and WeChat Pay encryption to protect against crawlers, tampering, replay attacks, and ensure data integrity, complete with design rationale, implementation steps, code examples, and security analysis.
This article explains the technical principles behind QR code login, detailing how a token‑based authentication system identifies the user, the step‑by‑step flow from QR code generation on a PC to mobile scanning, confirmation, and final token issuance for secure access.
The article explains why using IN and NOT IN in SQL queries can lead to poor performance and incorrect results, especially with large tables or NULL values, and demonstrates how replacing them with EXISTS, NOT EXISTS, or appropriate JOINs yields faster, reliable outcomes.
This article explains why deep pagination hurts performance in large datasets, demonstrates the inefficiency of offset‑based SQL queries, and presents practical alternatives such as cursor pagination, sub‑query optimizations, delayed joins, caching, business limits, and the Elasticsearch Search After technique for stable, scalable paging.
This article explains the purpose of MySQL’s optimizer_switch ‘prefer_ordering_index’, shows how it affects ORDER BY/GROUP BY queries with LIMIT, provides sample tables and procedures, compares EXPLAIN output with the option ON and OFF, and concludes why disabling it is often the safer choice for most workloads.
On the night of November 18 2025, Cloudflare suffered a three‑hour core failure that crippled roughly half of the internet, and this article details the timeline, global impact, root cause in a ClickHouse permission change, and the remediation steps taken to restore service.
This article compares four pagination techniques—basic LIMIT‑OFFSET, primary‑key based filtering, has‑more scrolling, and Elasticsearch pagination—explaining their implementations, advantages, drawbacks, and when each should be chosen for efficient data retrieval.
A Java backend project upgraded from MyBatis 3.5.0 to MyBatis‑Plus 3.1.1 encountered a LocalDateTime conversion exception caused by an outdated MySQL connector, and the article walks through version diagnostics, connector upgrades, and additional validation bugs that surfaced during production.
This article examines the design of LLM‑native AI application platforms Tasking AI and Dify, comparing their LLM integration, plugin management, multi‑tenant isolation, system architecture, and especially Dify’s GraphEngine for complex AI workflow orchestration.
