阿里云文档 2024-05-30

SHOW PROCESSLIST死锁Bug说明

MySQL官方在8.0.28版本中,为每个会话引入了LOCK_thd_security_ctx锁(Bug#32320541),该锁的引入使得MySQL在执行SHOW PROCESSLIST语句时可能形成死锁。本文将介绍这一类死锁问题的发生原因及解决方案。

文章 2016-05-10 来自:开发者社区

[MySQL Bug] bug#61579碎碎念

changelog: InnoDB: For an InnoDB table with a trigger, under the setting innodb_autoinc_lock_mode=1, sometimes auto-increment values could be interleaved when inserting into the table f...

文章 2016-05-10 来自:开发者社区

[MySQL Bug] bug#65111碎碎念

changelog里的描述: InnoDB: In a transaction using the REPEATABLE READ isolation level, an UPDATE or DELETE statement for anInnoDB table could sometimes overlook rows rec...

文章 2016-05-10 来自:开发者社区

[MySQL 源码] 关于bug#65389的碎碎念

[MySQL Bug] bug#65389  MVCC IS BROKEN WITH IMPLICIT LOCK 该bug在5.5.26中被修复,changelog的描述如下: If a row was deleted from an InnoDB table, then another row was re-inserted with the same primary key valu...

本页面内关键词为智能算法引擎基于机器学习所生成,如有任何问题,可在页面下方点击"联系我们"与我们沟通。