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