******************** Resource Usage Report for pm1 ********************
 
 
-- Shared Memory --
 
################# ipcs -l #################
 

------ Messages Limits --------
max queues system wide = 32000
max size of message (bytes) = 8192
default max size of queue (bytes) = 16384

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 18014398509465599
max total shared memory (kbytes) = 18014398442373116
min seg size (bytes) = 1

------ Semaphore Limits --------
max number of arrays = 32000
max semaphores per array = 32000
max semaphores system wide = 1024000000
max ops per semop call = 500
semaphore max value = 32767

################# /usr/local/mariadb/columnstore/bin/clearShm -n #################
 
PROC_STAT  : shm_key: -50331648; key_name: InfiniDB-shm-fd000000; size: 491520
SYS_STAT   : shm_key: -67108864; key_name: InfiniDB-shm-fc000000; size: 157696
SW_STAT    : shm_key: -83886080; key_name: InfiniDB-shm-fb000000; size: 3080
NIC_STAT   : shm_key: -117440512; key_name: InfiniDB-shm-f9000000; size: 630784
DBROOT_STAT: shm_key: -134217728; key_name: InfiniDB-shm-f8000000; size: 1576960
PROC_STAT  : sem_key: -50331648; key_name: InfiniDB-shm-fd000000; size: 491520
SYS_STAT   : sem_key: -67108864; key_name: InfiniDB-shm-fc000000; size: 157696
SW_STAT    : sem_key: -83886080; key_name: InfiniDB-shm-fb000000; size: 3080
NIC_STAT   : sem_key: -117440512; key_name: InfiniDB-shm-f9000000; size: 630784
DBROOT_STAT: shm_key: -134217728; key_name: InfiniDB-shm-f8000000; size: 1576960
 
-- Disk Usage --
 
################# df -k #################
 
Filesystem     1K-blocks     Used Available Use% Mounted on
overlay         16888216 12164212   3734872  77% /
tmpfs            1024220        0   1024220   0% /dev
tmpfs            1024220        0   1024220   0% /sys/fs/cgroup
/dev/sda1       16888216 12164212   3734872  77% /etc/hosts
shm                65536     2820     62716   5% /dev/shm
tmpfs            1024220       12   1024208   1% /run/secrets/kubernetes.io/serviceaccount
 
-- Disk BRM Data files --
 
total 2112
-rw-rw-rw- 1 root root    4972 Aug 21 17:20 BRM_savesA_em
-rw-rw-rw- 1 root root    1788 Aug 21 17:20 BRM_savesA_vbbm
-rw-rw-rw- 1 root root    2672 Aug 21 17:20 BRM_savesA_vss
-rw-rw-rw- 1 root root    4588 Aug 21 17:18 BRM_savesB_em
-rw-rw-rw- 1 root root    1788 Aug 21 17:18 BRM_savesB_vbbm
-rw-rw-rw- 1 root root    2672 Aug 21 17:18 BRM_savesB_vss
-rw-rw-r-- 1 root root      64 Aug 21 17:57 BRM_saves_current
-rw-rw-rw- 1 root root    4972 Aug 21 17:56 BRM_saves_em
-rw-rw-rw- 1 root root       0 Aug 21 17:56 BRM_saves_journal
-rw-rw-rw- 1 root root      36 Aug 21 17:57 BRM_saves_vbbm
-rw-rw-rw- 1 root root       8 Aug 21 17:57 BRM_saves_vss
-rw-rw-r-- 1 root root      12 Aug 21 17:55 SMTxnID
-rw-rw-rw- 1 root root 2099204 Aug 21 17:18 oidbitmap
-rw-r--r-- 1 root root       4 Aug 21 17:20 tablelocks
################# cat /usr/local/mariadb/columnstore/data1/systemFiles/dbrm/BRM_saves_current #################
 
/usr/local/mariadb/columnstore/data1/systemFiles/dbrm/BRM_saves
 
-- View Table Locks --
 
################# cat bin/viewtablelock #################