Hi Miguel ， I’ve tried your example “the affect gap locks to SELECT … FOR UPDATE ” on my server ,and my results …` of table `test`.`t` trx id 0 27638 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1… bits 0 0: len 8; hex 73757072656d756d; asc supremum;; —————— The lock_mode is “X insert intention” .
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… an early stage) out performed InnoDB with INSERTS and UPDATES (but not SELECTS). That … no plans to implement InnoDB style “gap locking“. Gap locking effectively involves locking rows that do not exist. This, …few configuration parameters. Â Was this an intentional design decision, and do you see it…
