1SELECT COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts); 2COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts) 31 41 Expected 5SET @@GLOBAL.innodb_adaptive_hash_index_parts=1; 6ERROR HY000: Variable 'innodb_adaptive_hash_index_parts' is a read only variable 7Expected error 'Read only variable' 8SELECT COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts); 9COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts) 101 111 Expected 12SELECT @@GLOBAL.innodb_adaptive_hash_index_parts = VARIABLE_VALUE 13FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 14WHERE VARIABLE_NAME='innodb_adaptive_hash_index_parts'; 15@@GLOBAL.innodb_adaptive_hash_index_parts = VARIABLE_VALUE 161 171 Expected 18SELECT COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts); 19COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts) 201 211 Expected 22SELECT COUNT(VARIABLE_VALUE) 23FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 24WHERE VARIABLE_NAME='innodb_adaptive_hash_index_parts'; 25COUNT(VARIABLE_VALUE) 261 271 Expected 28SELECT @@innodb_adaptive_hash_index_parts = @@GLOBAL.innodb_adaptive_hash_index_parts; 29@@innodb_adaptive_hash_index_parts = @@GLOBAL.innodb_adaptive_hash_index_parts 301 311 Expected 32SELECT COUNT(@@innodb_adaptive_hash_index_parts); 33COUNT(@@innodb_adaptive_hash_index_parts) 341 351 Expected 36SELECT COUNT(@@local.innodb_adaptive_hash_index_parts); 37ERROR HY000: Variable 'innodb_adaptive_hash_index_parts' is a GLOBAL variable 38Expected error 'Variable is a GLOBAL variable' 39SELECT COUNT(@@SESSION.innodb_adaptive_hash_index_parts); 40ERROR HY000: Variable 'innodb_adaptive_hash_index_parts' is a GLOBAL variable 41Expected error 'Variable is a GLOBAL variable' 42SELECT COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts); 43COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts) 441 451 Expected 46SELECT innodb_adaptive_hash_index_parts = @@SESSION.innodb_adaptive_hash_index_parts; 47ERROR 42S22: Unknown column 'innodb_adaptive_hash_index_parts' in 'field list' 48Expected error 'Readonly variable' 49