Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
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
-
Activity
| Transition | Time In Source Status | Execution Times |
|---|
|
4s | 1 |
|
108d 22h 56m | 1 |
|
3d 21h 44m | 1 |
|
9s | 1 |
|
53d 3h 32m | 1 |
|
170d 2h 34m | 2 |
|
14d 9h 50m | 1 |
|
19s | 2 |
|
28d 12h 10m | 1 |