Explaining distributed systems and architecture through stories. Author of the "JVM Performance Tuning in Practice" column, open-source author of "Spring Cloud in Practice PassJava", and independently developed a PMP practice quiz mini-program.
This article walks through a concrete MySQL InnoDB deadlock scenario caused by Gap Locks, showing the exact SQL statements, lock states at each step, log excerpts, and practical tips to avoid similar deadlocks in repeatable‑read transactions.
This article explains InnoDB's lock mechanisms—including table, intention, row, GAP, next‑key, and auto‑increment locks—shows how to inspect them via performance_schema tables, demonstrates lock behavior under different isolation levels with concrete SQL examples, and clarifies lock compatibility rules.
TiDB’s engineering team created Loop, a team‑oriented workspace that lets multiple AI agents cooperate like colleagues, addressing coordination problems such as broken context, manual state sync, overlapping work, and long‑task stability, and now offers a beta for early adopters.
The author compares four cumbersome blog‑deployment methods—Jenkins, manual CLI, unstable MCP service, and direct SSH—and then details a reliable GitHub Actions workflow that builds the site, caches npm, and deploys it to an Ubuntu server via SSH and rsync.
The article walks through diagnosing a slow MySQL 8.0 query that scans 77,724 rows and performs a costly filesort, then rewrites it with a LATERAL join and a new index, reducing execution time to about 0.75 seconds on 30 k rows while explaining the differences between ordinary subqueries and LATERAL, and highlighting the need for deterministic ordering when timestamps duplicate.
During a high‑traffic migration where QPS peaked over 10,000, the team used DBDoctor to perform full‑stack database monitoring, pinpoint long‑running transactions and slow SQL, apply index recommendations, and achieve cost reductions of up to 246 000 times, demonstrating rapid, data‑driven performance optimization.
The article dissects the fundamental design philosophies of Hermes Agent and OpenClaw, explains how Hermes achieves autonomous skill creation and memory management, and presents a detailed side‑by‑side comparison of their ability sources, learning loops, context efficiency, core value and security considerations.
This guide shows how to create a smart water‑drinking tracker that sends hourly reminders via a WeChat bot, stores daily intake, generates reports, and can be customized or deployed to GitHub, using OpenClaw’s cron and scripting features.
GStack, an open‑source AI‑driven virtual software factory created by Y Combinator CEO Garry Tan, transforms Claude Code into a role‑based development team, offering 30+ slash commands that automate the entire product lifecycle—from requirement gathering to release—enabling a single developer to achieve the productivity of a twenty‑person team.
This step‑by‑step guide shows how to configure Claude Code to use DeepSeek’s Anthropic‑compatible API, replace the default model, optimize costs with mixed model strategies, secure your API key, and troubleshoot common connection issues, enabling a seamless, cost‑effective AI development workflow.
