Debian Codegraph @

mysql-test/suite/perfschema/r/misc_session_status.result

raw
1 #
2 # MDEV-33150 double-locking of LOCK_thd_kill in performance_schema.session_status
3 #
4 set @old_innodb_io_capacity=@@global.innodb_io_capacity;
5 set @old_innodb_io_capacity_max=@@global.innodb_io_capacity_max;
6 select * from performance_schema.session_status limit 0;
7 VARIABLE_NAME VARIABLE_VALUE
8 set max_session_mem_used=32768;
9 select * from performance_schema.session_status;
10 set global innodb_io_capacity_max=100;
11 Warnings:
12 Warning 1210 Setting innodb_io_capacity_max 100 lower than innodb_io_capacity 200.
13 Warning 1210 Setting innodb_io_capacity to 100
14 set max_session_mem_used=default;
15 set global innodb_io_capacity=@old_innodb_io_capacity;
16 Warnings:
17 Warning 1210 Setting innodb_io_capacity to 200 higher than innodb_io_capacity_max 100
18 Warning 1210 Setting innodb_max_io_capacity to 400
19 set global innodb_io_capacity_max=@old_innodb_io_capacity_max;