Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
1.1.2
-
None
-
REHL 7
getsoftwareinfo Tue Mar 13 13:42:25 2018
Name : mariadb-columnstore-platform
Version : 1.1.2
Release : 1
Architecture: x86_64
Install Date: Wed 29 Nov 2017 11:33:08 AM EST
Group : Applications/Databases
Size : 113942794
License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
Signature : (none)
Source RPM : mariadb-columnstore-platform-1.1.2-1.src.rpm
Build Date : Thu 16 Nov 2017 10:20:27 AM ESTREHL 7 getsoftwareinfo Tue Mar 13 13:42:25 2018 Name : mariadb-columnstore-platform Version : 1.1.2 Release : 1 Architecture: x86_64 Install Date: Wed 29 Nov 2017 11:33:08 AM EST Group : Applications/Databases Size : 113942794 License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details. Signature : (none) Source RPM : mariadb-columnstore-platform-1.1.2-1.src.rpm Build Date : Thu 16 Nov 2017 10:20:27 AM EST
Description
While running a table_usage, I found that the total_usage is 0 even if data_disk_usage is in GB. The dictonary is of 0 (null) byte size. Not sure why (or a bug).
---------------------------------------------------------------------------------------
| TABLE_SCHEMA | TABLE_NAME | DATA_DISK_USAGE | DICT_DISK_USAGE | TOTAL_USAGE |
---------------------------------------------------------------------------------------
| e4genodebpm | eutrancellrelation_source_hourly | 2.10 GB | 0 Bytes | 0 Bytes |
---------------------------------------------------------------------------------------
1 row in set (6 min 30.54 sec)
If an "ifnull" is used in the total_usage, the output looks right
columnstore_info.format_filesize(data + ifnull(dict,0)) as TOTAL_USAGE
---------------------------------------------------------------------------------------
| TABLE_SCHEMA | TABLE_NAME | DATA_DISK_USAGE | DICT_DISK_USAGE | TOTAL_USAGE |
---------------------------------------------------------------------------------------
| e4genodebpm | eutrancellrelation_source_hourly | 2.10 GB | 0 Bytes | 2.10 GB |
---------------------------------------------------------------------------------------
1 row in set (10 min 25.25 sec)
Attached is an update of table_usage procedure.
Attachments
Issue Links
- duplicates
-
-
- Closed
-