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