mirror of
https://github.com/MariaDB/server.git
synced 2025-09-18 07:05:29 +02:00
311b4445c5
innodb.lock_memory: Allow the test to run with ./mtr --mysqld=--loose-innodb-adaptive-hash-index. main.row_filter_innodb,ahi: A new combination for innodb_adaptive_hash_index=ON.
33 lines
944 B
Text
33 lines
944 B
Text
--source include/have_innodb.inc
|
|
--source include/have_innodb_16k.inc
|
|
|
|
--echo #
|
|
--echo # MDEV-28800 SIGABRT due to running out of memory for InnoDB locks
|
|
--echo #
|
|
|
|
SET @save_ahi=@@GLOBAL.innodb_adaptive_hash_index;
|
|
SET GLOBAL innodb_adaptive_hash_index=OFF;
|
|
|
|
CREATE TABLE t1 (col1 INT) ENGINE=InnoDB;
|
|
|
|
INSERT INTO t1 VALUES (1),(2),(3),(4);
|
|
INSERT INTO t1 SELECT * FROM t1;
|
|
INSERT INTO t1 SELECT * FROM t1;
|
|
|
|
START TRANSACTION;
|
|
|
|
# Insert 64K records
|
|
INSERT INTO t1 SELECT a.* FROM t1 a, t1 b, t1 c, t1 d;
|
|
|
|
# The check needs to be adjusted if we start using more memory for locks. It
|
|
# needs 9 pages for 16k page size and we put the limit as 10.
|
|
SELECT CASE WHEN (POOL_SIZE - (FREE_BUFFERS + DATABASE_PAGES)) <= 10 THEN "PASSED"
|
|
ELSE (POOL_SIZE - (FREE_BUFFERS + DATABASE_PAGES)) END
|
|
FROM information_schema.innodb_buffer_pool_stats;
|
|
|
|
COMMIT;
|
|
|
|
SELECT COUNT(*) FROM t1;
|
|
|
|
DROP TABLE t1;
|
|
SET GLOBAL innodb_adaptive_hash_index=@save_ahi;
|