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

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 TransactionsPerformance OptimizationReplication Lag

0 likes · 8 min read

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

Aikesheng Open Source Community

May 21, 2025 · Databases

Understanding OMS Inmode Validation Anomalies in MySQL‑to‑OceanBase Migration

This article analyzes a puzzling case where data consistency checks between a MySQL source and an OceanBase target report matching results despite visible record differences, explains the OMS ordinary and Inmode validation modes, and outlines scenarios that trigger Inmode verification.

InmodeOMSOceanBase

0 likes · 7 min read

Understanding OMS Inmode Validation Anomalies in MySQL‑to‑OceanBase Migration

Aikesheng Open Source Community

May 20, 2025 · Databases

How to Diagnose and Resolve MySQL MDL Lock Blocking DDL Operations

This article walks through the background, reproduction steps, investigation methods, and concrete solution for MySQL metadata lock (MDL) issues that cause DDL statements to hang, and provides practical tips to prevent similar lock problems in production environments.

DDLDatabaseMDL

0 likes · 10 min read

How to Diagnose and Resolve MySQL MDL Lock Blocking DDL Operations

Aikesheng Open Source Community

May 19, 2025 · Databases

Can MySQL Group Replication Power Dual‑Active Data Centers? A Practical Test Script

This article presents a detailed design, implementation, and automated testing script that evaluates whether MySQL Group Replication can support dual‑data‑center active‑active deployments, covering deployment steps, replication modes, fault simulation, data consistency checks, and key conclusions.

Active-ActiveGroup ReplicationMGR

0 likes · 16 min read

Can MySQL Group Replication Power Dual‑Active Data Centers? A Practical Test Script

Aikesheng Open Source Community

May 14, 2025 · Artificial Intelligence

Why Good Data Beats Fancy AI: Lessons from MySQL HeatWave Golf Predictions

The article walks through five iterative experiments using MySQL HeatWave AutoML on a golf league dataset, showing how data quality, feature selection, and over‑fitting affect predictive accuracy and emphasizing that high‑quality data is essential for reliable AI models.

AutoMLHeatWaveMachine Learning

0 likes · 14 min read

Why Good Data Beats Fancy AI: Lessons from MySQL HeatWave Golf Predictions

Aikesheng Open Source Community

May 13, 2025 · Databases

Visualizing MySQL Execution Plans with Flame Graphs

This article explains how to use Flame Graphs to visualize MySQL execution plans, discusses the limitations of traditional EXPLAIN output, introduces the EXPLAIN ANALYZE feature in MySQL 8.0, provides sample SQL and command‑line usage, and shows how the visual tool helps quickly identify performance bottlenecks.

Database OptimizationEXPLAIN ANALYZESQL performance

0 likes · 11 min read

Visualizing MySQL Execution Plans with Flame Graphs

Aikesheng Open Source Community

May 12, 2025 · Databases

Understanding MySQL Error MY-013129 and How to Handle It

This article explains the MySQL MY-013129 error, its lack of a fixed message, the code paths that generate it in MySQL 8.0, why it is logged as an ERROR, and practical recommendations for filtering or handling the log entries.

DatabaseError HandlingLog Filtering

0 likes · 7 min read

Understanding MySQL Error MY-013129 and How to Handle It

Aikesheng Open Source Community

May 7, 2025 · Databases

Differences in Manual Statistics Collection for OceanBase: DBMS_STATS vs ANALYZE Across Versions

This article explains the differences between manual statistics collection methods in OceanBase 3.x and 4.x, compares DBMS_STATS and ANALYZE commands across MySQL and Oracle modes, provides version‑specific tables, detailed code examples for table, partition, and schema level collection, and shows how to verify statistics.

ANALYZEDBMS_STATSOceanBase

0 likes · 9 min read

Differences in Manual Statistics Collection for OceanBase: DBMS_STATS vs ANALYZE Across Versions

Aikesheng Open Source Community

May 6, 2025 · Databases

Using GDB to Adjust MySQL max_connections Without Restart

This article explains how to troubleshoot and resolve the MySQL "Too many connections" error by using GDB to modify the max_connections parameter on a running MySQL 5.7 instance without restarting, including step‑by‑step commands, sysbench load testing, and two practical methods.

Database TuningSysbenchTroubleshooting

0 likes · 9 min read

Using GDB to Adjust MySQL max_connections Without Restart

Aikesheng Open Source Community

Apr 24, 2025 · Databases

Migrating from PolarDB PostgreSQL to OceanBase (ob_oracle): A Comprehensive Guide

This article presents a step‑by‑step migration plan for moving a PolarDB PostgreSQL 11.9 tenant to an OceanBase 4.2.1.10 Oracle‑compatible tenant, covering background, scope, task distribution, user and permission conversion, table‑structure transformation, DataX data transfer, performance tuning, error handling, monitoring, and final recommendations.

DataXOceanBasePolardb

0 likes · 14 min read

Migrating from PolarDB PostgreSQL to OceanBase (ob_oracle): A Comprehensive Guide