Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1668

CS doesn't reuse segment files whilst doing cpimport

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Not a Bug
    • Affects Version/s: 1.1.6
    • Fix Version/s: Icebox
    • Component/s: writeengine
    • Labels:
      None

      Description

      There was a one varchar(79) column table that was populated with cpimport. Every time I insert 7500000 records. I measured a number of segment files existed in the installation. Then I run DELETE from table_name and measued number of files again. Inserted another 7500000 records and measured the number of segment files. The number monotonically increased. Here is the bash log

      MariaDB [test]> create table `cs27`(`o_comment` varchar(79) default null) engine=columnstore default charset=latin1;
      Query OK, 0 rows affected (0.86 sec)
       
      root@c983d37cec14:/# find /usr/local/mariadb/columnstore/data1 -name 'FILE*' | wc -l
      43
       
      root@c983d37cec14:/# for i in $(seq 1 5); do cpimport -s '|'  test cs27 /git/orders_rows.tbl; done
       
      root@c983d37cec14:/# find /usr/local/mariadb/columnstore/data1 -name 'FILE*' | wc -l
      45
       
      MariaDB [test]> delete from cs27;
      Query OK, 7500000 rows affected (19.31 sec)
       
      root@c983d37cec14:/# for i in $(seq 1 5); do cpimport -s '|'  test cs27 /git/orders_rows.tbl; done
       
      root@c983d37cec14:/# find /usr/local/mariadb/columnstore/data1 -name 'FILE*' | wc -l
      47
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            drrtuy Roman
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.