1select @@global.skip_external_locking;
2@@global.skip_external_locking
31
4select @@session.skip_external_locking;
5ERROR HY000: Variable 'skip_external_locking' is a GLOBAL variable
6show global variables like 'skip_external_locking';
7Variable_name	Value
8skip_external_locking	ON
9show session variables like 'skip_external_locking';
10Variable_name	Value
11skip_external_locking	ON
12select * from information_schema.global_variables where variable_name='skip_external_locking';
13VARIABLE_NAME	VARIABLE_VALUE
14SKIP_EXTERNAL_LOCKING	ON
15select * from information_schema.session_variables where variable_name='skip_external_locking';
16VARIABLE_NAME	VARIABLE_VALUE
17SKIP_EXTERNAL_LOCKING	ON
18set global skip_external_locking=1;
19ERROR HY000: Variable 'skip_external_locking' is a read only variable
20set session skip_external_locking=1;
21ERROR HY000: Variable 'skip_external_locking' is a read only variable
22