Author

Aikesheng Open Source Community

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.

1.4k

Articles

Likes

3.5k

Views

Comments

Latest from Aikesheng Open Source Community

100 recent articles max

Aikesheng Open Source Community

Jun 19, 2025 · Databases

How OceanBase CPU Quotas and Large Queries Shape Performance

This article explores OceanBase v4 CPU‑related parameters such as workers_per_cpu_quota, cpu_quota_concurrency, and parallel_servers_target, explains their formulas, demonstrates experimental setups and results on tenant thread limits, large‑query impact, and provides practical tuning recommendations based on observed performance data.

Database ConcurrencyOceanBasePerformance Tuning

0 likes · 17 min read

How OceanBase CPU Quotas and Large Queries Shape Performance

Aikesheng Open Source Community

Jun 17, 2025 · Artificial Intelligence

Introducing SCALE: An Open‑Source Benchmark Redefining LLM SQL Capabilities

This article presents SCALE, a community‑driven, open‑source benchmark that expands beyond simple Text‑to‑SQL accuracy to evaluate large language models on performance, dialect conversion, and deep SQL understanding, offering developers, researchers, and CTOs a realistic measure of AI‑assisted database tasks.

AILLMSQL

0 likes · 10 min read

Introducing SCALE: An Open‑Source Benchmark Redefining LLM SQL Capabilities

Aikesheng Open Source Community

Jun 11, 2025 · Databases

Why Does Adding a Column Trigger Duplicate Entry Errors in MySQL?

An experienced DBA explains why adding a new column in MySQL can unexpectedly raise duplicate entry errors during online DDL, detailing the role of primary and unique keys, the innodb_online_alter_log_max_size setting, and how concurrent DML operations cause the conflict.

DDLMySQLOnline DDL

0 likes · 8 min read

Why Does Adding a Column Trigger Duplicate Entry Errors in MySQL?

Aikesheng Open Source Community

Jun 5, 2025 · Databases

How MySQL Connection Control Plugins Can Cause Connection Pile‑up and How to Fix It

This article explains the MySQL Connection Control Plugins introduced in 5.7.17, how improper configuration can lead to connection backlog and database hangs, and provides step‑by‑step installation, parameter tuning, testing procedures, and mitigation strategies to resolve the issue.

Connection ControlDatabase PerformanceMySQL

0 likes · 9 min read

How MySQL Connection Control Plugins Can Cause Connection Pile‑up and How to Fix It

Aikesheng Open Source Community

Jun 4, 2025 · Databases

Using Cgroups for MySQL Resource Isolation: CPU, Memory, IO, and Network Limits

This article presents a comprehensive guide on applying Linux Cgroups to isolate MySQL resources, covering CPU, memory, I/O, and network bandwidth controls, detailed configuration steps, performance testing with sysbench, and practical observations to ensure stable and predictable database behavior.

LinuxMySQLPerformance Tuning

0 likes · 47 min read

Using Cgroups for MySQL Resource Isolation: CPU, Memory, IO, and Network Limits

Aikesheng Open Source Community

Jun 3, 2025 · Databases

Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix

The article details a MySQL 5.7 bug where rollback SQL generated for a JSON NOT NULL column produces an empty string instead of NULL, explains the underlying binlog behavior, reproduces the issue with sample tables, and provides a practical workaround by converting the JSON column to TEXT before re‑importing the data, while recommending strict SQL_MODE for production.

JSONMySQLSQL_MODE

0 likes · 7 min read

Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix

Aikesheng Open Source Community

May 28, 2025 · Databases

Analyzing and Optimizing Slow OceanBase SQL Queries Using TopSQL and Execution Plan Rewrites

This article investigates a slow OceanBase SQL query by examining CPU and TopSQL metrics, dissecting the execution plan, identifying batch join inefficiencies, rewriting the SQL for better performance, and demonstrating a reduction in execution time from over 2600 seconds to under one second.

Batch JoinDatabase PerformanceOceanBase

0 likes · 18 min read

Analyzing and Optimizing Slow OceanBase SQL Queries Using TopSQL and Execution Plan Rewrites

Aikesheng Open Source Community

May 27, 2025 · Databases

MySQL Execution Plans in Tree Format

This article introduces MySQL's tree‑style execution plan output using EXPLAIN FORMAT=TREE, explains its advantages over traditional and JSON formats, and demonstrates its practical use through eight detailed SQL examples with full plan analysis and performance insights.

MySQLSQL OptimizationTree Format

0 likes · 12 min read

Aikesheng Open Source Community

May 26, 2025 · Information Security

Building a Minimal Offline MySQL CVE Scanning Tool with DuckDB

This article demonstrates how to create a lightweight, offline MySQL CVE scanning and reporting tool by cloning the CVEProject JSON repository, leveraging DuckDB for fast JSON parsing and SQL queries, and providing simple shell commands for data updates, version scanning, and vulnerability matching.

CVEDuckDBMySQL

0 likes · 6 min read

Building a Minimal Offline MySQL CVE Scanning Tool with DuckDB

Aikesheng Open Source Community

May 22, 2025 · Databases

Root Cause Analysis of MySQL Replication Lag Caused by Large Transactions in a Sharding Scenario

This article examines a real‑world MySQL master‑slave replication lag issue caused by massive multi‑table transactions during a sharding operation, details the investigative steps using system tables, binlog parsing, and my2sql analysis, and proposes three practical mitigation strategies.

Large TransactionsMySQLPerformance optimization

0 likes · 8 min read

Root Cause Analysis of MySQL Replication Lag Caused by Large Transactions in a Sharding Scenario