1select @@global.innodb_force_recovery_crash in (0, 1);
2@@global.innodb_force_recovery_crash in (0, 1)
31
4select @@global.innodb_force_recovery_crash;
5@@global.innodb_force_recovery_crash
60
7select @@session.innodb_force_recovery_crash;
8ERROR HY000: Variable 'innodb_force_recovery_crash' is a GLOBAL variable
9show global variables like 'innodb_force_recovery_crash';
10Variable_name	Value
11innodb_force_recovery_crash	0
12show session variables like 'innodb_force_recovery_crash';
13Variable_name	Value
14innodb_force_recovery_crash	0
15select * from information_schema.global_variables where variable_name='innodb_force_recovery_crash';
16VARIABLE_NAME	VARIABLE_VALUE
17INNODB_FORCE_RECOVERY_CRASH	0
18select * from information_schema.session_variables where variable_name='innodb_force_recovery_crash';
19VARIABLE_NAME	VARIABLE_VALUE
20INNODB_FORCE_RECOVERY_CRASH	0
21set global innodb_force_recovery_crash=1;
22ERROR HY000: Variable 'innodb_force_recovery_crash' is a read only variable
23set global innodb_force_recovery_crash=0;
24ERROR HY000: Variable 'innodb_force_recovery_crash' is a read only variable
25select @@global.innodb_force_recovery_crash;
26@@global.innodb_force_recovery_crash
270
28set session innodb_force_recovery_crash='some';
29ERROR HY000: Variable 'innodb_force_recovery_crash' is a read only variable
30set @@session.innodb_force_recovery_crash='some';
31ERROR HY000: Variable 'innodb_force_recovery_crash' is a read only variable
32set global innodb_force_recovery_crash='some';
33ERROR HY000: Variable 'innodb_force_recovery_crash' is a read only variable
34