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.
Example: # 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 NMSIPAddr = 0.0.0.0 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
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.