Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.5, 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
While converting storage engine from InnoDB to ROCKSDB, even after changing rocksdb_tmpdir= <new_path_location> ,its using tmpdir = /tmp location.
|
|
For example :-
|
Server version: 10.5.9-6-MariaDB-enterprise-log MariaDB Enterprise Server
|
|
|
MariaDB [dev]> show session variables like '%tmpdir%';
|
+-------------------+----------------+
|
| Variable_name | Value |
|
+-------------------+----------------+
|
| innodb_tmpdir | /tmp/mysql_tmp |
|
| rocksdb_tmpdir | /tmp/mysql_tmp |
|
| slave_load_tmpdir | /tmp |
|
| tmpdir | /tmp |
|
+-------------------+----------------+
|
|
|
MariaDB [dev]> alter table tmp engine=ROCKSDB;
|
Query OK, 1200000 rows affected (3.067 sec)
|
Records: 1200000 Duplicates: 0 Warnings: 0
|
|
|
[root@master ~]# lsof +L1 /tmp
|
|
|
mariadbd 1265 mysql 33u REG 253,0 67108864 0 16802192 /tmp/myrocksjk5rpG (deleted)
|
|
Attachments
Issue Links
- relates to
-
MDEV-28485 make tmpdir a session modifiable variable
-
- Open
-