ACE Profile

Full Name

ACE Associate

Job Role Senior Project Manager

Company Chengdu QiLian Technology Co., Ltd

Country China, People's Republic of

Top Expertise Database

Focus Area Database

About Gang

Expertises Database MySQL SQL Developer Architecture

Links

Latest Contributions

#SELECTION#

#ICON_HTML#

MySQL一条SQL实现24点扑克算法

Jan 26, 2026 - Blog post -

MySQL

#ACTIONS#
#SELECTION#

#ICON_HTML#

MySQL优化利用松散索引扫描提升性能1800倍

Jan 26, 2026 - Blog post -

MySQL

Optimization

#ACTIONS#
#SELECTION#

#ICON_HTML#

MySQL一条SQL填数独

Jan 26, 2026 - Blog post -

MySQL

#ACTIONS#
#SELECTION#

#ICON_HTML#

一张表，一条记录，也能玩出死锁!!!

Jan 26, 2026 - Blog post -

MySQL

#ACTIONS#
#SELECTION#

#ICON_HTML#

在特殊数据场景下，你写的SQL必须添加hint！

Jan 20, 2026 - Blog post -

MySQL

Optimization

#ACTIONS#
#SELECTION#

#ICON_HTML#

数据库设计(MySQL)避坑指南

Jan 20, 2026 - Blog post -

MySQL

#ACTIONS#
#SELECTION#

#ICON_HTML#

MySQL优化-生产实践，改写JOIN顺序性能提升7倍

Jan 14, 2026 - Blog post -

MySQL 8

Optimization

#ACTIONS#
#SELECTION#

#ICON_HTML#

MySQL优化生产实践-MySQL 优化器负优化产生超慢查询(三)，优化后性能提升 47倍

Jan 14, 2026 - Blog post -

MySQL 8

Optimization

#ACTIONS#
#SELECTION#

#ICON_HTML#

MySQL优化-生产实践复原生产死锁，该怎么处理才能避免？

Jan 14, 2026 - Blog post -

MySQL 8

Optimization

#ACTIONS#
#SELECTION#

#ICON_HTML#

MySQL Json数组转字符串拼接简洁写法

Sep 11, 2025 - Blog post -

MySQL 8

JSON

#ACTIONS#
#SELECTION#

#ICON_HTML#

MySQL优化生产实践-MySQL 优化器负优化产生超慢查询(二)，优化后性能提升 252倍

Sep 11, 2025 - Blog post -

MySQL 8

Optimization

#ACTIONS#
#SELECTION#

#ICON_HTML#

MySQL优化生产实践-MySQL 优化器负优化产生超慢查询(一)，优化后性能提升 2347倍

Aug 21, 2025 - Blog post -

MySQL 8

Optimization

#ACTIONS#
#SELECTION#

#ICON_HTML#

MySQL 窗口函数在select中执行顺序引发的问题

Jul 11, 2025 - Blog post -

MySQL

#ACTIONS#
#SELECTION#

#ICON_HTML#

MySQL Where条件写重复导致的慢查询

Jun 11, 2025 - Blog post -

MySQL 8

Optimization

#ACTIONS#
#SELECTION#

#ICON_HTML#

热表高并发避免死锁的最简单方式

Apr 23, 2025 - Blog post -

MySQL 8

#ACTIONS#

1 - 15

ACE

Top Level Details

About Gang

Latest Contributions