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

4.0k

Views

Comments

Latest from Aikesheng Open Source Community

100 recent articles max

Aikesheng Open Source Community

Aug 4, 2025 · Artificial Intelligence

July 2025 AI SQL Benchmark: New Leaders & Deep Dive into Large SQL & DB Migration

The July 2025 SCALE report evaluates the latest AI large models on advanced SQL tasks, introduces new entrants like Claude 3.5 Sonnet and Gemini 2.5 stable releases, upgrades the benchmark with large‑SQL and domestic database conversion metrics, and provides detailed rankings and analyses of model performance across optimization, dialect translation, and understanding.

AISQL

0 likes · 11 min read

Aikesheng Open Source Community

Jul 31, 2025 · Operations

Deploy Oracle RAC Test Environment Quickly with VirtualBox & Vagrant

Learn how to rapidly set up an Oracle RAC testing cluster using VirtualBox and Vagrant, covering the reasons for avoiding Docker, required software versions, Vagrantfile configuration, shared disk creation, network setup, and step‑by‑step commands to launch and access the virtual machines.

Oracle RACVagrantVirtualBox

0 likes · 10 min read

Deploy Oracle RAC Test Environment Quickly with VirtualBox & Vagrant

Aikesheng Open Source Community

Jul 23, 2025 · Databases

How to Diagnose and Fix OceanBase Tenant Memory Exhaustion Issues

This guide walks through diagnosing OceanBase tenant memory exhaustion by tracing error codes, extracting TRACE_IDs, analyzing OBServer logs, querying virtual tables for memory allocation details, and applying a version upgrade to resolve the underlying memory leak.

Database DebuggingObserverOceanBase

0 likes · 10 min read

How to Diagnose and Fix OceanBase Tenant Memory Exhaustion Issues

Aikesheng Open Source Community

Jul 21, 2025 · Artificial Intelligence

Can Gemini AI Directly Query MySQL? A FastMCP Walkthrough

This article demonstrates how to set up a FastMCP server for MySQL, load the Sakila sample database, expose query tools to Gemini, experiment with different model versions and temperature settings, and observe the generated SQL queries and results, providing a practical guide for AI‑driven database access.

AI integrationDatabaseGemini

0 likes · 16 min read

Can Gemini AI Directly Query MySQL? A FastMCP Walkthrough

Aikesheng Open Source Community

Jul 16, 2025 · Databases

Why Does Percona XtraDB Cluster Hang? Uncovering the wsrep_group_commit Deadlock

This article investigates a recurring crash in Percona XtraDB Cluster 8.0.41 caused by the removal of the wsrep_group_commit_queue component, analyzes error logs and core dumps with GDB, reveals a circular deadlock among internal threads, and provides reproducible steps and debugging tips for DBAs.

DebuggingGroup CommitPercona XtraDB Cluster

0 likes · 27 min read

Why Does Percona XtraDB Cluster Hang? Uncovering the wsrep_group_commit Deadlock

Aikesheng Open Source Community

Jul 15, 2025 · Databases

Uncovering the Risks of Variable Assignment in ORDER BY Clauses

This article explains why using variable assignment expressions inside ORDER BY clauses can trigger severe OCP alarms, analyzes the underlying source code in OceanBase, demonstrates unpredictable query results with examples, and offers safer alternative patterns.

Database WarningOceanBaseOrder By

0 likes · 8 min read

Uncovering the Risks of Variable Assignment in ORDER BY Clauses

Aikesheng Open Source Community

Jul 14, 2025 · Databases

Unlock MySQL Performance: How EXPLAIN ANALYZE Reveals Real Execution Costs

This article explains how MySQL's EXPLAIN and EXPLAIN ANALYZE statements work, compares their outputs, and demonstrates through three practical examples how to interpret actual execution costs, row counts, and loop information to identify indexing and query‑plan inefficiencies.

EXPLAINEXPLAIN ANALYZESQL optimization

0 likes · 11 min read

Unlock MySQL Performance: How EXPLAIN ANALYZE Reveals Real Execution Costs

Aikesheng Open Source Community

Jul 9, 2025 · Databases

Unlocking OceanBase Thread Limits: How min_worker_cnt and max_worker_cnt Are Calculated

This article explains why OceanBase enforces minimum values for min_worker_cnt and max_worker_cnt, shows the source‑code formulas used to compute them, demonstrates how to verify and adjust these parameters, and clarifies the impact of tenant memory and Meta‑tenant reservations on the final values.

Database ConfigurationOceanBaseParameter Tuning

0 likes · 12 min read

Unlocking OceanBase Thread Limits: How min_worker_cnt and max_worker_cnt Are Calculated

Aikesheng Open Source Community

Jul 2, 2025 · Databases

How to Speed Up Slow SQL Queries: Choosing Driver Tables and Join Strategies

This article analyzes a slow SQL query by examining driver tables, execution plans, and table row counts, then demonstrates three optimization approaches—setting a small table as driver, setting a large table as driver, and switching to hash joins—showing their impact on execution time and providing practical guidelines for selecting the best strategy.

Driver TableHash JoinOceanBase

0 likes · 16 min read

How to Speed Up Slow SQL Queries: Choosing Driver Tables and Join Strategies

Aikesheng Open Source Community

Jul 1, 2025 · Databases

How to Fix MySQL Online DDL Failures Caused by Stale Temporary Tables

This article explains why MySQL 5.7 community edition may block online DDL operations when leftover temporary table files remain, analyzes the root cause, and provides step‑by‑step commands and alternative solutions to safely remove the orphaned tables.

Database AdministrationInnoDBOnline DDL

0 likes · 6 min read

How to Fix MySQL Online DDL Failures Caused by Stale Temporary Tables