BestHub
Sign in
Architecture & Thinking
Author

Architecture & Thinking

🍭 Frontline tech director and chief architect at top-tier companies 🥝 Years of deep experience in internet, e‑commerce, social, and finance sectors 🌾 Committed to publishing high‑quality articles covering core technologies of leading internet firms, application architecture, and AI breakthroughs.

168
Articles
0
Likes
397
Views
0
Comments
Recent Articles

Latest from Architecture & Thinking

100 recent articles max
Architecture & Thinking
Architecture & Thinking
Mar 13, 2026 · Databases

Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It

The article explains how deep pagination on massive MySQL tables causes full‑table scans, massive I/O, and memory pressure, then presents six concrete optimization techniques—including delayed join, cursor pagination, covering indexes, ID‑range pagination, caching, and partitioning—backed by a real‑world e‑commerce case study and detailed execution‑plan analysis.

MySQLPerformance optimizationSQL
0 likes · 18 min read
Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It
Architecture & Thinking
Architecture & Thinking
Mar 11, 2026 · Fundamentals

Unlocking the JVM: From Bytecode to Memory Model and Performance Tuning

This article explains how Java source files are compiled into bytecode, details the JVM's class loading lifecycle, describes the hierarchical class loader delegation model, and breaks down the runtime data areas—including stack, heap, and metaspace—while offering practical tuning tips to avoid common OOM issues.

Java memory modelOOMclass loading
0 likes · 13 min read
Unlocking the JVM: From Bytecode to Memory Model and Performance Tuning
Architecture & Thinking
Architecture & Thinking
Mar 9, 2026 · Artificial Intelligence

Why Thousands Queued to Install OpenClaw: Inside the Rise of Local AI Agents

The article examines the massive public queue for free OpenClaw installations at Tencent’s campus, explains the tool’s local‑run AI agent architecture, analyzes market forces driving its rapid adoption, and critically assesses the technical, security, and business challenges that temper its long‑term prospects.

AI agentsOpenClawcloud services
0 likes · 8 min read
Why Thousands Queued to Install OpenClaw: Inside the Rise of Local AI Agents
Architecture & Thinking
Architecture & Thinking
Mar 1, 2026 · Artificial Intelligence

Why DeepSeek V4 Prioritizes Chinese Chips Over Nvidia – A Game‑Changer for AI Compute

DeepSeek’s upcoming V4 model breaks industry norms by prioritizing Huawei’s Ascend chips over Nvidia GPUs, offering over 30% performance gains, ultra‑long context windows, native multimodal abilities, and dramatically lower inference costs, signaling a shift toward autonomous AI compute in China.

AI ModelsAI computeChinese chips
0 likes · 6 min read
Why DeepSeek V4 Prioritizes Chinese Chips Over Nvidia – A Game‑Changer for AI Compute
Architecture & Thinking
Architecture & Thinking
Jan 19, 2026 · Databases

Why Transactions Matter: Mastering MySQL ACID and Isolation Levels

This article explains MySQL transaction fundamentals, illustrates a banking transfer scenario, details the ACID properties, explores dirty reads, non‑repeatable reads and phantom reads, and compares the four SQL‑92 isolation levels with practical code examples and InnoDB behavior.

ACIDInnoDBIsolation Levels
0 likes · 10 min read
Why Transactions Matter: Mastering MySQL ACID and Isolation Levels
Architecture & Thinking
Architecture & Thinking
Dec 16, 2025 · Backend Development

Designing a 100k RPS Like/Read Counter with Redis and MySQL

This article explains how to build a high‑throughput like and read counter that can handle 100,000 requests per second by layering Redis caching, optional AOF or MySQL persistence, cleaning invalid client requests, and separating business, statistics, and reporting logic.

CounterMySQL
0 likes · 5 min read
Designing a 100k RPS Like/Read Counter with Redis and MySQL
Architecture & Thinking
Architecture & Thinking
Dec 8, 2025 · Backend Development

Master Flash Sale Systems: Backend Strategies for Millions of Requests

This article explains the unique challenges of flash‑sale systems—massive, short‑lived traffic spikes—and presents practical backend optimizations such as front‑end request filtering, Redis‑based atomic counters, streaming queues, safe database updates, and unit‑level isolation for global deployments.

Flash SaleHigh ConcurrencyRedis
0 likes · 8 min read
Master Flash Sale Systems: Backend Strategies for Millions of Requests
Architecture & Thinking
Architecture & Thinking
Sep 17, 2025 · Artificial Intelligence

How the 32B ‘Zhiyu’ Model is Revolutionizing Intelligent Operations

The Zhiyu model, a 32‑billion‑parameter SRE‑focused LLM, combines extensive domain knowledge, enhanced professional skills, and deterministic RAG to deliver precise, actionable insights for intelligent operations, backed by a robust multi‑source training pipeline, staged training, and flexible deployment options.

AI OperationsRAGSRE
0 likes · 7 min read
How the 32B ‘Zhiyu’ Model is Revolutionizing Intelligent Operations