The Aikesheng Open Source Community provides stable, enterprise‑grade MySQL open‑source tools and services, releases a premium open‑source component each year (1024), and continuously operates and maintains them.
A production OceanBase Oracle‑mode database experienced excessive Incr‑Sync delay due to a DDL timeout, and the article walks through log analysis, the oracleSocketTimeout parameter issue, configuration changes, verification steps, and final recommendations to resolve the blockage.
This article introduces the BIRD-CRITIC benchmark, a comprehensive SQL diagnostic dataset spanning multiple dialects, evaluates large language models' ability to repair real-world database queries, and discusses its design, multi‑dialect support, data quality processes, and experimental results.
September 2025 SCALE released its latest SQL‑LLM leaderboard, adding Moonshot AI’s Kimi‑K2‑Instruct‑0905 model, detailing its scores on SQL understanding, optimization and dialect conversion, unveiling platform upgrades for fine‑grained metric ranking and visual model comparison, and offering expert analysis of strengths and weaknesses.
This article explains why a Docker container reports an out‑of‑memory error even though the host shows over 2 GB of free memory, analyzes the discrepancy between MemFree and MemAvailable, examines Linux memory watermarks, and provides a step‑by‑step solution by adjusting vm.min_free_kbytes.
This article explains the complete lifecycle of a MySQL UPDATE—from the initial log buffer, through redo and undo logs, buffer‑pool dirty pages, checkpoint thresholds, binary logging, and the innodb_flush_log_at_trx_commit setting—highlighting how InnoDB guarantees durability, consistency, and crash recovery.
This article explains how MySQL processes the KILL command, detailing the interaction between threads, the role of the kill flag, and the is_killed() function, all illustrated with diagrams and code examples to help readers grasp thread termination internals.
This article explains MySQL replication architecture, detailing how binary logs are transferred, the roles of dump, I/O receiver, and SQL apply threads, the metadata tables they use, and key system variables for optimizing replication performance and durability.
This article compiles and categorizes the most significant Text‑to‑SQL and NL2SQL datasets released up to 2025, detailing their origins, sizes, domains, and evaluation benchmarks, while providing quick links to papers and dataset repositories for researchers and developers.
Action OMS, a customized version of OceanBase’s OMS tool, enables seamless migration and real‑time data subscription from Microsoft SQL Server (2008‑2019 Enterprise) to OceanBase, detailing preparation, configuration, CDC setup, and best‑practice considerations for reliable, low‑latency data transfer.
This article explains why the binlog Position may not advance after executing SQL on an OceanBase MySQL tenant, outlines two main causes, and provides step‑by‑step commands to verify binlog task health and identify unsupported statements.
