mirror of
https://github.com/MariaDB/server.git
synced 2025-08-01 03:47:19 +03:00
6e6fcf4d43
The test fails trying to compare (innodb/lock)_row_lock_time_avg with some limit. We can't predict (innodb/lock)_row_lock_time_avg value, because it's counted as the whole waiting time divided by the amount of waits. Both waiting time and amount of waits depend on the previous tests execution. The corresponding counters in lock_sys can't be reset with any query. Remove (innodb/lock)_row_lock_time_avg comparision from the test. information_schema.global_status.innodb_row_lock_time can't be reset, compare its difference instead of absolute value. Reviewed by: Marko Mäkelä
47 lines
1.5 KiB
Plaintext
47 lines
1.5 KiB
Plaintext
CREATE TABLE `t`(`id` INT, PRIMARY KEY(`id`)) ENGINE=InnoDB STATS_PERSISTENT=0;
|
|
INSERT INTO t VALUES (1);
|
|
SET GLOBAL innodb_monitor_disable="lock_row_lock_time";
|
|
SET GLOBAL innodb_monitor_disable="lock_row_lock_time_max";
|
|
SET GLOBAL innodb_monitor_reset_all='lock_row_lock_time';
|
|
SET GLOBAL innodb_monitor_reset_all='lock_row_lock_time_max';
|
|
SET GLOBAL innodb_monitor_enable="lock_row_lock_time";
|
|
SET GLOBAL innodb_monitor_enable="lock_row_lock_time_max";
|
|
BEGIN;
|
|
SELECT * FROM t FOR UPDATE;
|
|
id
|
|
1
|
|
SELECT @innodb_row_lock_time_before := variable_value
|
|
FROM information_schema.global_status
|
|
WHERE LOWER(variable_name) = 'innodb_row_lock_time';
|
|
connect con1,localhost,root,,;
|
|
SET innodb_lock_wait_timeout = 1;
|
|
SELECT * FROM t FOR UPDATE;
|
|
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
|
|
disconnect con1;
|
|
connection default;
|
|
COMMIT;
|
|
SELECT variable_value - @innodb_row_lock_time_before > 100
|
|
FROM information_schema.global_status
|
|
WHERE LOWER(variable_name) = 'innodb_row_lock_time';
|
|
variable_value - @innodb_row_lock_time_before > 100
|
|
1
|
|
SELECT variable_value > 100
|
|
FROM information_schema.global_status
|
|
WHERE LOWER(variable_name) = 'innodb_row_lock_time_max';
|
|
variable_value > 100
|
|
1
|
|
SELECT count_reset > 100
|
|
FROM INFORMATION_SCHEMA.INNODB_METRICS
|
|
WHERE NAME='lock_row_lock_time';
|
|
count_reset > 100
|
|
1
|
|
SELECT count_reset > 100
|
|
FROM INFORMATION_SCHEMA.INNODB_METRICS
|
|
WHERE NAME='lock_row_lock_time_max';
|
|
count_reset > 100
|
|
1
|
|
DROP TABLE t;
|
|
SET GLOBAL innodb_monitor_enable=default;
|
|
SET GLOBAL innodb_monitor_disable=default;
|
|
SET GLOBAL innodb_monitor_reset_all=default;
|