阿里云数据库内核月报分类整理（定时更新）_httpmysql.taobao.orgmonth_db-monthly.zip

# 阿里云数据库内核月报分类整理 <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/) | | �