mirror of
https://github.com/MariaDB/server.git
synced 2025-12-15 00:35:42 +01:00
24 lines
862 B
Text
24 lines
862 B
Text
#
|
|
# MDEV-37753 lock_sec_rec_some_has_impl() unnecessarily fetches history
|
|
#
|
|
CREATE TABLE t(a INT PRIMARY KEY, b TEXT, UNIQUE(b(1)))
|
|
ENGINE=InnoDB STATS_PERSISTENT=0;
|
|
connect purge_control,localhost,root,,;
|
|
START TRANSACTION WITH CONSISTENT SNAPSHOT;
|
|
connection default;
|
|
SET GLOBAL innodb_max_purge_lag_wait=1;
|
|
INSERT INTO t VALUES
|
|
(1,REPEAT('x',@@innodb_page_size/2)),(2,REPEAT('z',@@innodb_page_size/2));
|
|
DELETE FROM t;
|
|
SELECT variable_value INTO @reads
|
|
FROM information_schema.global_status
|
|
WHERE variable_name = 'INNODB_BUFFER_POOL_READ_REQUESTS';
|
|
INSERT INTO t VALUES(0,'y'),(1,'x'),(2,'z');
|
|
SELECT variable_value-@reads INTO @diff
|
|
FROM information_schema.global_status
|
|
WHERE variable_name = 'INNODB_BUFFER_POOL_READ_REQUESTS';
|
|
SELECT if(@diff between 22 and 26,'ok',@diff);
|
|
if(@diff between 22 and 26,'ok',@diff)
|
|
ok
|
|
disconnect purge_control;
|
|
DROP TABLE t;
|