Comment 5 for bug 1662725

Revision history for this message
Kenny Gryp (gryp) wrote :

This is what you would get in INNODB_LOCKS:
perconaserver mysql> select * from information_schema.INNODB_LOCKS;
+------------------+-------------+-----------+-----------+------------+------------+------------+-----------+----------+------------------------+
| lock_id | lock_trx_id | lock_mode | lock_type | lock_table | lock_index | lock_space | lock_page | lock_rec | lock_data |
+------------------+-------------+-----------+-----------+------------+------------+------------+-----------+----------+------------------------+
| 2238925:347:13:1 | 2238925 | X | RECORD | `xa`.`t1` | PRIMARY | 347 | 13 | 1 | supremum pseudo-record |
| 2238923:347:13:1 | 2238923 | S | RECORD | `xa`.`t1` | PRIMARY | 347 | 13 | 1 | supremum pseudo-record |
+------------------+-------------+-----------+-----------+------------+------------+------------+-----------+----------+------------------------+