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.

174
Articles
0
Likes
476
Views
0
Comments
Recent Articles

Latest from Architecture & Thinking

100 recent articles max
Architecture & Thinking
Architecture & Thinking
Apr 16, 2026 · Databases

Mastering Database Performance: From Slow Queries to Deadlock Resolution

This guide presents a systematic, end-to-end diagnostic workflow for high-concurrency database environments, covering slow-SQL detection, execution-plan analysis, lock-conflict monitoring, deadlock investigation, and practical optimization techniques, illustrated with real-world cases, commands, and tool integrations to swiftly resolve performance bottlenecks.

Database DiagnosticsLock MonitoringPerformance tuning
0 likes · 18 min read
Mastering Database Performance: From Slow Queries to Deadlock Resolution
Architecture & Thinking
Architecture & Thinking
Mar 20, 2026 · Backend Development

Why Redis’s Single‑Threaded Design Beats Multithreading in Real‑World Performance

This article explains how Redis achieves lightning‑fast performance with a single‑threaded architecture by leveraging in‑memory operations, IO multiplexing, and event‑driven design, and it details the four key advantages of this approach as well as the evolution introduced in Redis 6.0.

IO MultiplexingPerformanceRedis
0 likes · 12 min read
Why Redis’s Single‑Threaded Design Beats Multithreading in Real‑World Performance
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.

OptimizationPerformanceSQL
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.

Performance OptimizationSQLdeep pagination
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 agentsCloud ServicesOpen Source
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