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

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 10.5, 10.2(EOL), 10.3(EOL), 10.4(EOL)
    • N/A
    • 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

          Activity

            People

              pramod.mahto@mariadb.com Pramod Mahto
              pramod.mahto@mariadb.com Pramod Mahto
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.