1
select @@global.slave_load_tmpdir;
2
@@global.slave_load_tmpdir
4
select @@session.slave_load_tmpdir;
5
ERROR HY000: Variable 'slave_load_tmpdir' is a GLOBAL variable
6
show global variables like 'slave_load_tmpdir';
8
slave_load_tmpdir MYSQL_TMP_DIR/mysqld.1
9
show session variables like 'slave_load_tmpdir';
11
slave_load_tmpdir MYSQL_TMP_DIR/mysqld.1
12
select * from information_schema.global_variables where variable_name='slave_load_tmpdir';
13
VARIABLE_NAME VARIABLE_VALUE
14
SLAVE_LOAD_TMPDIR MYSQL_TMP_DIR/mysqld.1
15
select * from information_schema.session_variables where variable_name='slave_load_tmpdir';
16
VARIABLE_NAME VARIABLE_VALUE
17
SLAVE_LOAD_TMPDIR MYSQL_TMP_DIR/mysqld.1
18
set global slave_load_tmpdir=1;
19
ERROR HY000: Variable 'slave_load_tmpdir' is a read only variable
20
set session slave_load_tmpdir=1;
21
ERROR HY000: Variable 'slave_load_tmpdir' is a read only variable