 
******************** Configuration/Status Report for um1 ********************
 
-- chkconfig configuration --
 
################# chkconfig --list | grep columnstore #################
 
################# chkconfig --list | grep mysql-Columnstore #################
 
-- systemctl configuration --
 
################# systemctl list-unit-files --type=service | grep columnstore #################
 
columnstore.service                           enabled 
################# systemctl list-unit-files --type=service | grep mysql-Columnstore #################
 
 
-- fstab Configuration --
 
################# cat /etc/fstab #################
 

#
# /etc/fstab
# Created by anaconda on Mon Nov 20 18:12:53 2017
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/centos-root /                       xfs     defaults        0 0
UUID=5238c7cd-313a-4ece-bfb4-4375181ee9a9 /boot                   xfs     defaults        0 0
/dev/mapper/centos-home /home                   xfs     defaults        0 0
/dev/mapper/centos-swap swap                    swap    defaults        0 0
/swapfileadd swap                               swap    defaults        0 0
/swapfileadd2 swap                              swap    defaults        0 0
/var/log/mariadb/columnstore /home/mariadbope/log    none    bind            0 0
/usr/local/mariadb/columnstore/data/bulk/log /home/mariadbope/bulk_log none    bind            0 0
/var/log/mariadb/columnstore/archive /home/mariadbope/archive_log    none    bind            0 0
 
-- Server Processes --
 
################# ps axu #################
 
USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
root         1  0.0  0.0  43684  2772 ?        Ss    2019  10:01 /usr/lib/systemd/systemd --system --deserialize 20
root         2  0.0  0.0      0     0 ?        S     2019   0:02 [kthreadd]
root         3  0.0  0.0      0     0 ?        S     2019   8:34 [ksoftirqd/0]
root         5  0.0  0.0      0     0 ?        S<    2019   0:00 [kworker/0:0H]
root         7  0.0  0.0      0     0 ?        S     2019   6:36 [migration/0]
root         8  0.0  0.0      0     0 ?        S     2019   0:00 [rcu_bh]
root         9  0.0  0.0      0     0 ?        S     2019 193:05 [rcu_sched]
root        10  0.0  0.0      0     0 ?        S     2019   0:50 [watchdog/0]
root        11  0.0  0.0      0     0 ?        S     2019   0:52 [watchdog/1]
root        12  0.0  0.0      0     0 ?        S     2019   5:54 [migration/1]
root        13  0.0  0.0      0     0 ?        S     2019   8:33 [ksoftirqd/1]
root        15  0.0  0.0      0     0 ?        S<    2019   0:00 [kworker/1:0H]
root        16  0.0  0.0      0     0 ?        S     2019   0:49 [watchdog/2]
root        17  0.0  0.0      0     0 ?        S     2019   6:39 [migration/2]
root        18  0.0  0.0      0     0 ?        S     2019   8:25 [ksoftirqd/2]
root        20  0.0  0.0      0     0 ?        S<    2019   0:00 [kworker/2:0H]
root        21  0.0  0.0      0     0 ?        S     2019   0:50 [watchdog/3]
root        22  0.0  0.0      0     0 ?        S     2019   6:46 [migration/3]
root        23  0.0  0.0      0     0 ?        S     2019   7:56 [ksoftirqd/3]
root        25  0.0  0.0      0     0 ?        S<    2019   0:00 [kworker/3:0H]
root        26  0.0  0.0      0     0 ?        S     2019   0:48 [watchdog/4]
root        27  0.0  0.0      0     0 ?        S     2019   6:01 [migration/4]
root        28  0.0  0.0      0     0 ?        S     2019   6:18 [ksoftirqd/4]
root        30  0.0  0.0      0     0 ?        S<    2019   0:00 [kworker/4:0H]
root        31  0.0  0.0      0     0 ?        S     2019   0:49 [watchdog/5]
root        32  0.0  0.0      0     0 ?        S     2019   5:58 [migration/5]
root        33  0.0  0.0      0     0 ?        S     2019   7:02 [ksoftirqd/5]
root        35  0.0  0.0      0     0 ?        S<    2019   0:00 [kworker/5:0H]
root        36  0.0  0.0      0     0 ?        S     2019   0:50 [watchdog/6]
root        37  0.0  0.0      0     0 ?        S     2019   5:17 [migration/6]
root        38  0.0  0.0      0     0 ?        S     2019   6:44 [ksoftirqd/6]
root        40  0.0  0.0      0     0 ?        S<    2019   0:00 [kworker/6:0H]
root        41  0.0  0.0      0     0 ?        S     2019   0:48 [watchdog/7]
root        42  0.0  0.0      0     0 ?        S     2019   5:16 [migration/7]
root        43  0.0  0.0      0     0 ?        S     2019   8:02 [ksoftirqd/7]
root        45  0.0  0.0      0     0 ?        S<    2019   0:00 [kworker/7:0H]
root        47  0.0  0.0      0     0 ?        S     2019   0:00 [kdevtmpfs]
root        48  0.0  0.0      0     0 ?        S<    2019   0:00 [netns]
root        49  0.0  0.0      0     0 ?        S     2019   0:08 [khungtaskd]
root        50  0.0  0.0      0     0 ?        S<    2019   0:00 [writeback]
root        51  0.0  0.0      0     0 ?        S<    2019   0:00 [kintegrityd]
root        52  0.0  0.0      0     0 ?        S<    2019   0:00 [bioset]
root        53  0.0  0.0      0     0 ?        S<    2019   0:00 [kblockd]
root        54  0.0  0.0      0     0 ?        S<    2019   0:00 [md]
root        60  0.0  0.0      0     0 ?        S     2019  36:45 [kswapd0]
root        61  0.0  0.0      0     0 ?        SN    2019   0:00 [ksmd]
root        63  0.0  0.0      0     0 ?        S<    2019   0:00 [crypto]
root        71  0.0  0.0      0     0 ?        S<    2019   0:00 [kthrotld]
root        74  0.0  0.0      0     0 ?        S<    2019   0:00 [kmpath_rdacd]
root        76  0.0  0.0      0     0 ?        S<    2019   0:00 [kpsmoused]
root        78  0.0  0.0      0     0 ?        S<    2019   0:00 [ipv6_addrconf]
root        98  0.0  0.0      0     0 ?        S<    2019   0:00 [deferwq]
root       131  0.0  0.0      0     0 ?        S     2019   0:18 [kauditd]
root       329  0.0  0.0      0     0 ?        S<    2019   0:00 [mpt_poll_0]
root       330  0.0  0.0      0     0 ?        S<    2019   0:00 [mpt/0]
root       333  0.0  0.0      0     0 ?        S<    2019   0:00 [ata_sff]
root       341  0.0  0.0      0     0 ?        S     2019   0:00 [scsi_eh_0]
root       342  0.0  0.0      0     0 ?        S<    2019   0:00 [scsi_tmf_0]
root       343  0.0  0.0      0     0 ?        S     2019   0:00 [scsi_eh_1]
root       344  0.0  0.0      0     0 ?        S<    2019   0:00 [scsi_tmf_1]
root       345  0.0  0.0      0     0 ?        S     2019   0:00 [scsi_eh_2]
root       346  0.0  0.0      0     0 ?        S<    2019   0:00 [scsi_tmf_2]
root       349  0.0  0.0      0     0 ?        S<    2019   0:00 [ttm_swap]
root       363  0.0  0.0      0     0 ?        S<    2019   0:23 [kworker/4:1H]
root       445  0.0  0.0      0     0 ?        S<    2019   0:00 [kdmflush]
root       446  0.0  0.0      0     0 ?        S<    2019   0:00 [bioset]
root       457  0.0  0.0      0     0 ?        S<    2019   0:00 [kdmflush]
root       458  0.0  0.0      0     0 ?        S<    2019   0:00 [bioset]
root       471  0.0  0.0      0     0 ?        S<    2019   0:00 [bioset]
root       472  0.0  0.0      0     0 ?        S<    2019   0:00 [xfsalloc]
root       473  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs_mru_cache]
root       474  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-buf/dm-0]
root       475  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-data/dm-0]
root       476  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-conv/dm-0]
root       477  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-cil/dm-0]
root       478  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-reclaim/dm-]
root       479  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-log/dm-0]
root       480  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-eofblocks/d]
root       481  0.0  0.0      0     0 ?        S     2019  49:02 [xfsaild/dm-0]
mysql      498  1.0  0.6 5488892 434928 ?      Sl   15:37   1:15 /usr/local/mariadb/columnstore/mysql//bin/mysqld --basedir=/usr/local/mariadb/columnstore/mysql/ --datadir=/usr/local/mariadb/columnstore/mysql/db --plugin-dir=/usr/local/mariadb/columnstore/mysql/lib/plugin --user=mysql --log-error=/usr/local/mariadb/columnstore/mysql/db/nvm002314.err --pid-file=/usr/local/mariadb/columnstore/mysql/db/nvm002314.pid --socket=/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock --port=3306
root       558  0.0  0.0  45668 13596 ?        Ss    2019  80:31 /usr/lib/systemd/systemd-journald
root       567  0.0  0.0 226036 13372 ?        Sl   15:38   0:03 /usr/local/mariadb/columnstore/bin/ServerMonitor
root       583  0.0  0.0 266312     0 ?        Ss    2019   0:00 /usr/sbin/lvmetad -f
root       590  0.0  0.0      0     0 ?        S<    2019   0:00 [rpciod]
root       591  0.0  0.0      0     0 ?        S<    2019   0:00 [xprtiod]
root       639  0.0  0.0 381600 48948 ?        Sl   15:38   0:03 /usr/local/mariadb/columnstore/bin/workernode DBRM_Worker2 fg
root       650  0.0  0.0      0     0 ?        S<    2019   0:00 [nfit]
root       669  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-buf/sda1]
root       670  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-data/sda1]
root       671  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-conv/sda1]
root       672  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-cil/sda1]
root       673  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-reclaim/sda]
root       674  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-log/sda1]
root       675  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-eofblocks/s]
root       676  0.0  0.0      0     0 ?        S     2019   0:00 [xfsaild/sda1]
root       713  0.0  0.0      0     0 ?        S<    2019   0:00 [edac-poller]
root       725  0.0  0.0      0     0 ?        S<    2019   0:00 [kdmflush]
root       726  0.0  0.0      0     0 ?        S<    2019   0:00 [bioset]
root       734  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-buf/dm-2]
root       735  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-data/dm-2]
root       736  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-conv/dm-2]
root       737  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-cil/dm-2]
root       738  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-reclaim/dm-]
root       739  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-log/dm-2]
root       740  0.0  0.0      0     0 ?        S<    2019   0:00 [xfs-eofblocks/d]
root       741  0.0  0.0      0     0 ?        S     2019   0:00 [xfsaild/dm-2]
root       743  0.0  0.0      0     0 ?        S<    2019   0:31 [kworker/1:1H]
root       744  0.0  0.0      0     0 ?        S<    2019   0:30 [kworker/0:1H]
root       771  0.0  0.0  55452   436 ?        S<sl  2019   0:58 /sbin/auditd
root       794  0.0  0.0 219676  1104 ?        Ss    2019   0:00 /usr/sbin/abrtd -d -s
dbus       796  0.0  0.0  26772  1152 ?        Ss    2019  12:04 /bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation
root       801  0.0  0.0 216996    96 ?        Ss    2019   1:40 /usr/bin/abrt-watch-log -F BUG: WARNING: at WARNING: CPU: INFO: possible recursive locking detected ernel BUG at list_del corruption list_add corruption do_IRQ: stack overflow: ear stack overflow (cur: eneral protection fault nable to handle kernel ouble fault: RTNL: assertion failed eek! page_mapcount(page) went negative! adness at NETDEV WATCHDOG ysctl table check failed : nobody cared IRQ handler type mismatch Machine Check Exception: Machine check events logged divide error: bounds: coprocessor segment overrun: invalid TSS: segment not present: invalid opcode: alignment check: stack segment: fpu exception: simd exception: iret exception: /var/log/messages -- /usr/bin/abrt-dump-oops -xtD
root       806  0.0  0.0  99608     0 ?        Ss    2019   0:00 /usr/bin/VGAuthService -s
libstor+   808  0.0  0.0   8532    32 ?        Ss    2019   0:24 /usr/bin/lsmd -d
root       810  0.0  0.0  25128   928 ?        Ss    2019   5:19 /usr/lib/systemd/systemd-logind
root       812  0.0  0.0 127888     4 ?        Ss    2019   0:00 /usr/sbin/smartd -n -q never
root       814  0.0  0.0   7480     4 ?        Ss    2019   0:00 /usr/sbin/gpm -m /dev/input/mice -t exps2
root       815  0.0  0.0 731280 11368 ?        Ssl   2019  42:35 /usr/sbin/rsyslogd -n
root       818  0.0  0.0   4340     4 ?        Ss    2019   0:00 /usr/sbin/acpid
root       820  0.0  0.0 305416  1508 ?        Ssl   2019 120:17 /usr/bin/vmtoolsd
root       821  0.0  0.0  21632   476 ?        Ss    2019  10:50 /usr/sbin/irqbalance --foreground
root       824  0.0  0.0      0     0 ?        S<    2019   0:22 [kworker/6:1H]
chrony     828  0.0  0.0 115640   732 ?        S     2019   0:07 /usr/sbin/chronyd
root       829  0.0  0.0 195040     0 ?        Ssl   2019   0:00 /usr/sbin/gssproxy -D
root       855  0.0  0.0  25856     0 ?        Ss    2019   0:00 /usr/sbin/atd -f
root       864  0.0  0.0 334524  1732 ?        Ssl   2019   2:25 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid
root       877  0.0  0.0      0     0 ?        S<    2019   0:46 [kworker/5:1H]
root       878  0.0  0.0      0     0 ?        S<    2019   0:26 [kworker/7:1H]
root       879  0.0  0.0      0     0 ?        S<    2019   0:29 [kworker/3:1H]
root       880  0.0  0.0 472412  2084 ?        Ssl   2019   5:41 /usr/sbin/NetworkManager --no-daemon
root       944  0.0  0.0 126288   444 ?        Ss    1月22   0:36 /usr/sbin/crond -n
root      1246  0.0  0.0 105996   352 ?        Ss    2019   0:00 /usr/sbin/sshd -D
root      1263  0.0  0.0  53212     4 ?        Ss    2019   0:00 /usr/sbin/vsftpd /etc/vsftpd/vsftpd.conf
root      1278  0.0  0.0 110044     8 tty1     Ss+   2019   0:00 /sbin/agetty --noclear tty1 linux
zabbix    1281  0.0  0.0  85328     4 ?        S     2019   0:00 /usr/sbin/zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf
zabbix    1285  0.3  0.0  85668  1564 ?        S     2019 764:37 /usr/sbin/zabbix_agentd: collector [idle 1 sec]
zabbix    1286  0.0  0.0  85516   900 ?        S     2019 110:25 /usr/sbin/zabbix_agentd: listener #1 [waiting for connection]
zabbix    1287  0.0  0.0  85516   900 ?        S     2019 103:42 /usr/sbin/zabbix_agentd: listener #2 [waiting for connection]
zabbix    1288  0.0  0.0  85516   900 ?        S     2019 106:52 /usr/sbin/zabbix_agentd: listener #3 [waiting for connection]
zabbix    1289  0.1  0.0  86648  1128 ?        S     2019 240:18 /usr/sbin/zabbix_agentd: active checks #1 [idle 1 sec]
root      1382  0.0  0.0  92284   224 ?        Ss    2019   0:28 /usr/libexec/postfix/master -w
postfix   1384  0.0  0.0  92564   504 ?        S     2019   0:06 qmgr -l -t unix -u
root      2046  0.0  0.0      0     0 ?        S<    2019   0:29 [kworker/2:1H]
root      3288  0.0  0.0      0     0 ?        S    11:06   0:00 [kworker/u16:0]
root      3683  0.0  0.0   8040     0 ?        Ss    1月22   0:00 /NETMRDS/COM/rdstcpsvc
root      3689  0.0  0.0  11096   460 ?        Ss    1月22   1:17 /NETMRDS/COM/rdsocket
root      3691  0.0  0.0   2456   352 ?        S     1月22   0:43 /NETMRDS/COM/rdsregular
root      3694  0.0  0.0   2416    92 ?        Ss    1月22   1:39 /NETMRDS/COM/rdsdaemon
root      3699  0.0  0.0 113692  1124 ?        S     1月22  65:34 /bin/sh /NETMRDS/COM/rdssnde
root      3946  0.0  0.0      0     0 ?        S    12:09   0:00 [kworker/7:1]
root      6337  0.9  0.1 4712556 120540 ?      S<l  15:38   1:06 [ExeMgr]
root      6414  0.0  0.0 849908 30080 ?        Sl   15:38   0:01 [DDLProc]
root      6541  0.1  0.0 920564 49080 ?        Sl   15:38   0:12 [DMLProc]
postfix   6587  0.0  0.0  92524  4168 ?        S    16:41   0:00 pickup -l -t unix -u
root      6728  0.0  0.0      0     0 ?        S    11:30   0:00 [kworker/2:2]
root      7483  0.0  0.0      0     0 ?        S     3月21   0:08 [kworker/2:0]
root      8274  0.0  0.0      0     0 ?        S    15:22   0:00 [kworker/1:1]
root      8396  0.0  0.0      0     0 ?        S    15:22   0:00 [kworker/4:0]
root     11266  0.0  0.0      0     0 ?        S    17:27   0:00 [kworker/5:1]
root     19621  0.0  0.0      0     0 ?        S    17:32   0:00 [kworker/5:2]
root     19638  0.0  0.0      0     0 ?        S    14:48   0:00 [kworker/1:0]
root     19718  0.0  0.0      0     0 ?        S    17:32   0:00 [kworker/0:2]
root     21149  0.0  0.0      0     0 ?        S<    1月22   0:00 [loop0]
root     22690  0.0  0.0      0     0 ?        S     3月22   0:00 [kworker/6:2]
root     23369  0.0  0.0 156828  5928 ?        Ss   15:31   0:00 sshd: root@pts/1
root     23491  0.0  0.0 116904  3488 pts/1    Ss   15:31   0:00 -bash
root     24273  0.0  0.0      0     0 ?        S    09:12   0:12 [kworker/0:0]
root     24650  0.0  0.0      0     0 ?        S     3月17   0:11 [kworker/6:1]
root     25162  0.0  0.0      0     0 ?        S    11:41   0:00 [kworker/3:1]
root     25423  0.0  0.0      0     0 ?        S    05:39   0:00 [kworker/u16:1]
root     26333  0.0  0.0      0     0 ?        S     3月21   0:03 [kworker/7:2]
root     27250  0.0  0.0      0     0 ?        S    17:37   0:00 [kworker/0:1]
root     27561  0.0  0.0      0     0 ?        S    17:16   0:00 [kworker/5:0]
root     28551  1.1  0.0 330972 12852 pts/1    Sl+  17:38   0:00 /usr/local/mariadb/columnstore/bin/columnstoreSupport -a -p Mt-fuji3776m
root     28599  0.2  0.0 345796  6284 ?        Sl   17:38   0:00 /usr/sbin/abrt-dbus -t133
root     29303  0.0  0.0      0     0 ?        S    17:39   0:00 [kworker/4:1]
root     29510  0.0  0.0      0     0 ?        S    17:39   0:00 [kworker/1:2]
root     29656  0.0  0.0 107956   616 ?        S    17:39   0:00 /bin/sleep 3
root     29673  1.0  0.0 133528  2568 pts/1    Sl+  17:39   0:00 /usr/bin/expect /usr/local/mariadb/columnstore/bin/remote_command.sh 192.168.0.106 Mt-fuji3776m . /etc/profile.d/columnstoreAlias.sh;/usr/local/mariadb/columnstore/bin/configReport.sh pm4 /usr/local/mariadb/columnstore 0 - forcetty
root     29681  4.0  0.0 117024  3404 pts/3    Ss   17:39   0:00 /bin/bash
root     29733  2.0  0.0 180528  4560 pts/3    S+   17:39   0:00 ssh -v -t root@192.168.0.106 . /etc/profile.d/columnstoreAlias.sh;/usr/local/mariadb/columnstore/bin/configReport.sh pm4 /usr/local/mariadb/columnstore
root     29824  0.0  0.0 133528  2564 pts/1    Sl+  17:39   0:00 /usr/bin/expect /usr/local/mariadb/columnstore/bin/remote_command.sh 192.168.0.104 Mt-fuji3776m . /etc/profile.d/columnstoreAlias.sh;/usr/local/mariadb/columnstore/bin/logReport.sh um2 /usr/local/mariadb/columnstore 0 - forcetty
root     29838  0.0  0.0 117024  3404 pts/4    Ss   17:39   0:00 /bin/bash
root     29848  0.0  0.0 113184  1488 pts/1    S+   17:39   0:00 /bin/bash /usr/local/mariadb/columnstore/bin/configReport.sh um1 /usr/local/mariadb/columnstore
root     29889  0.0  0.0 180528  4556 pts/4    S+   17:39   0:00 ssh -v -t root@192.168.0.104 . /etc/profile.d/columnstoreAlias.sh;/usr/local/mariadb/columnstore/bin/logReport.sh um2 /usr/local/mariadb/columnstore
root     29895  0.0  0.0 155332  1880 pts/1    R+   17:39   0:00 ps axu
root     30287  0.0  0.0  44072     8 ?        Ss    1月22   0:00 /usr/lib/systemd/systemd-udevd
root     31021  0.0  0.0      0     0 ?        S    14:35   0:00 [kworker/3:0]
polkitd  31130  0.0  0.0 614296   964 ?        Ssl   1月22   1:59 /usr/lib/polkit-1/polkitd --no-debug
root     31184  0.0  0.0 564648   580 ?        Ssl   1月22  11:06 /usr/bin/python -Es /usr/sbin/tuned -l -P
root     31939  0.0  0.0 113180  1432 ?        S    15:37   0:00 /bin/bash /usr/local/mariadb/columnstore/bin/run.sh -l /tmp/columnstore_tmp_files /usr/local/mariadb/columnstore/bin/ProcMon
root     31940  0.1  0.0 583844 14052 ?        Sl   15:37   0:14 /usr/local/mariadb/columnstore/bin/ProcMon
root     32645  0.0  0.0      0     0 ?        S     3月22   0:04 [kworker/4:2]
root     32678  0.0  0.0 113316  1644 ?        S    15:37   0:00 /bin/sh /usr/local/mariadb/columnstore/mysql//bin/mysqld_safe --datadir=/usr/local/mariadb/columnstore/mysql/db --pid-file=/usr/local/mariadb/columnstore/mysql/db/nvm002314.pid --ledir=/usr/local/mariadb/columnstore/mysql//bin
 
-- Server Processes with resource usage --
 
################# top -b -n 1 #################
 
top - 17:39:10 up 140 days,  8:19,  1 user,  load average: 0.13, 0.12, 0.14
Tasks: 194 total,   1 running, 193 sleeping,   0 stopped,   0 zombie
%Cpu(s):  0.0 us,  0.8 sy,  0.0 ni, 99.2 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem : 65977356 total,  3531980 free,  1200200 used, 61245176 buff/cache
KiB Swap: 66060276 total, 64305600 free,  1754676 used. 62622840 avail Mem 

  PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND
29824 root      20   0  133528   2564   1920 S   6.7  0.0   0:00.01 remote_com+
    1 root      20   0   43684   2772   1488 S   0.0  0.0  10:01.98 systemd
    2 root      20   0       0      0      0 S   0.0  0.0   0:02.65 kthreadd
    3 root      20   0       0      0      0 S   0.0  0.0   8:34.25 ksoftirqd/0
    5 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/0:+
    7 root      rt   0       0      0      0 S   0.0  0.0   6:36.34 migration/0
    8 root      20   0       0      0      0 S   0.0  0.0   0:00.00 rcu_bh
    9 root      20   0       0      0      0 S   0.0  0.0 193:05.26 rcu_sched
   10 root      rt   0       0      0      0 S   0.0  0.0   0:50.35 watchdog/0
   11 root      rt   0       0      0      0 S   0.0  0.0   0:52.25 watchdog/1
   12 root      rt   0       0      0      0 S   0.0  0.0   5:54.03 migration/1
   13 root      20   0       0      0      0 S   0.0  0.0   8:33.25 ksoftirqd/1
   15 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/1:+
   16 root      rt   0       0      0      0 S   0.0  0.0   0:49.96 watchdog/2
   17 root      rt   0       0      0      0 S   0.0  0.0   6:39.70 migration/2
   18 root      20   0       0      0      0 S   0.0  0.0   8:25.60 ksoftirqd/2
   20 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/2:+
   21 root      rt   0       0      0      0 S   0.0  0.0   0:50.12 watchdog/3
   22 root      rt   0       0      0      0 S   0.0  0.0   6:46.91 migration/3
   23 root      20   0       0      0      0 S   0.0  0.0   7:56.81 ksoftirqd/3
   25 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/3:+
   26 root      rt   0       0      0      0 S   0.0  0.0   0:48.22 watchdog/4
   27 root      rt   0       0      0      0 S   0.0  0.0   6:01.56 migration/4
   28 root      20   0       0      0      0 S   0.0  0.0   6:18.23 ksoftirqd/4
   30 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/4:+
   31 root      rt   0       0      0      0 S   0.0  0.0   0:49.98 watchdog/5
   32 root      rt   0       0      0      0 S   0.0  0.0   5:58.08 migration/5
   33 root      20   0       0      0      0 S   0.0  0.0   7:02.92 ksoftirqd/5
   35 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/5:+
   36 root      rt   0       0      0      0 S   0.0  0.0   0:50.13 watchdog/6
   37 root      rt   0       0      0      0 S   0.0  0.0   5:17.17 migration/6
   38 root      20   0       0      0      0 S   0.0  0.0   6:44.55 ksoftirqd/6
   40 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/6:+
   41 root      rt   0       0      0      0 S   0.0  0.0   0:48.79 watchdog/7
   42 root      rt   0       0      0      0 S   0.0  0.0   5:16.15 migration/7
   43 root      20   0       0      0      0 S   0.0  0.0   8:02.57 ksoftirqd/7
   45 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/7:+
   47 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kdevtmpfs
   48 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 netns
   49 root      20   0       0      0      0 S   0.0  0.0   0:08.49 khungtaskd
   50 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 writeback
   51 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kintegrityd
   52 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 bioset
   53 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kblockd
   54 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 md
   60 root      20   0       0      0      0 S   0.0  0.0  36:45.49 kswapd0
   61 root      25   5       0      0      0 S   0.0  0.0   0:00.00 ksmd
   63 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 crypto
   71 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kthrotld
   74 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kmpath_rda+
   76 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kpsmoused
   78 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ipv6_addrc+
   98 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 deferwq
  131 root      20   0       0      0      0 S   0.0  0.0   0:18.33 kauditd
  329 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 mpt_poll_0
  330 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 mpt/0
  333 root       0 -20       0      0      0 S   0.0  0.0   0:00.05 ata_sff
  341 root      20   0       0      0      0 S   0.0  0.0   0:00.00 scsi_eh_0
  342 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 scsi_tmf_0
  343 root      20   0       0      0      0 S   0.0  0.0   0:00.01 scsi_eh_1
  344 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 scsi_tmf_1
  345 root      20   0       0      0      0 S   0.0  0.0   0:00.03 scsi_eh_2
  346 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 scsi_tmf_2
  349 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ttm_swap
  363 root       0 -20       0      0      0 S   0.0  0.0   0:23.74 kworker/4:+
  445 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kdmflush
  446 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 bioset
  457 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kdmflush
  458 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 bioset
  471 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 bioset
  472 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfsalloc
  473 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs_mru_ca+
  474 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-buf/dm+
  475 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-data/d+
  476 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-conv/d+
  477 root       0 -20       0      0      0 S   0.0  0.0   0:00.03 xfs-cil/dm+
  478 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-reclai+
  479 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-log/dm+
  480 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-eofblo+
  481 root      20   0       0      0      0 S   0.0  0.0  49:02.22 xfsaild/dm+
  498 mysql     20   0 5488892 434928  23244 S   0.0  0.7   1:15.48 mysqld
  558 root      20   0   45668  13596  13216 S   0.0  0.0  80:31.20 systemd-jo+
  567 root      20   0  226036  13372   8868 S   0.0  0.0   0:03.67 ServerMoni+
  583 root      20   0  266312      0      0 S   0.0  0.0   0:00.00 lvmetad
  590 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 rpciod
  591 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xprtiod
  639 root      20   0  381600  48948  44740 S   0.0  0.1   0:03.83 workernode
  650 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 nfit
  669 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-buf/sd+
  670 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-data/s+
  671 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-conv/s+
  672 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-cil/sd+
  673 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-reclai+
  674 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-log/sd+
  675 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-eofblo+
  676 root      20   0       0      0      0 S   0.0  0.0   0:00.00 xfsaild/sd+
  713 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 edac-poller
  725 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kdmflush
  726 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 bioset
  734 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-buf/dm+
  735 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-data/d+
  736 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-conv/d+
  737 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-cil/dm+
  738 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-reclai+
  739 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-log/dm+
  740 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-eofblo+
  741 root      20   0       0      0      0 S   0.0  0.0   0:00.04 xfsaild/dm+
  743 root       0 -20       0      0      0 S   0.0  0.0   0:31.21 kworker/1:+
  744 root       0 -20       0      0      0 S   0.0  0.0   0:30.80 kworker/0:+
  771 root      16  -4   55452    436    324 S   0.0  0.0   0:58.27 auditd
  794 root      20   0  219676   1104    552 S   0.0  0.0   0:00.42 abrtd
  796 dbus      20   0   26772   1152    648 S   0.0  0.0  12:04.86 dbus-daemon
  801 root      20   0  216996     96     60 S   0.0  0.0   1:40.83 abrt-watch+
  806 root      20   0   99608      0      0 S   0.0  0.0   0:00.00 VGAuthServ+
  808 libstor+  20   0    8532     32      0 S   0.0  0.0   0:24.75 lsmd
  810 root      20   0   25128    928    748 S   0.0  0.0   5:19.81 systemd-lo+
  812 root      20   0  127888      4      0 S   0.0  0.0   0:00.18 smartd
  814 root      20   0    7480      4      0 S   0.0  0.0   0:00.01 gpm
  815 root      20   0  731280  11368   9736 S   0.0  0.0  42:35.09 rsyslogd
  818 root      20   0    4340      4      0 S   0.0  0.0   0:00.00 acpid
  820 root      20   0  305416   1508   1152 S   0.0  0.0 120:17.58 vmtoolsd
  821 root      20   0   21632    476    296 S   0.0  0.0  10:50.63 irqbalance
  824 root       0 -20       0      0      0 S   0.0  0.0   0:22.77 kworker/6:+
  828 chrony    20   0  115640    732    548 S   0.0  0.0   0:07.33 chronyd
  829 root      20   0  195040      0      0 S   0.0  0.0   0:00.00 gssproxy
  855 root      20   0   25856      0      0 S   0.0  0.0   0:00.10 atd
  864 root      20   0  334524   1732    720 S   0.0  0.0   2:25.03 firewalld
  877 root       0 -20       0      0      0 S   0.0  0.0   0:46.35 kworker/5:+
  878 root       0 -20       0      0      0 S   0.0  0.0   0:26.73 kworker/7:+
  879 root       0 -20       0      0      0 S   0.0  0.0   0:29.09 kworker/3:+
  880 root      20   0  472412   2084   1160 S   0.0  0.0   5:41.61 NetworkMan+
  944 root      20   0  126288    444    336 S   0.0  0.0   0:36.54 crond
 1246 root      20   0  105996    352    252 S   0.0  0.0   0:00.46 sshd
 1263 root      20   0   53212      4      0 S   0.0  0.0   0:00.00 vsftpd
 1278 root      20   0  110044      8      4 S   0.0  0.0   0:00.00 agetty
 1281 zabbix    20   0   85328      4      0 S   0.0  0.0   0:00.00 zabbix_age+
 1285 zabbix    20   0   85668   1564   1304 S   0.0  0.0 764:37.03 zabbix_age+
 1286 zabbix    20   0   85516    900    700 S   0.0  0.0 110:25.59 zabbix_age+
 1287 zabbix    20   0   85516    900    700 S   0.0  0.0 103:42.20 zabbix_age+
 1288 zabbix    20   0   85516    900    700 S   0.0  0.0 106:52.84 zabbix_age+
 1289 zabbix    20   0   86648   1128    868 S   0.0  0.0 240:18.23 zabbix_age+
 1382 root      20   0   92284    224    148 S   0.0  0.0   0:28.55 master
 1384 postfix   20   0   92564    504    384 S   0.0  0.0   0:06.27 qmgr
 2046 root       0 -20       0      0      0 S   0.0  0.0   0:29.46 kworker/2:+
 3288 root      20   0       0      0      0 S   0.0  0.0   0:00.55 kworker/u1+
 3683 root      20   0    8040      0      0 S   0.0  0.0   0:00.00 rdstcpsvc
 3689 root      20   0   11096    460    376 S   0.0  0.0   1:17.63 rdsocket
 3691 root      20   0    2456    352    292 S   0.0  0.0   0:43.79 rdsregular
 3694 root      20   0    2416     92     60 S   0.0  0.0   1:39.25 rdsdaemon
 3699 root      20   0  113692   1124    452 S   0.0  0.0  65:34.84 rdssnde
 3946 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/7:1
 6337 root      19  -1 4712556 120540  21768 S   0.0  0.2   1:06.92 ExeMgr
 6414 root      20   0  849908  30080  21624 S   0.0  0.0   0:01.83 DDLProc
 6541 root      20   0  920564  49080  38280 S   0.0  0.1   0:12.19 DMLProc
 6587 postfix   20   0   92524   4168   3072 S   0.0  0.0   0:00.00 pickup
 6728 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/2:2
 7483 root      20   0       0      0      0 S   0.0  0.0   0:08.02 kworker/2:0
 8274 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/1:1
 8396 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/4:0
11266 root      20   0       0      0      0 S   0.0  0.0   0:00.01 kworker/5:1
19621 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/5:2
19638 root      20   0       0      0      0 S   0.0  0.0   0:00.22 kworker/1:0
19718 root      20   0       0      0      0 S   0.0  0.0   0:00.01 kworker/0:2
21149 root       0 -20       0      0      0 S   0.0  0.0   0:00.03 loop0
22690 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/6:2
23369 root      20   0  156828   5928   4600 S   0.0  0.0   0:00.06 sshd
23491 root      20   0  116904   3488   1736 S   0.0  0.0   0:00.05 bash
24273 root      20   0       0      0      0 S   0.0  0.0   0:12.62 kworker/0:0
24650 root      20   0       0      0      0 S   0.0  0.0   0:11.74 kworker/6:1
25162 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/3:1
25423 root      20   0       0      0      0 S   0.0  0.0   0:00.84 kworker/u1+
26333 root      20   0       0      0      0 S   0.0  0.0   0:03.33 kworker/7:2
27250 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/0:1
27561 root      20   0       0      0      0 S   0.0  0.0   0:00.01 kworker/5:0
28551 root      20   0  330972  12852   8616 S   0.0  0.0   0:00.11 columnstor+
28599 root      20   0  345796   6284   4332 S   0.0  0.0   0:00.02 abrt-dbus
29303 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/4:1
29510 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/1:2
29656 root      20   0  107956    616    520 S   0.0  0.0   0:00.00 sleep
29673 root      20   0  133528   2568   1920 S   0.0  0.0   0:00.01 remote_com+
29681 root      20   0  117024   3404   1636 S   0.0  0.0   0:00.04 bash
29733 root      20   0  180528   4560   3612 S   0.0  0.0   0:00.02 ssh
29838 root      20   0  117024   3404   1636 S   0.0  0.0   0:00.04 bash
29848 root      20   0  113184   1488   1264 S   0.0  0.0   0:00.00 configRepo+
29889 root      20   0  180528   4556   3612 S   0.0  0.0   0:00.02 ssh
29896 root      20   0  161984   2196   1532 R   0.0  0.0   0:00.00 top
30287 root      20   0   44072      8      4 S   0.0  0.0   0:00.01 systemd-ud+
31021 root      20   0       0      0      0 S   0.0  0.0   0:00.20 kworker/3:0
31130 polkitd   20   0  614296    964    568 S   0.0  0.0   1:59.20 polkitd
31184 root      20   0  564648    580     80 S   0.0  0.0  11:06.80 tuned
31939 root      20   0  113180   1432   1240 S   0.0  0.0   0:00.00 run.sh
31940 root      20   0  583844  14052   9124 S   0.0  0.0   0:14.61 ProcMon
32645 root      20   0       0      0      0 S   0.0  0.0   0:04.48 kworker/4:2
32678 root      20   0  113316   1644   1308 S   0.0  0.0   0:00.03 mysqld_safe
 
******************** System Network Configuration ********************
 
################# mcsadmin getSystemNetworkConfig ################# 
 

WARNING: running on non Parent OAM Module, can't make configuration changes in this session.
         Access Console from 'pm1' if you need to make changes.

getsystemnetworkconfig   Mon Mar 23 17:39:10 2020

System Network Configuration

Module Name    Module Description            NIC ID    Host Name         IP Address          
-----------    -------------------------     ------    -------------     ---------------     
um1            User Module #1                   1      nvm002314         192.168.0.101       
um2            User Module #2                   1      192.168.0.104     192.168.0.104       
pm1            Performance Module #1            1      nvm002315         192.168.0.102       
pm2            Performance Module #2            1      nvm002316         192.168.0.103       
pm3            Performance Module #3            1      nvm002980         192.168.0.105       
pm4            Performance Module #4            1      nvm002981         192.168.0.106       

 
******************** System Module Configure  ********************
 
################# mcsadmin getModuleTypeConfig ################# 
 

WARNING: running on non Parent OAM Module, can't make configuration changes in this session.
         Access Console from 'pm1' if you need to make changes.

getmoduletypeconfig   Mon Mar 23 17:39:10 2020

Module Type Configuration

ModuleType 'um' Configuration information

ModuleDesc = User Module
RunType = SIMPLEX
ModuleCount = 2
ModuleHostName and ModuleIPAddr for NIC ID 1 on  module 'um1' = nvm002314 , 192.168.0.101
ModuleHostName and ModuleIPAddr for NIC ID 1 on  module 'um2' = 192.168.0.104 , 192.168.0.104
ModuleCPUCriticalThreshold % = 0
ModuleCPUMajorThreshold % = 0
ModuleCPUMinorThreshold % = 0
ModuleCPUMinorClearThreshold % = 0
ModuleDiskCriticalThreshold % = 90
ModuleDiskMajorThreshold % = 80
ModuleDiskMinorThreshold % = 70
ModuleMemCriticalThreshold % = 90
ModuleMemMajorThreshold % = 0
ModuleMemMinorThreshold % = 0
ModuleSwapCriticalThreshold % = 90
ModuleSwapMajorThreshold % = 80
ModuleSwapMinorThreshold % = 70
ModuleDiskMonitorFileSystem#1 = /

ModuleType 'pm' Configuration information

ModuleDesc = Performance Module
RunType = SIMPLEX
ModuleCount = 4
ModuleHostName and ModuleIPAddr for NIC ID 1 on  module 'pm1' = nvm002315 , 192.168.0.102
ModuleHostName and ModuleIPAddr for NIC ID 1 on  module 'pm2' = nvm002316 , 192.168.0.103
ModuleHostName and ModuleIPAddr for NIC ID 1 on  module 'pm3' = nvm002980 , 192.168.0.105
ModuleHostName and ModuleIPAddr for NIC ID 1 on  module 'pm4' = nvm002981 , 192.168.0.106
DBRootIDs assigned to module 'pm1' = 1
DBRootIDs assigned to module 'pm2' = 2
DBRootIDs assigned to module 'pm3' = 3
DBRootIDs assigned to module 'pm4' = 4
ModuleCPUCriticalThreshold % = 0
ModuleCPUMajorThreshold % = 0
ModuleCPUMinorThreshold % = 0
ModuleCPUMinorClearThreshold % = 0
ModuleDiskCriticalThreshold % = 90
ModuleDiskMajorThreshold % = 80
ModuleDiskMinorThreshold % = 70
ModuleMemCriticalThreshold % = 90
ModuleMemMajorThreshold % = 0
ModuleMemMinorThreshold % = 0
ModuleSwapCriticalThreshold % = 90
ModuleSwapMajorThreshold % = 80
ModuleSwapMinorThreshold % = 70
ModuleDiskMonitorFileSystem#1 = /

 
******************** System Storage Configuration  ********************
 
################# mcsadmin getStorageConfig ################# 
 

WARNING: running on non Parent OAM Module, can't make configuration changes in this session.
         Access Console from 'pm1' if you need to make changes.

getstorageconfig   Mon Mar 23 17:39:10 2020

System Storage Configuration

Performance Module (DBRoot) Storage Type = external
System Assigned DBRoot Count = 4
DBRoot IDs assigned to 'pm1' = 1
DBRoot IDs assigned to 'pm2' = 2
DBRoot IDs assigned to 'pm3' = 3
DBRoot IDs assigned to 'pm4' = 4


 
******************** System Storage Status  ********************
 
################# mcsadmin getStorageStatus ################# 
 

WARNING: running on non Parent OAM Module, can't make configuration changes in this session.
         Access Console from 'pm1' if you need to make changes.

getstoragestatus   Mon Mar 23 17:39:11 2020
System External DBRoot Storage Statuses

Component     Status                       Last Status Change
------------  --------------------------   ------------------------
DBRoot #1     ACTIVE                       Mon Mar 23 15:37:55 2020
DBRoot #2     ACTIVE                       Mon Mar 23 15:38:10 2020
DBRoot #3     ACTIVE                       Mon Mar 23 15:38:15 2020
DBRoot #4     ACTIVE                       Mon Mar 23 15:38:20 2020

 
******************** System Status  ********************
 
################# mcsadmin getSystemInfo ################# 
 

WARNING: running on non Parent OAM Module, can't make configuration changes in this session.
         Access Console from 'pm1' if you need to make changes.

getsysteminfo   Mon Mar 23 17:39:11 2020

System columnstore-1

System and Module statuses

Component     Status                       Last Status Change
------------  --------------------------   ------------------------
System        ACTIVE                       Mon Mar 23 15:38:42 2020

Module um1    ACTIVE                       Mon Mar 23 15:38:39 2020
Module um2    ACTIVE                       Mon Mar 23 15:38:33 2020
Module pm1    ACTIVE                       Mon Mar 23 15:38:06 2020
Module pm2    ACTIVE                       Mon Mar 23 15:38:19 2020
Module pm3    ACTIVE                       Mon Mar 23 15:38:23 2020
Module pm4    ACTIVE                       Mon Mar 23 15:38:29 2020

Active Parent OAM Performance Module is 'pm1'
Primary Front-End MariaDB ColumnStore Module is 'um1'
MariaDB ColumnStore Replication Feature is enabled
MariaDB ColumnStore set for Distributed Install


MariaDB ColumnStore Process statuses

Process             Module    Status            Last Status Change        Process ID
------------------  ------    ---------------   ------------------------  ----------
ProcessMonitor      um1       ACTIVE            Mon Mar 23 15:37:46 2020       31940
ServerMonitor       um1       ACTIVE            Mon Mar 23 15:38:04 2020         567
DBRMWorkerNode      um1       ACTIVE            Mon Mar 23 15:38:05 2020         639
ExeMgr              um1       ACTIVE            Mon Mar 23 15:38:32 2020        6337
DDLProc             um1       ACTIVE            Mon Mar 23 15:38:36 2020        6414
DMLProc             um1       ACTIVE            Mon Mar 23 15:38:41 2020        6541
mysqld              um1       ACTIVE            Mon Mar 23 15:38:30 2020         498

ProcessMonitor      um2       ACTIVE            Mon Mar 23 15:37:45 2020       23910
ServerMonitor       um2       ACTIVE            Mon Mar 23 15:38:09 2020       24557
DBRMWorkerNode      um2       ACTIVE            Mon Mar 23 15:38:10 2020       24597
ExeMgr              um2       ACTIVE            Mon Mar 23 15:38:31 2020       28473
DDLProc             um2       COLD_STANDBY      Mon Mar 23 15:38:33 2020
DMLProc             um2       COLD_STANDBY      Mon Mar 23 15:38:33 2020
mysqld              um2       ACTIVE            Mon Mar 23 15:38:30 2020       24507

ProcessMonitor      pm1       ACTIVE            Mon Mar 23 15:37:30 2020         727
ProcessManager      pm1       ACTIVE            Mon Mar 23 15:37:36 2020        1310
DBRMControllerNode  pm1       ACTIVE            Mon Mar 23 15:38:00 2020        3130
ServerMonitor       pm1       ACTIVE            Mon Mar 23 15:38:02 2020        3184
DBRMWorkerNode      pm1       ACTIVE            Mon Mar 23 15:38:02 2020        3267
PrimProc            pm1       ACTIVE            Mon Mar 23 15:38:07 2020        3621
WriteEngineServer   pm1       ACTIVE            Mon Mar 23 15:38:07 2020        3704

ProcessMonitor      pm2       ACTIVE            Mon Mar 23 15:37:53 2020       13432
ProcessManager      pm2       HOT_STANDBY       Mon Mar 23 15:37:54 2020       13901
DBRMControllerNode  pm2       COLD_STANDBY      Mon Mar 23 15:38:10 2020
ServerMonitor       pm2       ACTIVE            Mon Mar 23 15:38:13 2020       14254
DBRMWorkerNode      pm2       ACTIVE            Mon Mar 23 15:38:15 2020       14314
PrimProc            pm2       ACTIVE            Mon Mar 23 15:38:19 2020       14374
WriteEngineServer   pm2       ACTIVE            Mon Mar 23 15:38:20 2020       14386

ProcessMonitor      pm3       ACTIVE            Mon Mar 23 15:37:53 2020       16686
ProcessManager      pm3       COLD_STANDBY      Mon Mar 23 15:38:15 2020
DBRMControllerNode  pm3       COLD_STANDBY      Mon Mar 23 15:38:15 2020
ServerMonitor       pm3       ACTIVE            Mon Mar 23 15:38:18 2020       17443
DBRMWorkerNode      pm3       ACTIVE            Mon Mar 23 15:38:20 2020       17502
PrimProc            pm3       ACTIVE            Mon Mar 23 15:38:24 2020       17571
WriteEngineServer   pm3       ACTIVE            Mon Mar 23 15:38:25 2020       17593

ProcessMonitor      pm4       ACTIVE            Mon Mar 23 15:37:52 2020       20402
ProcessManager      pm4       COLD_STANDBY      Mon Mar 23 15:38:20 2020
DBRMControllerNode  pm4       COLD_STANDBY      Mon Mar 23 15:38:20 2020
ServerMonitor       pm4       ACTIVE            Mon Mar 23 15:38:23 2020       21182
DBRMWorkerNode      pm4       ACTIVE            Mon Mar 23 15:38:25 2020       21236
PrimProc            pm4       ACTIVE            Mon Mar 23 15:38:29 2020       21277
WriteEngineServer   pm4       ACTIVE            Mon Mar 23 15:38:30 2020       21291

Active Alarm Counts: Critical = 26, Major = 0, Minor = 2, Warning = 0, Info = 0
 
******************** System Directories  ********************
 
################# mcsadmin getSystemDirectories ################# 
 

WARNING: running on non Parent OAM Module, can't make configuration changes in this session.
         Access Console from 'pm1' if you need to make changes.

getsystemdirectories   Mon Mar 23 17:39:11 2020

System Installation and Temporary File Directories

System Installation Directory = /usr/local/mariadb/columnstore
System Temporary File Directory = /tmp/columnstore_tmp_files

 
******************** System Configuration File  ********************
 
################# cat /etc/Columnstore.xml ################# 
 
<?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: Columnstore.xml 3713 2013-08-16 20:04:47Z wweeks $ -->
<!--
	WARNING: Do not make changes to this file unless directed to do so by
	MariaDB service engineers. Incorrect settings can render your system
	unusable and will require a service call to correct.
-->
<Columnstore Version="V1.0.0">
	<ExeMgr1>
		<IPAddr>192.168.0.101</IPAddr>
		<Port>8601</Port>
		<Module>um1</Module>
	</ExeMgr1>
	<JobProc>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8602</Port>
	</JobProc>
	<ProcMgr>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8603</Port>
	</ProcMgr>
	<ProcMgr_Alarm>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8606</Port>
	</ProcMgr_Alarm>
	<ProcStatusControl>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8604</Port>
	</ProcStatusControl>
	<ProcStatusControlStandby>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8605</Port>
	</ProcStatusControlStandby>
	<!-- Disabled
	<ProcHeartbeatControl>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8605</Port>
	</ProcHeartbeatControl>
	-->
	<!-- ProcessMonitor Port: 8800 - 8820 is reserved to support External Modules-->
	<localhost_ProcessMonitor>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8800</Port>
	</localhost_ProcessMonitor>
	<dm1_ProcessMonitor>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8800</Port>
	</dm1_ProcessMonitor>
	<um1_ProcessMonitor>
		<IPAddr>192.168.0.101</IPAddr>
		<Port>8800</Port>
	</um1_ProcessMonitor>
	<pm1_ProcessMonitor>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8800</Port>
	</pm1_ProcessMonitor>
	<dm1_ServerMonitor>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8622</Port>
	</dm1_ServerMonitor>
	<um1_ServerMonitor>
		<IPAddr>192.168.0.101</IPAddr>
		<Port>8622</Port>
	</um1_ServerMonitor>
	<pm1_ServerMonitor>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8622</Port>
	</pm1_ServerMonitor>
	<pm1_WriteEngineServer>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8630</Port>
	</pm1_WriteEngineServer>
	<DDLProc>
		<IPAddr>192.168.0.101</IPAddr>
		<Port>8612</Port>
	</DDLProc>
	<DMLProc>
		<IPAddr>192.168.0.101</IPAddr>
		<Port>8614</Port>
	</DMLProc>
	<BatchInsert>
		<RowsPerBatch>10000</RowsPerBatch>
	</BatchInsert>
	<PrimitiveServers>
		<Count>4</Count>
		<ConnectionsPerPrimProc>2</ConnectionsPerPrimProc>
		<ProcessorThreshold>128</ProcessorThreshold>
		<ProcessorQueueSize>10K</ProcessorQueueSize> <!-- minimum of extent size 8192 -->
		<DebugLevel>0</DebugLevel>
		<LBID_Shift>13</LBID_Shift>
		<ColScanBufferSizeBlocks>512</ColScanBufferSizeBlocks>
		<ColScanReadAheadBlocks>512</ColScanReadAheadBlocks> <!-- s/b factor of extent size 8192 -->
		<!-- <BPPCount>16</BPPCount> --> <!-- Default num cores * 2.  A cap on the number of simultaneous primitives per jobstep -->
		<PrefetchThreshold>1</PrefetchThreshold>
		<PTTrace>0</PTTrace>
		<RotatingDestination>y</RotatingDestination> <!-- Iterate thru UM ports; set to 'n' if UM/PM on same server -->
		<!-- <HighPriorityPercentage>60</HighPriorityPercentage> -->
		<!-- <MediumPriorityPercentage>30</MediumPriorityPercentage> -->
		<!-- <LowPriorityPercentage>10</LowPriorityPercentage> -->
		<DirectIO>y</DirectIO>
		<HighPriorityPercentage/>
		<MediumPriorityPercentage/>
		<LowPriorityPercentage/>
	</PrimitiveServers>
	<PMS1>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8620</Port>
	</PMS1>
	<PMS2>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8620</Port>
	</PMS2>
	<PMS3>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8620</Port>
	</PMS3>
	<PMS4>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8620</Port>
	</PMS4>
	<PMS5>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8620</Port>
	</PMS5>
	<PMS6>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8620</Port>
	</PMS6>
	<PMS7>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8620</Port>
	</PMS7>
	<PMS8>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8620</Port>
	</PMS8>
	<PMS9>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8620</Port>
	</PMS9>
	<PMS10>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8620</Port>
	</PMS10>
	<PMS11>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8620</Port>
	</PMS11>
	<PMS12>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8620</Port>
	</PMS12>
	<PMS13>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8620</Port>
	</PMS13>
	<PMS14>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8620</Port>
	</PMS14>
	<PMS15>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8620</Port>
	</PMS15>
	<PMS16>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8620</Port>
	</PMS16>
	<PMS17>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8620</Port>
	</PMS17>
	<PMS18>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8620</Port>
	</PMS18>
	<PMS19>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8620</Port>
	</PMS19>
	<PMS20>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8620</Port>
	</PMS20>
	<PMS21>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8620</Port>
	</PMS21>
	<PMS22>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8620</Port>
	</PMS22>
	<PMS23>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8620</Port>
	</PMS23>
	<PMS24>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8620</Port>
	</PMS24>
	<PMS25>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8620</Port>
	</PMS25>
	<PMS26>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8620</Port>
	</PMS26>
	<PMS27>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8620</Port>
	</PMS27>
	<PMS28>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8620</Port>
	</PMS28>
	<PMS29>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8620</Port>
	</PMS29>
	<PMS30>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8620</Port>
	</PMS30>
	<PMS31>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8620</Port>
	</PMS31>
	<PMS32>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8620</Port>
	</PMS32>
	<SystemConfig>
		<SystemLang>en_US.utf8</SystemLang>
		<SystemName>columnstore-1</SystemName>
		<ParentOAMModuleName>pm1</ParentOAMModuleName>
		<StandbyOAMModuleName>pm2</StandbyOAMModuleName>
		<PrimaryUMModuleName>um1</PrimaryUMModuleName>
		<ModuleHeartbeatPeriod>1</ModuleHeartbeatPeriod>
		<ModuleHeartbeatCount>3</ModuleHeartbeatCount>
		<ModuleProcMonWaitCount>12</ModuleProcMonWaitCount>	// 2.5 minutes
		<!-- Disabled
		<ProcessHeartbeatPeriod>-1</ProcessHeartbeatPeriod>
		-->
		<!-- Warning: Do not change this value once database is built -->
		<DBRootCount>4</DBRootCount>
		<DBRoot1>/usr/local/mariadb/columnstore/data1</DBRoot1>
		<DBRMRoot>$INSTALLDIR/data1/systemFiles/dbrm/BRM_saves</DBRMRoot>
		<TableLockSaveFile>$INSTALLDIR/data1/systemFiles/dbrm/tablelocks</TableLockSaveFile>
		<DBRMTimeOut>20</DBRMTimeOut> <!-- in seconds -->
		<DBRMSnapshotInterval>100000</DBRMSnapshotInterval>
		<ExternalCriticalThreshold>90</ExternalCriticalThreshold>
		<ExternalMajorThreshold>80</ExternalMajorThreshold>
		<ExternalMinorThreshold>70</ExternalMinorThreshold>
		<!-- <TempDiskPath>/tmp</TempDiskPath>
		<WorkingDir>/tmp</WorkingDir>
		<TempFileDir>/tmp/columnstore_tmp_files</TempFileDir>
		-->
		<TransactionArchivePeriod>10</TransactionArchivePeriod>
		<NMSIPAddress>0.0.0.0</NMSIPAddress>
		<TempSaveSize>128M</TempSaveSize> <!-- default SWSDL max element save size -->
		<WaitPeriod>10</WaitPeriod> <!-- in seconds -->
		<CalpontHome>$INSTALLDIR</CalpontHome>
		<ProcessRestartCount>10</ProcessRestartCount>
		<ProcessRestartPeriod>120</ProcessRestartPeriod>
		<SwapAction>restartSystem</SwapAction>	<!-- OAM command (or 'none') to run when swap space exceeds Major Threshold -->
		<ActivePmFailoverDisabled>n</ActivePmFailoverDisabled>
		<MemoryCheckPercent>95</MemoryCheckPercent> <!-- Max real memory to limit growth of buffers to -->
		<DataFileLog>OFF</DataFileLog>
		<!-- enable if you want to limit how much memory may be used for hdfs read/write memory buffers.
 		<hdfsRdwrBufferMaxSize>8G</hdfsRdwrBufferMaxSize>
		-->
 		<hdfsRdwrScratch>/rdwrscratch</hdfsRdwrScratch> <!-- Do not set to an hdfs file path -->
 		<TempFileDir>/columnstore_tmp_files</TempFileDir>
 		<SystemTempFileDir>/tmp/columnstore_tmp_files</SystemTempFileDir>
		<DBRoot2>/usr/local/mariadb/columnstore/data2</DBRoot2>
		<DBRoot3>/usr/local/mariadb/columnstore/data3</DBRoot3>
		<DBRoot4>/usr/local/mariadb/columnstore/data4</DBRoot4>
	</SystemConfig>
	<SystemModuleConfig>
		<ModuleType1>dm</ModuleType1>
		<ModuleDesc1>Director Module</ModuleDesc1>
		<RunType1>SIMPLEX</RunType1>
		<ModuleCount1>0</ModuleCount1>
		<ModuleIPAddr1-1-1>0.0.0.0</ModuleIPAddr1-1-1>
		<ModuleHostName1-1-1>unassigned</ModuleHostName1-1-1>
		<ModuleDisableState1-1>ENABLED</ModuleDisableState1-1>
		<ModuleCPUCriticalThreshold1>0</ModuleCPUCriticalThreshold1>
		<ModuleCPUMajorThreshold1>0</ModuleCPUMajorThreshold1>
		<ModuleCPUMinorThreshold1>0</ModuleCPUMinorThreshold1>
		<ModuleCPUMinorClearThreshold1>0</ModuleCPUMinorClearThreshold1>
		<ModuleDiskCriticalThreshold1>90</ModuleDiskCriticalThreshold1>
		<ModuleDiskMajorThreshold1>80</ModuleDiskMajorThreshold1>
		<ModuleDiskMinorThreshold1>70</ModuleDiskMinorThreshold1>
		<ModuleMemCriticalThreshold1>90</ModuleMemCriticalThreshold1>
		<ModuleMemMajorThreshold1>0</ModuleMemMajorThreshold1>
		<ModuleMemMinorThreshold1>0</ModuleMemMinorThreshold1>
		<ModuleSwapCriticalThreshold1>90</ModuleSwapCriticalThreshold1>
		<ModuleSwapMajorThreshold1>80</ModuleSwapMajorThreshold1>
		<ModuleSwapMinorThreshold1>70</ModuleSwapMinorThreshold1>
		<ModuleDiskMonitorFileSystem1-1>/</ModuleDiskMonitorFileSystem1-1>
		<ModuleDBRootCount1-1>unassigned</ModuleDBRootCount1-1>
		<ModuleDBRootID1-1-1>unassigned</ModuleDBRootID1-1-1>
		<ModuleType2>um</ModuleType2>
		<ModuleDesc2>User Module</ModuleDesc2>
		<RunType2>SIMPLEX</RunType2>
		<ModuleCount2>2</ModuleCount2>
		<ModuleIPAddr1-1-2>192.168.0.101</ModuleIPAddr1-1-2>
		<ModuleHostName1-1-2>nvm002314</ModuleHostName1-1-2>
		<ModuleDisableState1-2>ENABLED</ModuleDisableState1-2>
		<ModuleCPUCriticalThreshold2>0</ModuleCPUCriticalThreshold2>
		<ModuleCPUMajorThreshold2>0</ModuleCPUMajorThreshold2>
		<ModuleCPUMinorThreshold2>0</ModuleCPUMinorThreshold2>
		<ModuleCPUMinorClearThreshold2>0</ModuleCPUMinorClearThreshold2>
		<ModuleDiskCriticalThreshold2>90</ModuleDiskCriticalThreshold2>
		<ModuleDiskMajorThreshold2>80</ModuleDiskMajorThreshold2>
		<ModuleDiskMinorThreshold2>70</ModuleDiskMinorThreshold2>
		<ModuleMemCriticalThreshold2>90</ModuleMemCriticalThreshold2>
		<ModuleMemMajorThreshold2>0</ModuleMemMajorThreshold2>
		<ModuleMemMinorThreshold2>0</ModuleMemMinorThreshold2>
		<ModuleSwapCriticalThreshold2>90</ModuleSwapCriticalThreshold2>
		<ModuleSwapMajorThreshold2>80</ModuleSwapMajorThreshold2>
		<ModuleSwapMinorThreshold2>70</ModuleSwapMinorThreshold2>
		<ModuleDiskMonitorFileSystem1-2>/</ModuleDiskMonitorFileSystem1-2>	
		<ModuleDBRootCount1-2>unassigned</ModuleDBRootCount1-2>
		<ModuleDBRootID1-1-2>unassigned</ModuleDBRootID1-1-2>
		<ModuleType3>pm</ModuleType3>
		<ModuleDesc3>Performance Module</ModuleDesc3>
		<RunType3>SIMPLEX</RunType3>
		<ModuleCount3>4</ModuleCount3>
		<ModuleIPAddr1-1-3>192.168.0.102</ModuleIPAddr1-1-3>
		<ModuleHostName1-1-3>nvm002315</ModuleHostName1-1-3>
		<ModuleDisableState1-3>ENABLED</ModuleDisableState1-3>
		<ModuleCPUCriticalThreshold3>0</ModuleCPUCriticalThreshold3>
		<ModuleCPUMajorThreshold3>0</ModuleCPUMajorThreshold3>
		<ModuleCPUMinorThreshold3>0</ModuleCPUMinorThreshold3>
		<ModuleCPUMinorClearThreshold3>0</ModuleCPUMinorClearThreshold3>
		<ModuleDiskCriticalThreshold3>90</ModuleDiskCriticalThreshold3>
		<ModuleDiskMajorThreshold3>80</ModuleDiskMajorThreshold3>
		<ModuleDiskMinorThreshold3>70</ModuleDiskMinorThreshold3>
		<ModuleMemCriticalThreshold3>90</ModuleMemCriticalThreshold3>
		<ModuleMemMajorThreshold3>0</ModuleMemMajorThreshold3>
		<ModuleMemMinorThreshold3>0</ModuleMemMinorThreshold3>
		<ModuleSwapCriticalThreshold3>90</ModuleSwapCriticalThreshold3>
		<ModuleSwapMajorThreshold3>80</ModuleSwapMajorThreshold3>
		<ModuleSwapMinorThreshold3>70</ModuleSwapMinorThreshold3>
		<ModuleDiskMonitorFileSystem1-3>/</ModuleDiskMonitorFileSystem1-3>
		<ModuleDBRootCount1-3>1</ModuleDBRootCount1-3>
		<ModuleDBRootID1-1-3>1</ModuleDBRootID1-1-3>
		<ModuleDisableState2-2>ENABLED</ModuleDisableState2-2>
		<ModuleHostName2-1-2>192.168.0.104</ModuleHostName2-1-2>
		<ModuleIPAddr2-1-2>192.168.0.104</ModuleIPAddr2-1-2>
		<ModuleDBRootCount2-3>1</ModuleDBRootCount2-3>
		<ModuleDBRootID2-1-3>2</ModuleDBRootID2-1-3>
		<ModuleDBRootCount3-3>1</ModuleDBRootCount3-3>
		<ModuleDBRootID3-1-3>3</ModuleDBRootID3-1-3>
		<ModuleDBRootCount4-3>1</ModuleDBRootCount4-3>
		<ModuleDBRootID4-1-3>4</ModuleDBRootID4-1-3>
		<ModuleDisableState2-3>ENABLED</ModuleDisableState2-3>
		<ModuleHostName2-1-3>nvm002316</ModuleHostName2-1-3>
		<ModuleIPAddr2-1-3>192.168.0.103</ModuleIPAddr2-1-3>
		<ModuleDisableState3-3>ENABLED</ModuleDisableState3-3>
		<ModuleHostName3-1-3>nvm002980</ModuleHostName3-1-3>
		<ModuleIPAddr3-1-3>192.168.0.105</ModuleIPAddr3-1-3>
		<ModuleDisableState4-3>ENABLED</ModuleDisableState4-3>
		<ModuleHostName4-1-3>nvm002981</ModuleHostName4-1-3>
		<ModuleIPAddr4-1-3>192.168.0.106</ModuleIPAddr4-1-3>
		<ModuleHostName1-2-2>unassigned</ModuleHostName1-2-2>
		<ModuleIPAddr1-2-2>0.0.0.0</ModuleIPAddr1-2-2>
		<ModuleHostName2-2-2>unassigned</ModuleHostName2-2-2>
		<ModuleIPAddr2-2-2>0.0.0.0</ModuleIPAddr2-2-2>
		<ModuleHostName1-2-3>unassigned</ModuleHostName1-2-3>
		<ModuleIPAddr1-2-3>0.0.0.0</ModuleIPAddr1-2-3>
		<ModuleHostName2-2-3>unassigned</ModuleHostName2-2-3>
		<ModuleIPAddr2-2-3>0.0.0.0</ModuleIPAddr2-2-3>
		<ModuleHostName3-2-3>unassigned</ModuleHostName3-2-3>
		<ModuleIPAddr3-2-3>0.0.0.0</ModuleIPAddr3-2-3>
		<ModuleHostName4-2-3>unassigned</ModuleHostName4-2-3>
		<ModuleIPAddr4-2-3>0.0.0.0</ModuleIPAddr4-2-3>
	</SystemModuleConfig>
	<SystemExtDeviceConfig>
		<Count>0</Count>
		<Name1>unassigned</Name1>
		<IPAddr1>0.0.0.0</IPAddr1>
		<DisableState1>ENABLED</DisableState1>
	</SystemExtDeviceConfig>
	<SessionManager>
		<MaxConcurrentTransactions>1000</MaxConcurrentTransactions>
		<TxnIDFile>$INSTALLDIR/data1/systemFiles/dbrm/SMTxnID</TxnIDFile>
	</SessionManager>
	<VersionBuffer>
		<!-- VersionBufferFileSize must be a multiple of 8192.
		One version buffer file will be put on each DB root. -->
		<VersionBufferFileSize>2GB</VersionBufferFileSize>
	</VersionBuffer>
	<OIDManager>
		<!-- Do not change this file after database built	 -->
		<OIDBitmapFile>$INSTALLDIR/data1/systemFiles/dbrm/oidbitmap</OIDBitmapFile>
		<!-- Do not change this value after database built	 -->
		<FirstOID>3000</FirstOID>
	</OIDManager>
	<WriteEngine>
		<BulkRoot>$INSTALLDIR/data/bulk</BulkRoot>
		<BulkRollbackDir>$INSTALLDIR/data1/systemFiles/bulkRollback</BulkRollbackDir>
		<MaxFileSystemDiskUsagePct>98</MaxFileSystemDiskUsagePct>
		<CompressedPaddingBlocks>1</CompressedPaddingBlocks> <!-- Number of blocks used to pad compressed chunks -->
	</WriteEngine>
	<DBRM_Controller>
		<NumWorkers>6</NumWorkers>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8616</Port>
	</DBRM_Controller>
	<!-- Worker Port: 8700 - 8720 is reserved to support External Modules-->
	<DBRM_Worker1>
		<IPAddr>192.168.0.102</IPAddr>
		<Port>8700</Port>
		<Module>pm1</Module>
	</DBRM_Worker1>
	<DBRM_Worker2>
		<IPAddr>192.168.0.101</IPAddr>
		<Port>8700</Port>
		<Module>um1</Module>
	</DBRM_Worker2>
	<DBRM_Worker3>
		<IPAddr>192.168.0.104</IPAddr>
		<Port>8700</Port>
		<Module>um2</Module>
	</DBRM_Worker3>
	<DBRM_Worker4>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8700</Port>
		<Module>pm2</Module>
	</DBRM_Worker4>
	<DBRM_Worker5>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8700</Port>
		<Module>pm3</Module>
	</DBRM_Worker5>
	<DBRM_Worker6>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8700</Port>
		<Module>pm4</Module>
	</DBRM_Worker6>
	<DBRM_Worker7>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8700</Port>
		<Module>unassigned</Module>
	</DBRM_Worker7>
	<DBRM_Worker8>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8700</Port>
		<Module>unassigned</Module>
	</DBRM_Worker8>
	<DBRM_Worker9>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8700</Port>
		<Module>unassigned</Module>
	</DBRM_Worker9>
	<DBRM_Worker10>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8700</Port>
		<Module>unassigned</Module>
	</DBRM_Worker10>
	<DBBC>
		<!-- The percentage of RAM to use for the disk block cache. Defaults to 70% -->
        <!-- Alternatively, this can be specified in absolute terms using
             the suffixes 'm' or 'g' to denote size in megabytes or gigabytes.-->
		<!-- <NumBlocksPct>70</NumBlocksPct> -->
		<!-- <NumThreads>16</NumThreads> --> <!-- 1-256.  Default is 16. -->
		<NumCaches>1</NumCaches><!-- # of parallel caches to instantiate -->
		<IOMTracing>0</IOMTracing>
		<BRPTracing>0</BRPTracing>
		<ReportFrequency>65536</ReportFrequency>
		<MaxOpenFiles>2K</MaxOpenFiles>
		<DecreaseOpenFilesCount>200</DecreaseOpenFilesCount>
		<FDCacheTrace>0</FDCacheTrace>
		<NumBlocksPct>65</NumBlocksPct>
	</DBBC>
	<Installation>
		<SystemStartupOffline>n</SystemStartupOffline>
		<InitialInstallFlag>y</InitialInstallFlag>
		<SingleServerInstall>n</SingleServerInstall>
		<ServerTypeInstall>1</ServerTypeInstall>
		<PMwithUM>n</PMwithUM>
		<MySQLRep>y</MySQLRep>
		<DBRootStorageType>external</DBRootStorageType>
		<UMStorageType>internal</UMStorageType>
		<EEPackageType>rpm</EEPackageType>
		<SystemLogConfigFile>/etc/rsyslog.d/49-columnstore.conf</SystemLogConfigFile>
		<Cloud>disable</Cloud>
		<AmazonVPCNextPrivateIP>autoassign</AmazonVPCNextPrivateIP>
		<UMInstanceType>unassigned</UMInstanceType>
		<UMSecurityGroup>unassigned</UMSecurityGroup>
		<UMVolumeSize>unassigned</UMVolumeSize>
		<UMVolumeType>gp2</UMVolumeType>
		<UMVolumeIOPS>unassigned</UMVolumeIOPS>
		<PMInstanceType>unassigned</PMInstanceType>
		<PMVolumeSize>unassigned</PMVolumeSize>
		<PMVolumeType>gp2</PMVolumeType>
		<PMVolumeIOPS>unassigned</PMVolumeIOPS>
		<AmazonPMFailover>y</AmazonPMFailover>
		<AmazonAutoTagging>y</AmazonAutoTagging>
		<AmazonElasticIPCount>0</AmazonElasticIPCount>
		<AmazonElasticIPAddr1>unassigned</AmazonElasticIPAddr1>
		<AmazonElasticModule1>unassigned</AmazonElasticModule1>
		<DataRedundancyConfig>n</DataRedundancyConfig>
		<DataRedundancyCopies>0</DataRedundancyCopies>
		<DataRedundancyStorageType>unassigned</DataRedundancyStorageType>
		<CoreFileFlag>n</CoreFileFlag>
		<MySQLPort>3306</MySQLPort>
		<AmazonDeviceName>/dev/xvd</AmazonDeviceName>
		<DistributedInstall>y</DistributedInstall>
		<LockFileDirectory>/var/lock/subsys</LockFileDirectory>
		<ProfileFile>/etc/profile.d/columnstoreAlias.sh</ProfileFile>
		<DataRedundancyNetworkType/>
	</Installation>
	<ExtentMap>
		<!--
		WARNING: these can only be changed on an empty system. Once any object has been allocated
		it cannot be changed!. Extent size is 8M rows.
		-->
		<FilesPerColumnPartition>8</FilesPerColumnPartition> <!-- should be multiple of DBRootCount -->
		<ExtentsPerSegmentFile>2</ExtentsPerSegmentFile>
		<BRM_UID>0x0</BRM_UID>
	</ExtentMap>
	<HashJoin>
		<MaxBuckets>128</MaxBuckets>
		<MaxElems>128K</MaxElems>  <!-- 128 buckets * 128K * 16 = 256 MB -->
		<FifoSizeLargeSide>128</FifoSizeLargeSide>
		<PmMaxMemorySmallSide>64M</PmMaxMemorySmallSide><!-- divide by 48 to getapproximate row count -->
		<TotalUmMemory>50%</TotalUmMemory>
		<TotalPmUmMemory>10%</TotalPmUmMemory>
		<CPUniqueLimit>100</CPUniqueLimit>
		<AllowDiskBasedJoin>N</AllowDiskBasedJoin>
		<!-- Be careful modifying TempFilePath!  On start, ExeMgr deletes
			the entire directory and recreates it to make sure no
			files are left behind.
		<TempFilePath>/tmp</TempFilePath>  -->
		<TempFileCompression>Y</TempFileCompression>
	</HashJoin>
	<JobList>
		<FlushInterval>16K</FlushInterval>
		<FifoSize>32</FifoSize>
		<RequestSize>1</RequestSize>  <!-- Number of extents per request, should be 
			  less than MaxOutstandingRequests. Otherwise, default value 1 is used. -->
		<!--  ProcessorThreadsPerScan is the number of jobs issued to process
			  each extent.  The default is 16.  MaxOutstandingRequests is the size of 
			  the window of work in terms of extents.  A value of 20 means there 
			  is 20 extents worth of work for the PMs to process at any given time.
			  ProcessorThreadsPerScan * MaxOutstandingRequests should be at least
			  as many threads are available across all PMs.  -->
		<!-- <ProcessorThreadsPerScan>16</ProcessorThreadsPerScan> --> 
		<MaxOutstandingRequests>40</MaxOutstandingRequests> 
		<ThreadPoolSize>100</ThreadPoolSize>
	</JobList>
	<TupleWSDL>
		<MaxSize>1M</MaxSize>                   <!-- Max size in bytes per bucket -->
		<InitialCapacity>1M</InitialCapacity>   <!-- Initial capacity per bucket -->
		<MaxBuckets>512</MaxBuckets>            <!-- Number of buckets -->
	</TupleWSDL>
	<RowAggregation>
               <!-- <RowAggrThreads>4</RowAggrThreads> --> <!-- Default value is 4 or number of cores when less than 4 -->
		<!-- <RowAggrBuckets>32</RowAggrBuckets> --> <!-- Default value is number of cores * 4 -->
		<!-- <RowAggrRowGroupsPerThread>20</RowAggrRowGroupsPerThread> --> <!-- Default value is 20 -->
	</RowAggregation>
	<CrossEngineSupport>
		<Host>127.0.0.1</Host>
		<Port>3306</Port>
		<User>root</User>
		<Password/>
		<TLSCA/>
		<TLSClientCert/>
		<TLSClientKey/>
	</CrossEngineSupport>
	<QueryStats>
		<Enabled>Y</Enabled>
	</QueryStats>
	<UserPriority>
		<Enabled>N</Enabled>
	</UserPriority>
	<NetworkCompression>
		<Enabled>Y</Enabled>
	</NetworkCompression>
	<QueryTele>
		<Host>127.0.0.1</Host>
		<Port>0</Port>
	</QueryTele>
	<um2_ProcessMonitor>
		<IPAddr>192.168.0.104</IPAddr>
		<Port>8800</Port>
	</um2_ProcessMonitor>
	<um2_ServerMonitor>
		<IPAddr>192.168.0.104</IPAddr>
		<Port>8622</Port>
	</um2_ServerMonitor>
	<ExeMgr2>
		<IPAddr>192.168.0.104</IPAddr>
		<Port>8601</Port>
		<Module>um2</Module>
	</ExeMgr2>
	<pm2_ProcessMonitor>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8800</Port>
	</pm2_ProcessMonitor>
	<pm2_ServerMonitor>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8622</Port>
	</pm2_ServerMonitor>
	<pm2_WriteEngineServer>
		<IPAddr>192.168.0.103</IPAddr>
		<Port>8630</Port>
	</pm2_WriteEngineServer>
	<pm3_ProcessMonitor>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8800</Port>
	</pm3_ProcessMonitor>
	<pm3_ServerMonitor>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8622</Port>
	</pm3_ServerMonitor>
	<pm3_WriteEngineServer>
		<IPAddr>192.168.0.105</IPAddr>
		<Port>8630</Port>
	</pm3_WriteEngineServer>
	<pm4_ProcessMonitor>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8800</Port>
	</pm4_ProcessMonitor>
	<pm4_ServerMonitor>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8622</Port>
	</pm4_ServerMonitor>
	<pm4_WriteEngineServer>
		<IPAddr>192.168.0.106</IPAddr>
		<Port>8630</Port>
	</pm4_WriteEngineServer>
	<DataRedundancyConfig>
		<DBRoot1PMs/>
		<DBRoot2PMs/>
		<DBRoot3PMs/>
		<DBRoot4PMs/>
	</DataRedundancyConfig>
	<ProcHeartbeatControl>
		<IPAddr>192.168.0.102</IPAddr>
	</ProcHeartbeatControl>
</Columnstore>
