… you can show a program where row-locks are used by one user to lock records for edit/update, so the transaction is…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
…) ——- TRX HAS BEEN WAITING 34 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 57 page no 3 n bits 72… `test`.`t` trx id 0 27638 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; —————— The lock…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… my slide deck, is now available. You can watch the recording and get the slides here. I got a lot of… the beginning to prevent dead locks? So you would get a lock wait instead of a dead lock. No, that would cause blocking…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…, query id 163 localhost msandbox TABLE LOCK table `test`.`t` trx id 72C lock mode IX RECORD LOCKS space id 19 page no 4 n bits 80 index `age` of table `test`.`t` trx id 72C lock_mode X RECORD LOCKS…` of table `test`.`t` trx id 72C lock_mode X locks rec but not gap RECORD LOCKS space id 19 page no 4 n…
Comment: InnoDB's gap locks
April 5, 2012 By 15 Comments
… the affected index record has been locked but also the gap before and after that record with a shared gap lock preventing the insertion of data to other sessions.” so how to calculate the shared gap lock…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… innodb_lock_wait_timeout = 50 A count command with approx 3 million records is taking too long and all my transactions are locked…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… not null; Query OK, 1 row affected (0.65 sec) Records: 1 Duplicates: 0 Warnings: 0 SESSION2: root@ubuntu:~/dump# tail…_set_client = @saved_cs_client */; — – Dumping data for table `C` — LOCK TABLES `C` WRITE; /*!40000 ALTER TABLE `C` DISABLE KEYS */; /*!40000… are potential solutions for this problem ? you can use mysqldump –lock-all-tables instead which does not have this problem at…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…/iz` trx id 0 42313619 lock_mode X locks rec but not gap waiting Record lock, heap no 5 PHYSICAL RECORD: n_fields 4; compact…/iz` trx id 0 42313620 lock_mode X locks rec but not gap Record lock, heap no 5 PHYSICAL RECORD: n_fields 4; compact format…/iz` trx id 0 42313620 lock_mode X locks rec but not gap waiting Record lock, heap no 4 PHYSICAL RECORD: n_fields 4; compact…
Comment: SELECT LOCK IN SHARE MODE and FOR UPDATE
January 28, 2010 By 51 Comments
… records locks. If using records locks, than innodb knows about two kind of locks: Exclusive and shared. Last time I checked, innodb does not support record ‘update’ locks…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
… ——- TRX HAS BEEN WAITING 14 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 33504 n bits 328 index `j` of table `test/sample` trx id 0 42304626 lock_mode X locks rec but not gap waiting Record lock, heap no 180 PHYSICAL RECORD: n_fields 2; compact…
