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.

179
Articles
0
Likes
1.1k
Views
0
Comments
Recent Articles

Latest from Architecture & Thinking

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

10 Common MySQL Index Failure Scenarios and How to Fix Them

Even well‑designed indexes can become ineffective in production, leading to full‑table scans; this article systematically examines ten typical MySQL index‑failure cases—ranging from functions on indexed columns to low selectivity—and provides concrete SQL rewrites, performance comparisons, and diagnostic tools to help developers avoid and resolve these issues.

MySQLOptimizationSQL
0 likes · 17 min read
10 Common MySQL Index Failure Scenarios and How to Fix Them
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.

Deep PaginationMySQLSQL
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.

Class LoadingJava Memory ModelOOM
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 AgentsLocal AIOpenClaw
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 computeAI modelsChinese 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.

ACIDInnoDBMySQL
0 likes · 10 min read
Why Transactions Matter: Mastering MySQL ACID and Isolation Levels
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.

Redisatomic-operationsbackend optimization
0 likes · 8 min read
Master Flash Sale Systems: Backend Strategies for Millions of Requests
Architecture & Thinking
Architecture & Thinking
Nov 18, 2025 · Fundamentals

Master the Five Core SOLID Architecture Principles: SRP, OCP, LSP, ISP, DIP

This article explains the five essential software architecture principles—Single Responsibility, Open‑Closed, Liskov Substitution, Interface Segregation, and Dependency Inversion—detailing their definitions, real‑world e‑commerce examples, and why they are crucial for building maintainable, scalable systems.

DIPISPLSP
0 likes · 7 min read
Master the Five Core SOLID Architecture Principles: SRP, OCP, LSP, ISP, DIP