# 阿里云数据库内核月报分类整理
<p align='center'>
<a href="https://github.com/tangwz/db-monthly" target="_blank"><img alt="GitHub" src="https://img.shields.io/github/stars/tangwz/db-monthly?label=Stars&style=flat-square&logo=GitHub"></a>
<a href="https://mp.weixin.qq.com/s/EcUrneGq_s2sPMxpUoHtWA" target="_blank"><img src="https://img.shields.io/badge/%E5%85%AC%E4%BC%97%E5%8F%B7-@%E5%A4%9A%E9%A2%97%E7%B3%96-000000.svg?style=flat-square&logo=WeChat">
<a href="https://www.zhihu.com/people/duoketang" target="_blank"><img src="https://img.shields.io/badge/%E7%9F%A5%E4%B9%8E-@tangwz-000000.svg?style=flat-square&logo=Zhihu"></a>
</p>
* [MySQL](#mysql)
* [PostgreSQL](#postgresql)
* [Redis](#redis)
* [MongoDB](#mongodb)
* [SQL Server](#sql-server)
* [MariaDB](#mariadb)
* [TokuDB](#tokudb)
* [Memcached](#memcached)
* [Database 基础知识](#database)
* [SQL优化](#sql优化)
* [RocksDB](#rocksdb)
* [Influxdb](#influxdb)
* [PG&GP](#pggp)
* [GPDB](#gpdb)
* [X-Engine](#x-engine)
* [PolarDB](#polardb)
* [PolarDB MySQL](#polardb-mysql)
* [AliSQL](#alisql)
* [PetaData](#petadata)
* [HybridDB](#hybriddb)
* [CloudDBA](#clouddba)
# MySQL
| 分类 | 标题 |
|---|---|
| 参数故事 | [timed_mutexes](http://mysql.taobao.org/monthly/2014/08/01/) |
| 参数故事 | [innodb_flush_log_at_trx_commit](http://mysql.taobao.org/monthly/2014/08/02/) |
| 参数故事 | [thread_concurrency](http://mysql.taobao.org/monthly/2014/09/05/) |
| 参数故事 | [innodb_additional_mem_pool_size](http://mysql.taobao.org/monthly/2016/04/01/) |
| 参数故事 | [max_prepared_stmt_count](http://mysql.taobao.org/monthly/2023/03/04/) |
| 捉虫动态 | [Count(Distinct) ERROR](http://mysql.taobao.org/monthly/2014/08/03/) |
| 捉虫动态 | [mysqldump BUFFER OVERFLOW](http://mysql.taobao.org/monthly/2014/08/04/) |
| 捉虫动态 | [long semaphore waits](http://mysql.taobao.org/monthly/2014/08/05/) |
| 捉虫动态 | [GTID 和 DELAYED](http://mysql.taobao.org/monthly/2014/09/01/) |
| 捉虫动态 | [GTID 和 binlog_checksum](http://mysql.taobao.org/monthly/2014/09/03/) |
| 捉虫动态 | [auto_increment](http://mysql.taobao.org/monthly/2014/09/06/) |
| 捉虫动态 | [binlog重放失败](http://mysql.taobao.org/monthly/2014/10/03/) |
| 捉虫动态 | [从库OOM](http://mysql.taobao.org/monthly/2014/10/04/) |
| 捉虫动态 | [崩溃恢复失败](http://mysql.taobao.org/monthly/2014/10/05/) |
| 捉虫动态 | [OPTIMIZE 不存在的表](http://mysql.taobao.org/monthly/2014/11/01/) |
| 捉虫动态 | [SIGHUP 导致 binlog 写错](http://mysql.taobao.org/monthly/2014/11/02/) |
| 捉虫动态 | [Opened tables block read only](http://mysql.taobao.org/monthly/2014/12/08/) |
| 捉虫动态 | [InnoDB自增列重复值问题](http://mysql.taobao.org/monthly/2015/01/04/) |
| 捉虫动态 | [mysql client crash一例](http://mysql.taobao.org/monthly/2015/01/07/) |
| 捉虫动态 | [设置 gtid_purged 破坏AUTO_POSITION复制协议](http://mysql.taobao.org/monthly/2015/01/08/) |
| 捉虫动态 | [replicate filter 和 GTID 一起使用的问题](http://mysql.taobao.org/monthly/2015/01/09/) |
| 捉虫动态 | [变量修改导致binlog错误](http://mysql.taobao.org/monthly/2015/02/07/) |
| 捉虫动态 | [pid file丢失问题分析](http://mysql.taobao.org/monthly/2015/03/03/) |
| 捉虫动态 | [DROP DATABASE外键约束的GTID BUG](http://mysql.taobao.org/monthly/2015/03/06/) |
| 捉虫动态 | [连接断开导致XA事务丢失](http://mysql.taobao.org/monthly/2015/04/05/) |
| 捉虫动态 | [GTID下slave_net_timeout值太小问题](http://mysql.taobao.org/monthly/2015/04/06/) |
| 捉虫动态 | [Relay log 中 GTID group 完整性检测](http://mysql.taobao.org/monthly/2015/04/07/) |
| 捉虫动态 | [删被引用索引导致crash](http://mysql.taobao.org/monthly/2015/04/09/) |
| 捉虫动态 | [5.6 与 5.5 InnoDB 不兼容导致 crash](http://mysql.taobao.org/monthly/2015/05/03/) |
| 捉虫动态 | [MySQL DDL BUG](http://mysql.taobao.org/monthly/2015/05/06/) |
| 捉虫动态 | [临时表操作导致主备不一致](http://mysql.taobao.org/monthly/2015/05/08/) |
| 捉虫动态 | [唯一键约束失效](http://mysql.taobao.org/monthly/2015/06/02/) |
| 捉虫动态 | [ALTER IGNORE TABLE导致主备不一致](http://mysql.taobao.org/monthly/2015/06/03/) |
| 捉虫动态 | [任性的 normal shutdown](http://mysql.taobao.org/monthly/2015/06/07/) |
| 捉虫动态 | [BUG 几例](http://mysql.taobao.org/monthly/2015/09/03/) |
| 捉虫动态 | [建表过程中crash造成重建表失败](http://mysql.taobao.org/monthly/2015/09/05/) |
| 捉虫动态 | [start slave crash 诊断分析](http://mysql.taobao.org/monthly/2015/10/05/) |
| 捉虫动态 | [删除索引导致表无法打开](http://mysql.taobao.org/monthly/2015/10/06/) |
| 捉虫动态 | [MySQL 外键异常分析](http://mysql.taobao.org/monthly/2015/11/06/) |
| 捉虫动态 | [ORDER/GROUP BY 导致 mysqld crash](http://mysql.taobao.org/monthly/2015/11/08/) |
| 捉虫动态 | [order by limit 造成优化器选择索引错误](http://mysql.taobao.org/monthly/2015/11/10/) |
| 捉虫动态 | [并行复制外键约束问题二](http://mysql.taobao.org/monthly/2016/04/04/) |
| 捉虫动态 | [left-join多表导致crash](http://mysql.taobao.org/monthly/2016/05/10/) |
| 捉虫动态 | [备库1206错误问题说明](http://mysql.taobao.org/monthly/2016/07/10/) |
| 捉虫动态 | [5.6中ORDER BY + LIMIT 错选执行计划](http://mysql.taobao.org/monthly/2016/12/08/) |
| 捉虫动态 | [event_scheduler 慢日志记错](http://mysql.taobao.org/monthly/2017/01/05/) |
| 捉虫动态 | [5.7 mysql_upgrade 元数据锁等待](http://mysql.taobao.org/monthly/2017/04/10/) |
| 捉虫动态 | [InnoDB crash](http://mysql.taobao.org/monthly/2017/06/05/) |
| 捉虫动态 | [show binary logs 灵异事件](http://mysql.taobao.org/monthly/2017/09/03/) |
| 捉虫动态 | [信号处理机制分析](http://mysql.taobao.org/monthly/2017/10/10/) |
| 捉虫动态 | [UK 包含 NULL 值备库延迟分析](http://mysql.taobao.org/monthly/2018/01/04/) |
| 捉虫动态 | [Error in munmap() "Cannot allocate memory"](http://mysql.taobao.org/monthly/2018/01/05/) |
| 捉虫动态 | [字符集相关变量介绍及binlog中字符集相关缺陷分析](http://mysql.taobao.org/monthly/2018/01/07/) |
| 捉虫动态 | [弱序内存模型导致的死锁问题](http://mysql.taobao.org/monthly/2020/01/03/) |
| 限制改进 | [GTID和升级](http://mysql.taobao.org/monthly/2014/09/02/) |
| 引擎差异 | [create_time in status](http://mysql.taobao.org/monthly/2014/09/04/) |
| 5.7重构 | [Optimizer Cost Model](http://mysql.taobao.org/monthly/2014/10/01/) |
| 系统限制 | [text字段数](http://mysql.taobao.org/monthly/2014/10/02/) |
| 功能改进 | [InnoDB Warmup特性](http://mysql.taobao.org/monthly/2014/10/06/) |
| 文件结构 | [告别frm文件](http://mysql.taobao.org/monthly/2014/10/07/) |
| 5.7改进 | [Recovery改进](http://mysql.taobao.org/monthly/2014/11/03/) |
| 5.7特性 | [高可用支持](http://mysql.taobao.org/monthly/2014/11/04/) |
| 5.7特性 | [在线Truncate undo log 表空间](http://mysql.taobao.org/monthly/2014/11/06/) |
| 5.7优化 | [Metadata Lock子系统的优化](http://mysql.taobao.org/monthly/2014/11/05/) |
| 性能优化 | [hash_scan 算法的实现解析](http://mysql.taobao.org/monthly/2014/11/07/) |
| 性能优化 | [5.7 Innodb事务系统](http://mysql.taobao.org/monthly/2014/12/01/) |
| 性能优化 | [thread pool 原理分析](http://mysql.taobao.org/monthly/2014/12/03/) |
| 性能优化 | [并行复制外建约束问题](http://mysql.taobao.org/monthly/2014/12/04/) |
| 性能优化 | [Bulk Load for CREATE INDEX](http://mysql.taobao.org/monthly/2014/12/07/) |
| 性能优化 | [Group Commit优化](http://mysql.taobao.org/monthly/2015/01/01/) |
| 性能优化 | [启用GTID场景的性能问题及优化](http://mysql.taobao.org/monthly/2015/01/03/) |
| 性能优化 | [InnoDB buffer pool flush策略漫谈](http://mysql.taobao.org/monthly/2015/02/01/) |
| �
