Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.7
-
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
- relates to
-
-
- Closed
-