******************** Configuration/Status Report for pm1 ********************
 
-- chkconfig configuration --
 
################# chkconfig --list | grep columnstore #################
 
columnstore    	0:off	1:off	2:on	3:on	4:on	5:on	6:off
################# chkconfig --list | grep mysql-Columnstore #################
 
 
-- fstab Configuration --
 
################# cat /etc/fstab #################
 
/dev/root       /       rootfs  noatime,nodiratime      0 0
 
-- Server Processes --
 
################# ps axu #################
 
USER         PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
root           1  0.0  0.0  19288   272 ?        Ss    2017   1:14 /sbin/init
root          54  0.0  0.0   4120    92 lxc/console Ss+ 2017   0:00 /sbin/mingetty console
root         344  0.0  0.0  66316  1304 ?        Ss    2017   0:00 /usr/sbin/sshd
root         356  0.0  0.0  20044  1812 ?        Ss    2017   2:11 crond
root         379  0.0  0.0  11360   176 ?        S     2017   0:00 /bin/bash /usr/local/mariadb/columnstore/bin/run.sh /usr/local/mariadb/columnstore/bin/ProcMon
root         382  0.0  0.1 2886512 15500 ?       Sl    2017  33:20 /usr/local/mariadb/columnstore/bin/ProcMon
root         421  0.0  0.0   4120    88 lxc/tty1 Ss+   2017   0:00 /sbin/mingetty /dev/tty1
root         423  0.0  0.0   4120    88 lxc/tty2 Ss+   2017   0:00 /sbin/mingetty /dev/tty2
root         493  0.0  0.0 466644  5016 ?        Sl    2017   1:56 [ProcMgr]
root       99432  0.0  0.0 110040  1632 ?        Ss    2017   1:20 /usr/local/apache/bin/httpd -k start
daemon     99433  0.0  0.0 2037404 6392 ?        Sl    2017  10:23 /usr/local/apache/bin/httpd -k start
daemon     99434  0.0  0.0 2037404 6536 ?        Sl    2017  10:33 /usr/local/apache/bin/httpd -k start
daemon     99436  0.0  0.0 2037404 7216 ?        Sl    2017  11:13 /usr/local/apache/bin/httpd -k start
root      102587  0.0  0.0 407992  4532 ?        Ss    2017   1:28 php-fpm: master process (/etc/php-fpm.conf)
apache    102588  0.0  0.3 417832 31804 ?        S     2017  11:48 php-fpm: pool www            
apache    102589  0.0  0.3 417836 29516 ?        S     2017  11:50 php-fpm: pool www            
apache    102590  0.0  0.3 417836 28664 ?        S     2017  11:48 php-fpm: pool www            
apache    102597  0.0  0.3 417768 30888 ?        S     2017  11:49 php-fpm: pool www            
apache    102602  0.0  0.3 417728 28176 ?        S     2017  11:50 php-fpm: pool www            
apache    104485  0.0  0.3 417740 28676 ?        S     2017  11:48 php-fpm: pool www            
daemon    104504  0.0  0.0 2037404 7968 ?        Sl    2017  12:52 /usr/local/apache/bin/httpd -k start
apache    128492  0.0  0.3 417692 28260 ?        S     2017  11:50 php-fpm: pool www            
apache    161878  0.0  0.3 417904 30248 ?        S     2017  11:47 php-fpm: pool www            
apache    309127  0.0  0.3 417776 31444 ?        S     2017  11:45 php-fpm: pool www            
apache    400133  0.0  0.3 417652 30372 ?        S     2017  11:48 php-fpm: pool www            
root      422375  0.0  0.0  38788   720 ?        S    16:40   0:00 CROND
root      422395  0.0  0.0   9256   132 ?        Ss   16:40   0:00 /bin/sh -c /usr/billing/billing_update.sh >> /var/log/billing/billing_update.log
root      422408  0.0  0.0   9260   180 ?        S    16:40   0:00 /bin/sh /usr/billing/billing_update.sh
root      427884  0.0  0.1 279296  8600 ?        S    16:40   0:00 /usr/bin/php /usr/billing/importCDNBandWidth.php -f /data/logs/c17/vstats.log -g c17
root      428390  0.0 13.5 11126424 1140616 ?    Sl   16:40   0:01 [WriteEngineServ]
root      628846  0.0  0.3 323856 29372 ?        Sl   Jan08   8:44 /usr/local/mariadb/columnstore/bin/ServerMonitor
root      801541  0.0  0.0  95968  6328 ?        Ss   17:39   0:00 sshd: root@pts/2 
root      801554  0.0  0.0  11360  2528 ?        Ss   17:39   0:00 -bash
root      801567  0.0  0.0  13344  4500 pts/2    Ss   17:39   0:00 -bash
root      839493  0.0  0.0  38788  2736 ?        S    17:46   0:00 CROND
root      839505  0.0  0.0   9256  2152 ?        Ss   17:46   0:00 /bin/sh -c /usr/billing/bill_server.sh >> /var/log/billing/bill_server.log
root      839519  0.0  0.0   9260  2376 ?        S    17:46   0:00 /bin/sh /usr/billing/bill_server.sh
root      848259  0.4  0.3 277248 25248 ?        S    17:47   0:00 /usr/bin/php /usr/billing/importCDNServer.php -f /data/logs/c14c34/vservers.log -g c14c34
root      850949  0.3  0.1 185828 15952 pts/2    Sl+  17:47   0:00 /data/mariadb/columnstore/bin/columnstoreSupport -a
root      851051  0.0  0.0   9260  2376 pts/2    S+   17:47   0:00 /bin/bash /usr/local/mariadb/columnstore/bin/configReport.sh pm1 /usr/local/mariadb/columnstore
root      851064  0.0  0.0  13372  1852 pts/2    R+   17:47   0:00 ps axu
root     1333049  0.6 25.9 11077696 2179892 ?    Sl   Jan13  61:37 [DMLProc]
root     2183283  0.0  0.0  11504   344 ?        S    Jan02   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/billbak.pid --ledir=/usr/local/mariadb/columnstore/mysql//bin
root     2183550  0.5  0.0 2112884 3688 ?        Sl   Jan02 155:57 /usr/local/mariadb/columnstore/bin/controllernode fg
root     2183592  0.2  0.1 213812 10504 ?        Sl   Jan02  76:42 /usr/local/mariadb/columnstore/bin/workernode DBRM_Worker1 fg
root     2183648  0.0  0.0  27704   220 ?        Ss   Jan02   0:00 [DecomSvr]
root     2183668  190  9.0 10567932 761780 ?     Sl   Jan02 50399:03 [PrimProc]
root     2183753 11.8  6.4 4832168 541592 ?      Sl   Jan02 3136:33 [ExeMgr]
root     2184337  0.0  0.0 162308  4692 ?        Sl   Jan02   0:00 [DDLProc]
apache   3301692  0.0  0.3 419472 29932 ?        S     2017  11:01 php-fpm: pool www            
mysql    3910588 24.0 12.5 3387580 1053180 ?     Sl   15:00  40:06 /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/billbak.err --pid-file=/usr/local/mariadb/columnstore/mysql/db/billbak.pid --socket=/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock --port=3306
 
-- Server Processes with resource usage --
 
################# top -b -n 1 #################
 
top - 17:47:19 up 1 day,  7:40,  1 user,  load average: 7.37, 6.55, 6.49
Tasks:  51 total,   1 running,  50 sleeping,   0 stopped,   0 zombie
Cpu(s): 17.6%us,  4.2%sy,  0.0%ni, 77.3%id,  0.3%wa,  0.0%hi,  0.7%si,  0.0%st
Mem:   8388608k total,  6137292k used,  2251316k free,        0k buffers
Swap:        0k total,        0k used,        0k free,   312068k cached

    PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                               
3910588 mysql     20   0 3308m 1.0g  16m S  2.0 12.6  40:06.69 mysqld                                                                
      1 root      20   0 19288  272    0 S  0.0  0.0   1:14.77 init                                                                  
     54 root      20   0  4120   92    4 S  0.0  0.0   0:00.00 mingetty                                                              
    344 root      20   0 66316 1304  576 S  0.0  0.0   0:00.00 sshd                                                                  
    356 root      20   0 20044 1812 1192 S  0.0  0.0   2:11.77 crond                                                                 
    379 root      20   0 11360  176    8 S  0.0  0.0   0:00.00 run.sh                                                                
    382 root      20   0 2818m  15m 7540 S  0.0  0.2  33:20.50 ProcMon                                                               
    421 root      20   0  4120   88    4 S  0.0  0.0   0:00.00 mingetty                                                              
    423 root      20   0  4120   88    4 S  0.0  0.0   0:00.00 mingetty                                                              
    493 root      20   0  455m 5016  532 S  0.0  0.1   1:56.66 ProcMgr                                                               
  99432 root      20   0  107m 1632  272 S  0.0  0.0   1:20.51 httpd                                                                 
  99433 daemon    20   0 1989m 6392  680 S  0.0  0.1  10:23.15 httpd                                                                 
  99434 daemon    20   0 1989m 6536  808 S  0.0  0.1  10:33.17 httpd                                                                 
  99436 daemon    20   0 1989m 7216 1476 S  0.0  0.1  11:13.74 httpd                                                                 
 102587 root      20   0  398m 4532  208 S  0.0  0.1   1:28.01 php-fpm                                                               
 102588 apache    20   0  408m  31m  17m S  0.0  0.4  11:48.29 php-fpm                                                               
 102589 apache    20   0  408m  28m  15m S  0.0  0.4  11:50.75 php-fpm                                                               
 102590 apache    20   0  408m  27m  14m S  0.0  0.3  11:48.32 php-fpm                                                               
 102597 apache    20   0  407m  30m  16m S  0.0  0.4  11:49.14 php-fpm                                                               
 102602 apache    20   0  407m  27m  14m S  0.0  0.3  11:50.48 php-fpm                                                               
 104485 apache    20   0  407m  28m  14m S  0.0  0.3  11:48.46 php-fpm                                                               
 104504 daemon    20   0 1989m 7968 2108 S  0.0  0.1  12:52.86 httpd                                                                 
 128492 apache    20   0  407m  27m  14m S  0.0  0.3  11:50.24 php-fpm                                                               
 161878 apache    20   0  408m  29m  16m S  0.0  0.4  11:47.79 php-fpm                                                               
 309127 apache    20   0  407m  30m  17m S  0.0  0.4  11:45.49 php-fpm                                                               
 400133 apache    20   0  407m  29m  16m S  0.0  0.4  11:48.16 php-fpm                                                               
 422375 root      20   0 38788  720    0 S  0.0  0.0   0:00.00 crond                                                                 
 422395 root      20   0  9256  132    0 S  0.0  0.0   0:00.00 sh                                                                    
 422408 root      20   0  9260  180    4 S  0.0  0.0   0:00.00 billing_update.                                                       
 427884 root      20   0  272m 8600 2056 S  0.0  0.1   0:00.08 php                                                                   
 428390 root      20   0 10.6g 1.1g  16m S  0.0 13.6   0:01.01 WriteEngineServ                                                       
 628846 root      20   0  316m  28m 4240 S  0.0  0.4   8:44.94 ServerMonitor                                                         
 801541 root      20   0 95968 6328 5364 S  0.0  0.1   0:00.05 sshd                                                                  
 801554 root      20   0 11360 2528 2300 S  0.0  0.0   0:00.00 bash                                                                  
 801567 root      20   0 13344 4500 2280 S  0.0  0.1   0:00.14 bash                                                                  
 839493 root      20   0 38788 2736 2016 S  0.0  0.0   0:00.00 crond                                                                 
 839505 root      20   0  9256 2152 2020 S  0.0  0.0   0:00.00 sh                                                                    
 839519 root      20   0  9260 2376 2204 S  0.0  0.0   0:00.00 bill_server.sh                                                        
 848259 root      20   0  270m  24m  19m S  0.0  0.3   0:00.07 php                                                                   
 850949 root      20   0  181m  15m  12m S  0.0  0.2   0:00.02 columnstoreSupp                                                       
 851051 root      20   0  9260 2376 2164 S  0.0  0.0   0:00.00 configReport.sh                                                       
 851065 root      20   0 14944 2004 1764 R  0.0  0.0   0:00.00 top                                                                   
1333049 root      20   0 10.6g 2.1g  13m S  0.0 26.0  61:37.60 DMLProc                                                               
2183283 root      20   0 11504  344    0 S  0.0  0.0   0:00.03 mysqld_safe                                                           
2183550 root      20   0 2063m 3688    0 S  0.0  0.0 155:57.78 controllernode                                                        
2183592 root      20   0  208m  10m 7256 S  0.0  0.1  76:42.66 workernode                                                            
2183648 root      20   0 27704  220    0 S  0.0  0.0   0:00.00 DecomSvr                                                              
2183668 root      20   0 10.1g 743m 9640 S  0.0  9.1  50399:03 PrimProc                                                              
2183753 root      20   0 4718m 528m 8380 S  0.0  6.5   3136:33 ExeMgr                                                                
2184337 root      20   0  158m 4692 1332 S  0.0  0.1   0:00.03 DDLProc                                                               
3301692 apache    20   0  409m  29m  14m S  0.0  0.4  11:01.17 php-fpm                                                               

 
******************** System Network Configuration ********************
 
################# mcsadmin getSystemNetworkConfig ################# 
 
getsystemnetworkconfig   Sat Jan 20 17:47:19 2018

System Network Configuration

Module Name    Module Description            NIC ID    Host Name     IP Address          
-----------    -------------------------     ------    ---------     ---------------     
pm1            Performance Module #1            1      localhost     127.0.0.1           

 
******************** System Module Configure  ********************
 
################# mcsadmin getModuleTypeConfig ################# 
 
getmoduletypeconfig   Sat Jan 20 17:47:19 2018

Module Type Configuration

ModuleType 'pm' Configuration information

ModuleDesc = Performance Module
RunType = SIMPLEX
ModuleCount = 1
ModuleHostName and ModuleIPAddr for NIC ID 1 on  module 'pm1' = localhost , 127.0.0.1
DBRootIDs assigned to module 'pm1' = 1
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 ################# 
 
getstorageconfig   Sat Jan 20 17:47:19 2018

System Storage Configuration

Performance Module (DBRoot) Storage Type = internal
System Assigned DBRoot Count = 1
DBRoot IDs assigned to 'pm1' = 1


 
******************** System Storage Status  ********************
 
################# mcsadmin getStorageStatus ################# 
 
getstoragestatus   Sat Jan 20 17:47:19 2018
System External DBRoot Storage Statuses

Component     Status                       Last Status Change
------------  --------------------------   ------------------------
 No External DBRoot Storage Configured
 
******************** System Status  ********************
 
################# mcsadmin getSystemInfo ################# 
 
getsysteminfo   Sat Jan 20 17:47:19 2018

System columnstore-1

System and Module statuses

Component     Status                       Last Status Change
------------  --------------------------   ------------------------
System        ACTIVE                       Sat Jan 20 16:40:37 2018

Module pm1    ACTIVE                       Sat Jan  6 16:53:25 2018


MariaDB ColumnStore Process statuses

Process             Module    Status            Last Status Change        Process ID
------------------  ------    ---------------   ------------------------  ----------
ProcessMonitor      pm1       ACTIVE            Tue Dec 19 10:02:24 2017         382
ProcessManager      pm1       ACTIVE            Tue Dec 19 10:02:30 2017         493
DBRMControllerNode  pm1       ACTIVE            Tue Jan  2 09:42:43 2018     2183550
ServerMonitor       pm1       ACTIVE            Mon Jan  8 11:11:39 2018      628846
DBRMWorkerNode      pm1       ACTIVE            Tue Jan  2 09:42:45 2018     2183592
DecomSvr            pm1       ACTIVE            Tue Jan  2 09:42:49 2018     2183648
PrimProc            pm1       ACTIVE            Tue Jan  2 09:42:51 2018     2183668
ExeMgr              pm1       ACTIVE            Tue Jan  2 09:42:55 2018     2183753
WriteEngineServer   pm1       ACTIVE            Sat Jan 20 16:40:33 2018      428390
DDLProc             pm1       ACTIVE            Tue Jan  2 09:43:03 2018     2184337
DMLProc             pm1       ACTIVE            Sat Jan 13 15:54:16 2018     1333049
mysqld              pm1       ACTIVE            Sat Jan 20 15:00:27 2018     3910588

Active Alarm Counts: Critical = 2, Major = 0, Minor = 0, Warning = 0, Info = 0
 
******************** System Configuration File  ********************
 
################# cat /etc/Columnstore.xml ################# 
 
<?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: Columnstore.xml 1286 2009-03-30 22:39:41Z dcathey $ -->
<Columnstore Version="V1.0.0">
	<ExeMgr1>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8601</Port>
		<Module>pm1</Module>
	</ExeMgr1>
	<JobProc>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8602</Port>
	</JobProc>
	<ProcMgr>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8603</Port>
	</ProcMgr>
	<ProcStatusControl>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8604</Port>
	</ProcStatusControl>
	<ProcStatusControlStandby>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8605</Port>
	</ProcStatusControlStandby>
	<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>0.0.0.0</IPAddr>
		<Port>8800</Port>
	</um1_ProcessMonitor>
	<pm1_ProcessMonitor>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8800</Port>
	</pm1_ProcessMonitor>
	<dm1_ServerMonitor>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8622</Port>
	</dm1_ServerMonitor>
	<um1_ServerMonitor>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8622</Port>
	</um1_ServerMonitor>
	<pm1_ServerMonitor>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8622</Port>
	</pm1_ServerMonitor>
	<pm1_WriteEngineServer>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8630</Port>
	</pm1_WriteEngineServer>
	<DDLProc>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8612</Port>
	</DDLProc>
	<DMLProc>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8614</Port>
	</DMLProc>
	<BatchInsert>
		<RowsPerBatch>10000</RowsPerBatch>
	</BatchInsert>
	<PrimitiveServers>
		<Count>1</Count>
		<ConnectionsPerPrimProc>8</ConnectionsPerPrimProc>
		<ProcessorThreshold>128</ProcessorThreshold>
		<!-- <ProcessorThreads>16</ProcessorThreads> --> <!-- defaults to num cores * 2 -->
		<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>n</RotatingDestination>
		<!-- <HighPriorityPercentage>60</HighPriorityPercentage> -->
		<!-- <MediumPriorityPercentage>30</MediumPriorityPercentage> -->
		<!-- <LowPriorityPercentage>10</LowPriorityPercentage> -->
	<AggregationMemoryCheck>95</AggregationMemoryCheck>
		<DirectIO>y</DirectIO>
	</PrimitiveServers>
	<PMS1>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS1>
	<PMS2>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS2>
	<PMS3>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS3>
	<PMS4>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS4>
	<PMS5>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS5>
	<PMS6>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS6>
	<PMS7>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS7>
	<PMS8>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS8>
	<PMS9>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS9>
	<PMS10>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS10>
	<PMS11>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS11>
	<PMS12>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS12>
	<PMS13>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS13>
	<PMS14>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS14>
	<PMS15>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS15>
	<PMS16>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS16>
	<PMS17>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS17>
	<PMS18>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS18>
	<PMS19>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS19>
	<PMS20>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS20>
	<PMS21>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS21>
	<PMS22>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS22>
	<PMS23>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS23>
	<PMS24>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS24>
	<PMS25>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS25>
	<PMS26>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS26>
	<PMS27>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS27>
	<PMS28>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS28>
	<PMS29>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS29>
	<PMS30>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS30>
	<PMS31>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS31>
	<PMS32>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8620</Port>
	</PMS32>
	<SystemConfig>
		<SystemLang>C</SystemLang>
		<SystemName>columnstore-1</SystemName>
		<ParentOAMModuleName>pm1</ParentOAMModuleName>
		<StandbyOAMModuleName>unassigned</StandbyOAMModuleName>
		<!-- Disabled
		<ProcessHeartbeatPeriod>-1</ProcessHeartbeatPeriod>
		-->
		<!-- Warning: Do not change this value once database is built -->
		<DBRootCount>1</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>
		<TransactionArchivePeriod>10</TransactionArchivePeriod>
		<NMSIPAddress>0.0.0.0</NMSIPAddress>
		<TempSaveSize>128M</TempSaveSize> <!-- default SWSDL max element save size -->
		<WaitPeriod>10</WaitPeriod> <!-- in seconds -->
		<TempFileDir>/tmp/columnstore_tmp_files</TempFileDir>
		<CalpontHome>$INSTALLDIR</CalpontHome>
		<ModuleHeartbeatPeriod>10</ModuleHeartbeatPeriod>
		<ModuleHeartbeatCount>3</ModuleHeartbeatCount>
		<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>/tmp/rdwrscratch</hdfsRdwrScratch> <!-- Do not set to an hdfs file path -->
		<DataFilePlugin/>
		<DataFileEnvFile/>
		<PrimaryUMModuleName>pm1</PrimaryUMModuleName>
	</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>0</ModuleCount2>
		<ModuleIPAddr1-1-2>0.0.0.0</ModuleIPAddr1-1-2>
		<ModuleHostName1-1-2>unassigned</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>1</ModuleCount3>
		<ModuleIPAddr1-1-3>127.0.0.1</ModuleIPAddr1-1-3>
		<ModuleHostName1-1-3>localhost</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>
	</SystemModuleConfig>
	<SystemExtDeviceConfig>
		<Count>0</Count>
		<Name1>unassigned</Name1>
		<IPAddr1>0.0.0.0</IPAddr1>
		<DisableState1>ENABLED</DisableState1>
	</SystemExtDeviceConfig>
	<SessionManager>
		<MaxConcurrentTransactions>1000</MaxConcurrentTransactions>
		<SharedMemoryTmpFile>$INSTALLDIR/data1/systemFiles/dbrm/CalpontShm</SharedMemoryTmpFile>
		<TxnIDFile>$INSTALLDIR/data1/systemFiles/dbrm/SMTxnID</TxnIDFile>
	</SessionManager>
	<SessionMonitor>
		<SharedMemoryTmpFile>$INSTALLDIR/data1/systemFiles/dbrm/CalpontSessionMonitorShm</SharedMemoryTmpFile>
		<TransactionAgeLimit>10</TransactionAgeLimit>
	</SessionMonitor>
	<VersionBuffer> 
		<!-- VersionBufferFileSize must be a multiple of 8192.
			One version buffer file will be put on each DB root. -->
		<VersionBufferFileSize>1GB</VersionBufferFileSize> 
	</VersionBuffer>
	<OIDManager>
		<!-- XXXPAT: This is located in tmp so we all have R/W access.
		It should be relocated to $INSTALLDIR/share/oidbitmap
		on the production machine-->
		<!-- 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/data/bulk/rollback</BulkRollbackDir>
		<MaxFileSystemDiskUsagePct>98</MaxFileSystemDiskUsagePct>
		<CompressedPaddingBlocks>1</CompressedPaddingBlocks> <!-- Number of blocks used to pad compressed chunks -->
	</WriteEngine>
	<DBRM_Controller>
		<NumWorkers>1</NumWorkers>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8616</Port>
	</DBRM_Controller>
	<!-- Worker Port: 8700 - 8720 is reserved to support External Modules-->
	<DBRM_Worker1>
		<IPAddr>127.0.0.1</IPAddr>
		<Port>8700</Port>
		<Module>pm1</Module>
	</DBRM_Worker1>
	<DBRM_Worker2>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8700</Port>
		<Module>unassigned</Module>
	</DBRM_Worker2>
	<DBRM_Worker3>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8700</Port>
		<Module>unassigned</Module>
	</DBRM_Worker3>
	<DBRM_Worker4>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8700</Port>
		<Module>unassigned</Module>
	</DBRM_Worker4>
	<DBRM_Worker5>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8700</Port>
		<Module>unassigned</Module>
	</DBRM_Worker5>
	<DBRM_Worker6>
		<IPAddr>0.0.0.0</IPAddr>
		<Port>8700</Port>
		<Module>unassigned</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 86% -->
		<NumBlocksPct>50</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>
	</DBBC>
	<Installation>
		<SystemStartupOffline>n</SystemStartupOffline>
		<InitialInstallFlag>y</InitialInstallFlag>
		<SingleServerInstall>y</SingleServerInstall>
		<ServerTypeInstall>2</ServerTypeInstall>
		<PMwithUM>n</PMwithUM>
		<MySQLRep>n</MySQLRep>
		<DBRootStorageType>internal</DBRootStorageType>
		<UMStorageType>internal</UMStorageType>
		<SystemLogConfigFile>unassigned</SystemLogConfigFile>	
		<rpw>unassigned</rpw>
		<Cloud>unassigned</Cloud>
		<EEPackageType>rpm</EEPackageType>
		<AmazonAccessKey>unassigned</AmazonAccessKey>
		<AmazonSecretKey>unassigned</AmazonSecretKey>
		<AmazonRegion>us-east-1</AmazonRegion>
		<AmazonZone>unassigned</AmazonZone>
		<AmazonSubNetID>unassigned</AmazonSubNetID>
		<AmazonVPCNextPrivateIP>unassigned</AmazonVPCNextPrivateIP>
		<PMInstanceType>unassigned</PMInstanceType>
		<UMInstanceType>unassigned</UMInstanceType>
		<UMSecurityGroup>unassigned</UMSecurityGroup>
		<UMVolumeSize>unassigned</UMVolumeSize>
		<PMVolumeSize>unassigned</PMVolumeSize>
		<AmazonPMFailover>n</AmazonPMFailover>
		<AmazonAutoTagging>n</AmazonAutoTagging>
		<AmazonElasticIPCount>0</AmazonElasticIPCount>
		<AmazonElasticIPAddr1>unassigned</AmazonElasticIPAddr1>
		<AmazonElasticModule1>unassigned</AmazonElasticModule1>
		<CoreFileFlag>n</CoreFileFlag>
		<JavaHome>unassigned</JavaHome>
		<JavaPath>unassigned</JavaPath>
		<MySQLPort>3306</MySQLPort>
		<MySQLPasswordConfig>unassigned</MySQLPasswordConfig>
		<GlusterConfig>n</GlusterConfig>
	</Installation>
	<ExtentMap>
		<!--
		WARNING: these can only be changed on an empty system. Once any object has been allocated
		it cannot be changed!. Valid values for ExtentRows are: 64M, 8M and 1M. The default is 8M.
		-->
		<FilesPerColumnPartition>4</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 get element count -->
		<TotalUmMemory>25%</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>$INSTALLDIR/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>20</MaxOutstandingRequests>
	</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>unassigned</Host>
		<Port>3306</Port>
		<User>unassigned</User>
		<Password/>
	</CrossEngineSupport>
	<QueryStats>
		<Enabled>N</Enabled>
	</QueryStats>
	<UserPriority>
		<Enabled>N</Enabled>
	</UserPriority>
	<NetworkCompression>
		<Enabled>Y</Enabled>
	</NetworkCompression>
	<QueryTele>
		<Host>127.0.0.1</Host>
		<Port>0</Port>
	</QueryTele>
</Columnstore>