blob: 28615264d35e2fcdd52541026b396daa7296a97f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
--source include/have_rocksdb.inc
--echo # If rocksdb_tmpdir is NULL or "", temporary file will be created in
--echo # server configuration variable location(--tmpdir)
CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=RocksDB;
show session variables like 'rocksdb_tmpdir';
--echo # Connection con1
connect (con1,localhost,root);
show session variables like 'rocksdb_tmpdir';
ALTER TABLE t1 ADD INDEX kb(b), ALGORITHM=INPLACE;
connection default;
disconnect con1;
DROP TABLE t1;
--echo # rocksdb_tmpdir with valid location.
CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=RocksDB;
set @tmpdir = @@global.tmpdir;
set global rocksdb_tmpdir = @tmpdir;
show session variables like 'rocksdb_tmpdir';
--echo # Connection con3
connect (con2,localhost,root);
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
show session variables like 'rocksdb_tmpdir';
ALTER TABLE t1 ADD INDEX kb(b), ALGORITHM=INPLACE;
disconnect con2;
connection default;
set global rocksdb_tmpdir=NULL;
DROP TABLE t1;
|