MariaDB ColumnStore System Monitoring

You are viewing an old version of this article. View the current version here.

A Parent OAM Module in MariaDB ColumnStore is one of the performance module node, which in addition to query processing like other PM nodes, also monitors the overall system health, resource usage and PM node failover management. Various mcsadmin commands can be used to view this monitoring data. The monitored resources are System, processes, servers, CPU usage, disk usage, RAID, memory usage, and swap space.

Configuration for monitoring

Viewing system configuration

To view the system configuration, use getSystemConfig command in mcsadmin, or simply use mcsadmin getSystemConfig from the operating system prompt.

# mcsadmin getSystemConfig
getsystemconfig Wed Mar 28 10:17:49 2016

System Configuration

SystemName = sn-perf-1
SoftwareVersion = 3.0
SoftwareRelease = 0
ParentOAMModuleName = pm1
StandbyOAMModuleName = pm2
ModuleHeartbeatPeriod = 1
ModuleHeartbeatCount = 3
DBRootCount = 6
DBRoot1 = /usr/local/mariadb/columnstore/data1
DBRoot2 =/usr/local/mariadb/columnstore/data2
DBRoot3 = /usr/local/mariadb/columnstore/data3
DBRoot4 = /usr/local/mariadb/columnstore/data4
DBRoot5 = /usr/local/mariadb/columnstore/data5
DBRoot6 = /usr/local/mariadb/columnstore/data6
DBRMRoot = /usr/local/mariadb/columnstore/data1/systemFiles/dbrm/BRM_saves
ExternalCriticalThreshold = 90
ExternalMajorThreshold = 80
ExternalMinorThreshold = 70
MaxConcurrentTransactions = 1000
SharedMemoryTmpFile = /usr/local/mariadb/columnstore/data1/systemFiles/dbrm/CalpontShm
VersionBufferFileSize = 1
OIDBitmapFile = /usr/local/mariadb/columnstore/data1/systemFiles/dbrm/oidbitmap
FirstOID = 3000
TransactionArchivePeriod = 10


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.