Debian Codegraph @

mysql-test/suite/sys_vars/r/slave_load_tmpdir_basic.result

raw
1 select @@global.slave_load_tmpdir;
2 @@global.slave_load_tmpdir
3 MYSQL_TMP_DIR/mysqld.1
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';
7 Variable_name Value
8 slave_load_tmpdir MYSQL_TMP_DIR/mysqld.1
9 show session variables like 'slave_load_tmpdir';
10 Variable_name Value
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