chen zongzhiMySQL B-tree Height Issues in Large Single TablesSome older DBAs may remember that in the past, it was recommended that a MySQL table should not exceed 5 million rows. Many DBAs worry that…Sep 51Sep 51
chen zongzhiThis series is very helpful for PostgreSQL developers, and I am very much looking forward to the…Jun 24Jun 24
chen zongzhi(In database terms, latch usually refers to a physical lock, while lock refers to a logical…In InnoDB, the B-tree has two main types of locks: index lock and page lock.Jun 10Jun 10
chen zongzhiEvolution of InnoDB B-Tree Latch Optimization(In database terms, latch usually refers to a physical lock, while lock refers to a logical transaction lock. They are used interchangeably…Jun 9Jun 9
chen zongzhiMySQL deadlock cause by lock inheritIn our user environment, we find deadlock cause by this example.Mar 22Mar 22
chen zongzhi通过GDB non-stop mode 调试MySQL通过GDB non-stop mode 调试MySQL, 特别是用于复现死锁场景, 需要按照一定的并发顺序写入才可以构造出来, 通过GDB non-stop mode 可以非常方便进行构造Jul 31, 2023Jul 31, 2023
chen zongzhiMySQL 常见死锁场景 — 并发Replace into导致死锁在之前的文章 #issue 68021 MySQL unique check 问题 中, 我们已经介绍了在 MySQL 里面, 由于唯一键的检查(unique check), 导致 MySQL 在 Read Commit 隔离级别也需要添加 GAP lock…Jun 11, 2023Jun 11, 2023
chen zongzhiPolarDB auto_inc 场景性能优化之路在数据库的使用场景中, 最常见的场景是并发插入或者导入数据场景, 在该场景中并不指定自增id, 由数据库自动生成自增id, 然后插入到数据库中, 因此我们也叫auto_inc 场景的数据插入.Mar 14, 2023Mar 14, 2023