RDBMS/CUBRID & PostgreSQL
CUBRID 테이블 스페이스(볼륨) 사용량 확인하기
junsuyoun
2022. 11. 12. 21:46
728x90
반응형
CUBRID 테이블스페이라는 용어 대신 볼륨이라는 용어를 사용합니다.
10.x 버전 이상
[cub11.0.2.0291@689cae454053 ~]$ cubrid spacedb demodb@localhost
Space description for database 'demodb@localhost' with pagesize 16.0K. (log pagesize: 16.0K)
type purpose volume_count used_size free_size total_size
PERMANENT PERMANENT DATA 2 594.0 M 942.0 M 1.5 G
PERMANENT TEMPORARY DATA 0 0.0 M 0.0 M 0.0 M
TEMPORARY TEMPORARY DATA 0 0.0 M 0.0 M 0.0 M
- - 2 594.0 M 942.0 M 1.5 G
Space description for all volumes:
volid type purpose used_size free_size total_size volume_name
0 PERMANENT PERMANENT DATA 200.0 M 312.0 M 512.0 M /home/cub11.0.2.0291/CUBRID/databases/demodb/demodb
1 PERMANENT PERMANENT DATA 394.0 M 630.0 M 1.0 G /home/cub11.0.2.0291/CUBRID/databases/demodb/demodb_x001
LOB space description file:/home/cub11.0.2.0291/CUBRID/databases/demodb/lob
[cub11.0.2.0291@689cae454053 ~]$ cubrid spacedb -s demodb@localhost
Space description for database 'demodb@localhost' with pagesize 16.0K. (log pagesize: 16.0K)
type purpose volume_count used_size free_size total_size
PERMANENT PERMANENT DATA 2 594.0 M 942.0 M 1.5 G
PERMANENT TEMPORARY DATA 0 0.0 M 0.0 M 0.0 M
TEMPORARY TEMPORARY DATA 0 0.0 M 0.0 M 0.0 M
- - 2 594.0 M 942.0 M 1.5 G
[cub11.0.2.0291@689cae454053 ~]$ cubrid spacedb -sp demodb@localhost
Space description for database 'demodb@localhost' with pagesize 16.0K. (log pagesize: 16.0K)
type purpose volume_count used_size free_size total_size
PERMANENT PERMANENT DATA 2 594.0 M 942.0 M 1.5 G
PERMANENT TEMPORARY DATA 0 0.0 M 0.0 M 0.0 M
TEMPORARY TEMPORARY DATA 0 0.0 M 0.0 M 0.0 M
- - 2 594.0 M 942.0 M 1.5 G
Detailed space description for files:
data_type file_count used_size file_table_size reserved_size total_size
INDEX 28 124.4 M 0.4 M 24.2 M 149.0 M
HEAP 42 393.9 M 0.7 M 40.4 M 435.0 M
SYSTEM 8 0.4 M 0.1 M 7.5 M 8.0 M
TEMP 0 0.0 M 0.0 M 0.0 M 0.0 M
- 78 518.7 M 1.2 M 72.1 M 592.0 M
9.x 버전 이하
[cub9.3.9.0002@689cae454053 ~]$ cubrid spacedb demodb@localhost
Space description for database 'demodb@localhost' with pagesize 16.0K. (log pagesize: 16.0K)
Volid Purpose total_size free_size Vol Name
0 GENERIC 100.0 M 93.9 M /home/cub9.3.9.0002/CUBRID/databases/demodb/demodb
Space description for temporary volumes for database 'demodb@localhost' with pagesize 16.0K.
Volid Purpose total_size free_size Vol Name
LOB space description file:/home/cub9.3.9.0002/CUBRID/databases/demodb/lob
[cub9.3.9.0002@689cae454053 ~]$ cubrid spacedb -s demodb@localhost
Summarized space description for database 'demodb@localhost' with pagesize 16.0K. (log pagesize: 16.0K)
Purpose total_size used_size free_size volume_count
-------------------------------------------------------------
DATA 0.0 M 0.0 M 0.0 M 0
INDEX 0.0 M 0.0 M 0.0 M 0
GENERIC 100.0 M 6.1 M 93.9 M 1
TEMP 0.0 M 0.0 M 0.0 M 0
TEMP TEMP 0.0 M 0.0 M 0.0 M 0
-------------------------------------------------------------
TOTAL 100.0 M 6.1 M 93.9 M 1
[cub9.3.9.0002@689cae454053 ~]$ cubrid spacedb -sp demodb@localhost
Summarized space description for database 'demodb@localhost' with pagesize 16.0K. (log pagesize: 16.0K)
Purpose total_size used_size free_size data_size index_size temp_size volume_count
-------------------------------------------------------------------------------------------------
DATA 0.0 M 0.0 M 0.0 M 0.0 M 0.0 M 0.0 M 0
INDEX 0.0 M 0.0 M 0.0 M 0.0 M 0.0 M 0.0 M 0
GENERIC 100.0 M 6.1 M 93.9 M 3.4 M 2.7 M 0.0 M 1
TEMP 0.0 M 0.0 M 0.0 M 0.0 M 0.0 M 0.0 M 0
TEMP TEMP 0.0 M 0.0 M 0.0 M 0.0 M 0.0 M 0.0 M 0
-------------------------------------------------------------------------------------------------
TOTAL 100.0 M 6.1 M 93.9 M 3.4 M 2.7 M 0.0 M 1
728x90
반응형