Debian Codegraph @

mysql-test/suite/perfschema/r/innodb_data_locks_resize.result

raw
1 CREATE TABLE t1 (
2 id INT PRIMARY KEY
3 ) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1),(2),(3);
5 BEGIN;
6 SELECT * FROM t1 FOR UPDATE;
7 id
8 1
9 2
10 3
11 SET DEBUG_SYNC =
12 'all_locks_iterator_found_record_lock SIGNAL found WAIT_FOR resized';
13 SELECT COUNT(1) FROM performance_schema.data_locks
14 WHERE object_name='t1'
15 AND engine='INNODB'
16 AND lock_mode='X'
17 AND lock_data='1'
18 AND lock_status='GRANTED';
19 SET DEBUG_SYNC = 'now WAIT_FOR found';
20 set global innodb_adaptive_hash_index=ON;
21 select @@innodb_buffer_pool_size;
22 @@innodb_buffer_pool_size
23 8388608
24 set global innodb_buffer_pool_size = @old_innodb_buffer_pool_size*3;
25 SET DEBUG_SYNC = 'now SIGNAL resized';
26 COUNT(1)
27 1
28 DROP TABLE t1;