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

columnstore_info.total_usage() returns irrelevant value

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.7
    • 1.1.7
    • ExeMgr
    • None
    • mcs installation on 1UM-1PM, CentOS7.5

    Description

      columnstore_info.total_usage() returns irrelevant value

      after loading 1TB data, columnstore_info.total_usage() returns
      TOTAL_DISK_USAGE of 34.01 GB
      while Disk usage on PM1 DBRoot 1 is 361G .

      on mcs installation from scratch on 2 mcs modules(1um-1pm), load 1 TB data
      get columnstore_info.total_usage()

      From PM1, the disk usage on DBRoot 1 :
      361G    /usr/local/mariadb/columnstore/data1
      

      MariaDB [(none)]> call columnstore_info.total_usage();
      +-----------------+------------------+
      | TOTAL_DATA_SIZE | TOTAL_DISK_USAGE |
      +-----------------+------------------+
      | 576.95 GB       | 34.01 GB         |
      +-----------------+------------------+
      1 row in set (4.81 sec)
       
      Query OK, 0 rows affected (4.81 sec)
      
      

      # mcsadmin getStorageConfig
      getstorageconfig   Thu Jan 24 11:12:21 2019
       
      System Storage Configuration
       
      Performance Module (DBRoot) Storage Type = internal
      System Assigned DBRoot Count = 1
      DBRoot IDs assigned to 'pm1' = 1
      
      

      # mcsadmin getSystemDisk
      getsystemdisk   Thu Jan 24 11:13:15 2019
       
      System Disk Usage per Module
       
      Module 'um1' Disk Usage (in 1K blocks)
       
      Mount Point                    Total Blocks  Used Blocks   Usage %
      -----------------------------  ------------  ------------  -------
      /                              51368960      43481300         85
       
      Module 'pm1' Disk Usage (in 1K blocks)
       
      Mount Point                    Total Blocks  Used Blocks   Usage %
      -----------------------------  ------------  ------------  -------
      /                              1072681984    398840712        38
       
      [root@pm1 ~]#
       
      
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              winstone Zdravelina Sokolovska (Inactive)
              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.