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.
MySQL AI, introduced for the database's 30th anniversary, integrates auto‑ML, generative AI, LLM‑driven text‑to‑SQL, and a vector engine directly into MySQL Enterprise, enabling developers to build intelligent applications on familiar SQL tools without moving data.
This article analyzes a real‑world OceanBase‑to‑Oracle incremental sync failure caused by VARCHAR2 length limits, explains the role of NLS_LENGTH_SEMANTICS and MAX_STRING_SIZE, and provides three practical solutions—including extending string size, using CLOB fields, and PL/SQL workarounds—to reliably insert data exceeding 4000 bytes.
This article explains why the SHOW GRANTS command can display permissions that differ from a MySQL user's actual abilities after modifying the host field, analyzes the underlying cause across multiple privilege tables, and provides safe methods—including RENAME USER—to resolve the inconsistency.
The Aikexing open‑source community announces a giveaway of the technical book “SQL Server Operations Guide”, detailing its four‑part content on installation, performance tuning, security, multimodal data, and high‑availability architecture, authored by veteran DBA Lin Yonghua, and inviting beginners, developers, and educators to participate.
This article examines why a SELECT … FOR UPDATE query that appears to use a covering index in MySQL actually performs a table‑row lookup, detailing indirect evidence from performance_schema locks and direct proof through InnoDB source code, and explains the necessity of accessing the primary key for transaction isolation.
This article walks through practical techniques for optimizing slow queries in OceanBase, covering essential data collection, distinguishing trace_id, sql_id, and plan_id, handling multiple sql_id scenarios, and manually gathering statistics across versions, with detailed SQL examples, tables, and visual aids.
This guide walks you through preparing Oracle and PostgreSQL test tables, inserting sample data, converting an Oracle stored procedure to PostgreSQL using the SQLShift tool, and fixing the few manual adjustments needed for a successful migration.
The August 2025 SCALE benchmark evaluates new AI models—including the GPT‑5 family, DeepSeek‑V3.1, and the SQLShift tool—across SQL understanding, optimization, and dialect conversion, revealing distinct strengths, weaknesses, and the growing advantage of specialized tools over generic large language models.
This article walks through a real‑world OceanBase ODP binlog connection failure, explains the error message, analyzes possible causes, shows how to trace logs and configuration, and provides a concrete fix by correcting the binlog_service_ip setting and restarting ODP.
This article explains OceanBase's Offline DDL implementation, showing how it rebuilds tables, manages table locks, tracks execution progress, evaluates performance, and answers common questions about lock behavior and time estimation with detailed SQL examples and log analysis.
