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