Debian Codegraph @

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

raw
1 select @@global.innodb_page_hash_locks between 1 and 1024;
2 @@global.innodb_page_hash_locks between 1 and 1024
3 1
4 select @@global.innodb_page_hash_locks;
5 @@global.innodb_page_hash_locks
6 16
7 select @@session.innodb_page_hash_locks;
8 ERROR HY000: Variable 'innodb_page_hash_locks' is a GLOBAL variable
9 show global variables like 'innodb_page_hash_locks';
10 Variable_name Value
11 innodb_page_hash_locks 16
12 show session variables like 'innodb_page_hash_locks';
13 Variable_name Value
14 innodb_page_hash_locks 16
15 select * from performance_schema.global_variables where variable_name='innodb_page_hash_locks';
16 VARIABLE_NAME VARIABLE_VALUE
17 innodb_page_hash_locks 16
18 select * from performance_schema.session_variables where variable_name='innodb_page_hash_locks';
19 VARIABLE_NAME VARIABLE_VALUE
20 innodb_page_hash_locks 16
21 set global innodb_page_hash_locks=1;
22 ERROR HY000: Variable 'innodb_page_hash_locks' is a read only variable
23 set @@session.innodb_page_hash_locks='some';
24 ERROR HY000: Variable 'innodb_page_hash_locks' is a read only variable