2. Query OK, 0 rows affected (0.00 sec)
  4. mysql> insert into t values (1),(10),(100);
  5. Query OK, 3 rows affected (0.00 sec)
  6. Records: 3  Duplicates: 0  Warnings: 0
  8. mysql> select * from information_schema.tokudb_locks\G
  9. *************************** 1. row ***************************
  10.                locks_trx_id: 238
  11.       locks_mysql_thread_id: 3
  12.                 locks_dname: ./test/t-main
  13.              locks_key_left: 0001000000
  14.             locks_key_right: 0001000000
  15.          locks_table_schema: test
  16.            locks_table_name: t
  17. locks_table_dictionary_name: main
  18. *************************** 2. row ***************************
  19.                locks_trx_id: 238
  20.       locks_mysql_thread_id: 3
  21.                 locks_dname: ./test/t-main
  22.              locks_key_left: 000a000000
  23.          locks_table_schema: test
  24.            locks_table_name: t
  26. *************************** 3. row ***************************
  27.                locks_trx_id: 238
  28.       locks_mysql_thread_id: 3
  29.                 locks_dname: ./test/t-main
  30.              locks_key_left: 0064000000
  31.             locks_key_right: 0064000000
  32.          locks_table_schema: test
  33.            locks_table_name: t
  34. locks_table_dictionary_name: main
  35. 3 rows in set (0.00 sec)

从tokudb_locks表可以查询到，生成了3条row-lock(locks_key_left和locks_key_right相等)。
为了存储和显示方便，locks_key_left/locks_key_right取key的hash值。

client1执行如下操作:

  1. mysql1> set autocommit=off;
  2. Query OK, 0 rows affected (0.00 sec)
  4. mysql1> insert into t values (1),(10),(100);
  5. Query OK, 3 rows affected (0.00 sec)
  6. Records: 3  Duplicates: 0  Warnings: 0
  8. mysql1> select * from information_schema.tokudb_locks\G
  9. *************************** 1. row ***************************
  10.                locks_trx_id: 283
  11.       locks_mysql_thread_id: 14
  12.                 locks_dname: ./test/t-main
  13.              locks_key_left: 0001000000
  15.            locks_table_name: t
  16. locks_table_dictionary_name: main
  17. *************************** 2. row ***************************
  18.                locks_trx_id: 283
  19.       locks_mysql_thread_id: 14
  20.                 locks_dname: ./test/t-main
  21.              locks_key_left: 000a000000
  22.             locks_key_right: 000a000000
  23.          locks_table_schema: test
  24.            locks_table_name: t
  25. locks_table_dictionary_name: main
  26. *************************** 3. row ***************************
  27.                locks_trx_id: 283
  28.       locks_mysql_thread_id: 14
  29.                 locks_dname: ./test/t-main
  30.              locks_key_left: 0064000000
  31.             locks_key_right: 0064000000
  32.          locks_table_schema: test
  33.            locks_table_name: t
  34. locks_table_dictionary_name: main
  35. 3 rows in set (0.00 sec)

锁等待超时了，通过参数tokudb_last_lock_timeout得知，hash为0064000000的row-lock已经被txnid为283（client1)抢占。

  1. tokudb_lock_timeout_debug = 0: No lock timeouts or lock deadlocks are reported.
  2. tokudb_lock_timeout_debug = 1: A JSON document that describes the lock conflict is stored in the tokudb_last_lock_timeout session variable
  4. tokudb_lock_timeout_debug = 3: A JSON document that describes the lock conflict is stored in the tokudb_last_lock_timeout session variable and is printed to the MySQL error log.