Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_max_purge_lag_delay_basic.result

raw
1 SELECT @@GLOBAL.innodb_max_purge_lag_delay;
2 @@GLOBAL.innodb_max_purge_lag_delay
3 0
4 0 Expected
5 SET @@GLOBAL.innodb_max_purge_lag_delay=1;
6 SELECT COUNT(@@GLOBAL.innodb_max_purge_lag_delay);
7 COUNT(@@GLOBAL.innodb_max_purge_lag_delay)
8 1
9 1 Expected
10 SELECT VARIABLE_VALUE
11 FROM performance_schema.global_variables
12 WHERE VARIABLE_NAME='innodb_max_purge_lag_delay';
13 VARIABLE_VALUE
14 1
15 1 Expected
16 SELECT @@innodb_max_purge_lag_delay = @@GLOBAL.innodb_max_purge_lag_delay;
17 @@innodb_max_purge_lag_delay = @@GLOBAL.innodb_max_purge_lag_delay
18 1
19 1 Expected
20 SELECT COUNT(@@innodb_max_purge_lag_delay);
21 COUNT(@@innodb_max_purge_lag_delay)
22 1
23 1 Expected
24 SELECT COUNT(@@local.innodb_max_purge_lag_delay);
25 ERROR HY000: Variable 'innodb_max_purge_lag_delay' is a GLOBAL variable
26 Expected error 'Variable is a GLOBAL variable'
27 SELECT COUNT(@@SESSION.innodb_max_purge_lag_delay);
28 ERROR HY000: Variable 'innodb_max_purge_lag_delay' is a GLOBAL variable
29 Expected error 'Variable is a GLOBAL variable'
30 SELECT innodb_max_purge_lag_delay;
31 ERROR 42S22: Unknown column 'innodb_max_purge_lag_delay' in 'field list'
32 set global innodb_max_purge_lag_delay = -1;
33 Warnings:
34 Warning 1292 Truncated incorrect innodb_max_purge_lag_delay value: '-1'
35 set global innodb_max_purge_lag_delay = 1000000;
36 set global innodb_max_purge_lag_delay = 10000000;
37 set global innodb_max_purge_lag_delay = 100000000;
38 Warnings:
39 Warning 1292 Truncated incorrect innodb_max_purge_lag_delay value: '100000000'
40 set global innodb_max_purge_lag_delay = 100000001;
41 Warnings:
42 Warning 1292 Truncated incorrect innodb_max_purge_lag_delay value: '100000001'
43 set global innodb_max_purge_lag_delay = 0;