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.
When a Linux server shows high iowait and becomes unresponsive, this guide walks you through using iostat, iotop, blktrace, fio and bpftrace to pinpoint the offending process, understand the full I/O stack, and apply kernel‑level and filesystem tuning to resolve the bottleneck.
In a candid interview, PostgreSQL founder Michael Stonebraker recounts his journey from Ingres to Postgres, critiques Oracle’s sales tactics, denounces Google’s and Amazon’s database strategies, explains Postgres’s extensible type system, explores the DBOS research project, and highlights why current large‑language‑model‑to‑SQL solutions remain far from production‑ready.
The article explains how MySQL determines whether a statement should be recorded in the binary log under ROW format, detailing the check_table_binlog_row_based function, the cached_row_logging_check flag, OPTION_BIN_LOG, and various scenarios—such as temporary tables, replication filters, no‑replicate tables, session settings, and internal operations—where binlog entries are omitted.
Microsoft has integrated a native Coreutils package into Windows, allowing many common Linux commands to run without WSL, but the single‑exe design, command conflicts, missing POSIX features, and runtime differences mean it cannot fully replace the Windows Subsystem for Linux.
This article provides an in‑depth technical analysis of Agent Skills, detailing the official specification, three‑layer progressive loading mechanism, engineering workflow of Skill‑Creator, naming and description rules, evaluation agents, practical advantages, known limitations, and five reusable design patterns for building robust AI agent capabilities.
The article compares RabbitMQ and NATS, outlining RabbitMQ's maturity and operational complexity versus NATS's lightweight, high‑performance, cloud‑native design, and explains when each solution is appropriate for modern microservice, edge, and AI‑driven architectures.
The article details Qunar’s AI‑driven SQL Agent project, describing how data‑governance, multi‑agent architecture, prompt design, and RAG techniques were combined to reduce data‑access latency, raise query accuracy above 85%, and streamline the end‑to‑end data‑service workflow for business users.
The article walks through an interview scenario where a candidate must handle a 10 GB CSV using just 512 MB of memory, critiques naive answers, and presents a step‑by‑step streaming, chunked, and checkpoint‑based solution with optional Kafka/Flink considerations.
This article reveals that most slow SQL queries aren't caused by large data volumes but by poor query writing, such as index‑killing functions, implicit type casts, leading wildcards, SELECT *, missing LIMIT, and inefficient JOINs, and offers a five‑step method to diagnose and fix them.
The article debunks the myth of Microsoft paying $20 million for a typo in Hotmail, then details the real 2000‑year‑old trademark fight over Lindows, explaining how Microsoft ultimately paid $20 million to acquire the Lindows brand and protect the Windows name.
