Debian Codegraph @

mysql-test/suite/innodb/r/lock_memory.result

raw
1 #
2 # MDEV-28800 SIGABRT due to running out of memory for InnoDB locks
3 #
4 SET @save_ahi=@@GLOBAL.innodb_adaptive_hash_index;
5 SET GLOBAL innodb_adaptive_hash_index=OFF;
6 CREATE TABLE t1 (col1 INT) ENGINE=InnoDB;
7 INSERT INTO t1 VALUES (1),(2),(3),(4);
8 INSERT INTO t1 SELECT * FROM t1;
9 INSERT INTO t1 SELECT * FROM t1;
10 START TRANSACTION;
11 INSERT INTO t1 SELECT a.* FROM t1 a, t1 b, t1 c, t1 d;
12 SELECT CASE WHEN (POOL_SIZE - (FREE_BUFFERS + DATABASE_PAGES)) <= 10 THEN "PASSED"
13 ELSE (POOL_SIZE - (FREE_BUFFERS + DATABASE_PAGES)) END
14 FROM information_schema.innodb_buffer_pool_stats;
15 CASE WHEN (POOL_SIZE - (FREE_BUFFERS + DATABASE_PAGES)) <= 10 THEN "PASSED"
16 ELSE (POOL_SIZE - (FREE_BUFFERS + DATABASE_PAGES)) END
17 PASSED
18 COMMIT;
19 SELECT COUNT(*) FROM t1;
20 COUNT(*)
21 65552
22 DROP TABLE t1;
23 SET GLOBAL innodb_adaptive_hash_index=@save_ahi;