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

Total Disk Usage is too high with replication

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.1.2
    • Icebox
    • cpimport
    • None
    • Red Hat Linux

    Description

      getsoftwareinfo Fri Jan 26 12:03:05 2018

      Name : mariadb-columnstore-platform
      Version : 1.1.2
      Release : 1
      Architecture: x86_64
      Install Date: Wed 29 Nov 2017 11:36:25 AM EST
      Group : Applications/Databases
      Size : 113942794

      Table "A" having ~85K rows and 134 columns (majority float) with replication of 2 (glusterfs), took ~9GB disk size. I've around hundred tables similar to this.

      TOTAL_DATA_SIZE : 17.17 GB
      TOTAL_DISK_USAGE : 778.97 GB (This cannot be true)
      Compression Ratio : 4428.4900%

      df -h show too much disk usage as well.
      Size: 493G
      Used: 325G
      Avail: 143G
      Use%: 70%

      Same table and data on a lower version (software details below) took only 200 MB disk size.
      getsoftwareinfo Fri Jan 26 12:22:14 2018

      Name : mariadb-columnstore-platform
      Version : 1.0.7
      Release : 1
      Architecture: x86_64
      Install Date: Tue 14 Mar 2017 05:59:14 PM EDT
      Group : Applications/Databases
      Size : 10013744

      Attachments

        Activity

          People

            LinuxJedi Andrew Hutchings (Inactive)
            bobypeter BOBY PETER
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.