MySQL 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 5, 20241Sep 5, 20241
This series is very helpful for PostgreSQL developers, and I am very much looking forward to the…Jun 24, 2024Jun 24, 2024
(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 10, 2024Jun 10, 2024
Evolution 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 9, 2024Jun 9, 2024
MySQL deadlock cause by lock inheritIn our user environment, we find deadlock cause by this example.Mar 22, 2024Mar 22, 2024
通过GDB non-stop mode 调试MySQL通过GDB non-stop mode 调试MySQL, 特别是用于复现死锁场景, 需要按照一定的并发顺序写入才可以构造出来, 通过GDB non-stop mode 可以非常方便进行构造Jul 31, 2023Jul 31, 2023
MySQL 常见死锁场景 — 并发Replace into导致死锁在之前的文章 #issue 68021 MySQL unique check 问题 中, 我们已经介绍了在 MySQL 里面, 由于唯一键的检查(unique check), 导致 MySQL 在 Read Commit 隔离级别也需要添加 GAP lock…Jun 11, 2023Jun 11, 2023
PolarDB auto_inc 场景性能优化之路在数据库的使用场景中, 最常见的场景是并发插入或者导入数据场景, 在该场景中并不指定自增id, 由数据库自动生成自增id, 然后插入到数据库中, 因此我们也叫auto_inc 场景的数据插入.Mar 14, 2023Mar 14, 2023
