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

Aug 28, 2025 · Artificial Intelligence

How Does DeepSeek‑V3.1 Perform on Professional SQL Tasks? A Detailed Benchmark

This report objectively evaluates DeepSeek‑V3.1 on professional‑grade SQL tasks, presenting its balanced strengths in understanding, optimization, and dialect conversion, highlighting its top scores in syntax error detection and Chinese database conversion while exposing weaknesses in execution‑plan analysis and large‑SQL transformations.

Artificial IntelligenceDeepSeekLLM

0 likes · 8 min read

How Does DeepSeek‑V3.1 Perform on Professional SQL Tasks? A Detailed Benchmark

Aikesheng Open Source Community

Aug 26, 2025 · Databases

Do MySQL Session Variables Inflate Memory? Experiments Reveal the Truth

This article investigates whether repeatedly assigning different or large values to MySQL session variables causes the session's memory usage to grow, presenting two experiments with functions, processlist analysis, and concluding that only large values significantly increase memory consumption.

MySQLSessiondatabase

0 likes · 7 min read

Do MySQL Session Variables Inflate Memory? Experiments Reveal the Truth

Aikesheng Open Source Community

Aug 20, 2025 · Artificial Intelligence

GPT‑5 Models Ranked: Which Variant Excels at SQL Tasks?

An in‑depth August 2025 benchmark evaluates GPT‑5’s mini, nano, and chat variants on SQL understanding, optimization, and dialect conversion, revealing gpt‑5‑mini’s balanced performance, gpt‑5‑nano’s strong code‑generation accuracy, and gpt‑5‑chat’s theoretical strengths but practical shortcomings, guiding scenario‑specific model selection.

AI model evaluationArtificial IntelligenceGPT-5

0 likes · 9 min read

GPT‑5 Models Ranked: Which Variant Excels at SQL Tasks?

Aikesheng Open Source Community

Aug 19, 2025 · Databases

Why REPLACE INTO Breaks Auto‑Increment After Master‑Slave Switch

This article explains how the REPLACE INTO statement can cause mismatched AUTO_INCREMENT values between MySQL master and replica after a failover, leading to primary‑key conflicts, and provides reproduction steps, underlying mechanics, and practical mitigation strategies.

MySQLREPLACE INTOauto_increment

0 likes · 9 min read

Why REPLACE INTO Breaks Auto‑Increment After Master‑Slave Switch

Aikesheng Open Source Community

Aug 18, 2025 · Databases

Unlocking LeetCode’s Hardest SQL Problem with Window Functions

This article examines LeetCode problem 185 – the hardest SQL challenge – by preparing the Employee and Department tables, presenting two solution approaches (a subquery and a window‑function version), benchmarking their performance on large test data, and explaining why window functions are the superior choice in MySQL 8+.

LeetCodeMySQLPerformance

0 likes · 10 min read

Unlocking LeetCode’s Hardest SQL Problem with Window Functions

Aikesheng Open Source Community

Aug 12, 2025 · Artificial Intelligence

Why Model Context Protocol (MCP) Is the New AI Infrastructure You Can’t Miss

This article explains how the Model Context Protocol (MCP) solves the AI integration "M×N" problem by providing a universal language for AI applications and tools, outlines its technical principles, showcases practical case studies, and promotes the accompanying book that teaches MCP from theory to implementation.

AIMCPModel Context Protocol

0 likes · 9 min read

Why Model Context Protocol (MCP) Is the New AI Infrastructure You Can’t Miss

Aikesheng Open Source Community

Aug 12, 2025 · Databases

Why OceanBase Driver Throws Access Denied in Kubernetes and How to Resolve

This article analyzes why an OceanBase JDBC driver fails with "Access denied" errors when deployed in Kubernetes, compares it with the MySQL driver, explains the role of IP whitelist verification, and provides step‑by‑step troubleshooting, configuration adjustments, and preventive measures.

Access deniedIP whitelistJDBC driver

0 likes · 14 min read

Why OceanBase Driver Throws Access Denied in Kubernetes and How to Resolve

Aikesheng Open Source Community

Aug 7, 2025 · Databases

Unlock MySQL REST Service: Step‑by‑Step Installation and API Guide

This tutorial walks you through installing MySQL REST Service on Oracle Linux, configuring the metadata schema, using MySQL Shell in VS Code, loading the component, managing variables, handling X‑protocol settings, creating services, and authenticating via MRS, MySQL Internal, cookie or JWT, with full command‑line examples and code snippets.

AuthenticationJSONMySQL

0 likes · 17 min read

Unlock MySQL REST Service: Step‑by‑Step Installation and API Guide

Aikesheng Open Source Community

Aug 5, 2025 · Artificial Intelligence

How Model Size Shapes SQL Mastery: Insights from 1.5B‑32B LLMs

This article examines how the parameter count of large language models influences their ability to generate and understand SQL, comparing small (1.5B), medium (7B), and large (32B) models through a complex query case study, and highlights the trade‑offs between accuracy, reasoning depth, and resource consumption.

Artificial IntelligenceSQLmodel scaling

0 likes · 14 min read

How Model Size Shapes SQL Mastery: Insights from 1.5B‑32B LLMs

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