Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25447

MyRocks use "tmpdir" rather than using "rocksdb_tmpdir" for DDL operation

    XMLWordPrintable

    Details

      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

          Activity

            People

            Assignee:
            psergei Sergei Petrunia
            Reporter:
            pramod.mahto@mariadb.com Pramod Mahto
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: