Enterprise-level professional community for Database, BigData, and AIOps. Daily original articles, weekly online tech talks, monthly offline salons, and quarterly XCOPS&DAMS conferences—delivered by industry experts.
A large OTA platform eliminated sharding query latency by encoding a 4-bit routeKey into 64-bit Snowflake order IDs, enabling direct shard lookup without index table queries, reducing P99 latency from over 1 second to tens of milliseconds and cutting database load by 80% through a three-layer fallback strategy.
The article traces mandatory complex password rules to Bill Burr's 2003 NIST guide based on a 1980s paper, reveals how they create predictable patterns, cites xkcd's entropy comparison, and notes Burr's 2017 regret and NIST's updated guidelines, yet many sites still enforce the outdated rules.
A comprehensive guide to recovering from accidental rm -rf deletions on Linux, covering immediate response, file system internals (ext4/xfs/btrfs/zfs), multiple recovery tools (extundelete, debugfs, lsof, snapshots), a real incident timeline, risk assessment, and prevention strategies including code review, monitoring, and backup practices.
This article details a production-grade architecture for enterprise AI agents, combining a unified harness for execution control, federated skills for domain expertise, and a virtual file system for long-task context management, drawing on Stripe's Kai platform and Deep Agents framework to address governance, security, and scalability challenges.
The article explains why directly using LLMs to generate SQL leads to sub-50% accuracy in production, and presents a proven three-layer architecture—semantic layer for business knowledge, LLM layer for structured DSL generation, and deterministic execution layer for dialect-specific SQL translation—that achieves 85-90% accuracy through RAG, ambiguity detection, and feedback loops.
A 500k RMB e-commerce customer service AI Agent was shut down within a week due to hallucinated refund IDs, 3-5 second latency, context confusion in multi-turn conversations, and 23% silent tool failures, revealing the gap between demos and production reality.
The article explains why two hosts with different CIDR prefixes can ping each other while two hosts sharing the same network ID cannot, by demonstrating how each computer uses only its own subnet mask to calculate network IDs and decide whether to ARP directly or send via a gateway.
This comprehensive guide covers MySQL 9.5 performance optimization across table design, indexing strategies, query analysis with EXPLAIN, JOIN optimization, pagination techniques, system-level InnoDB tuning, and monitoring using Performance Schema and slow query logs to achieve dramatic query speed improvements.
The 1992 Usenet debate where Andrew Tanenbaum called Linux's monolithic kernel obsolete is revisited, revealing how Linux came to dominate servers, phones, and supercomputers, while Minix quietly became the hidden OS inside Intel's Management Engine on hundreds of millions of x86 chips, making both architects unexpected winners.
The article examines a MySQL experiment where three transactions (A, B, C) interact on the same row, showing why transaction B’s UPDATE on a primary‑key field proceeds without waiting while transaction C’s UPDATE of the primary key blocks, due to the interplay of row‑level locks, gap locks, and the internal delete‑plus‑insert transformation of indexed updates.
