Dedicated to sharing programmer-architect skills—Java backend, system, microservice, and distributed architectures—to help you become a senior architect.
The article experimentally compares MySQL JOIN and IN queries across small, medium, and large data sets, showing that JOIN is generally faster for modest volumes while IN can become impractically long and error‑prone with massive lists, leaving neither approach ideal for all scenarios.
This article analyzes the constraints of loading a billion 1‑KB log records from HDFS/S3 into MySQL, evaluates single‑table limits, proposes batch inserts, sharding, file‑reading techniques, task coordination with Redis, Redisson, and Zookeeper, and offers practical performance‑tuning recommendations.
This article examines Cloudflare's decision to abandon Nginx for its home‑grown Pingora proxy, detailing the architectural limits of Nginx, the design choices behind Pingora, performance gains, added features, and the broader implications for large‑scale HTTP traffic handling.
This article explains how MySQL handles auto‑increment primary keys, InnoDB internal row_id, Xid, trx_id, and thread_id when their numeric limits are reached, illustrating the resulting errors, data overwrites, and potential consistency bugs with practical SQL examples and verification steps.
The article explains that 7‑Zip is an open‑source compression program released under GNU LGPL (with AES under BSD and unRAR under dual licenses), highlights its key features, compares its compression ratios to WinRAR using Firefox and Google Earth files, and provides the GitHub repository link.
This step‑by‑step guide shows how to install the GeoIP2 library, compile NGINX 1.18 with the ngx_http_geoip2 module, download the latest MaxMind GeoLite2 database, configure geoip2 directives, and verify that foreign IP requests are blocked with a 404 response.
This article examines why distributed systems need globally unique, trend‑increasing IDs, outlines strict generation requirements and availability goals, compares common approaches such as UUID, database auto‑increment, Redis, and the Snowflake algorithm, and provides practical implementation details and trade‑offs.
This article breaks down Spring's bean lifecycle, explaining the minimal creation steps, the role of BeanFactoryPostProcessor and BeanPostProcessor, how Spring resolves bean references, handles circular dependencies with three‑level caches, and clarifies common misconceptions about proxy generation.
This article explains how to assess MySQL table size using table capacity, disk usage, and instance limits, reveals why large tables slow down due to B+‑tree overhead, and presents three practical solutions—partitioning, sharding, and hot‑cold archiving—to restore query performance.
This article experimentally compares MySQL JOIN and IN (separate queries) across small, medium, and large data sets, providing PHP benchmark code, performance results, and practical conclusions on when each approach is more efficient.
