Back
Outdated Version

You are viewing an older version of this section. View current production version.

/Cluster Management/ /

Next Steps min read

Command-Line Parameters

Refer to memsql-report send-alert for more information on the available command-line arguments.

Alerts Reference and Default Thresholds

Check + Description Warn default Fail default Configurable?
leavesNotOnline

Offline leaf nodes		 Fail if >=1 Leaf Offline Yes
offlineAggregators

Offline aggregator nodes		 Fail if >= 1 Aggregator offline Yes
explainRebalancePartitionsChecker

Identifies if partitions are not balanced across the cluster		 Any output Yes

Configure to switch this to Warning
orphanDatabases

Identifies if any orphan databases are found. Orphan databases should be examined and dropped		 Any output Yes

Configure to switch this to Failure
pendingDatabases

Identifies databases that are in a pending state. Pending databases are not available for read/write queries.		 Any output Yes

Configure to switch this to Warning
unrecoverableDatabases

Identifies databases that are unrecoverable.		 Any output Yes

Configure to switch to Warning
userDatabaseRedundancy

Determines if a database is redundant		 Any output Yes

Configure to Switch to Warning
memoryUsage

Checks free memory against total available		 Less than 15% of the memory available Less than 10% memory available Yes
userDatabaseRedundancy High availability not enabled (not configurable) Master Partition missing its replica partition Yes
replicatingDatabase

Checks for the presence of secondary replicating databases		 Any output Yes

Configure to switch to Warning

System Checks Thresholds

Check + Description Warn default Fail default Configurable?
Idle CPU 25.0% 5.0% Yes
Disk Latency (read) 10 ms 25 ms Yes
Disk Latency (write) 10 ms 25 ms Yes
Disk Usage 70% 80% Yes
Disk Inodes 70% 85% Yes
Memory Checks
(Major Faults, majflts)		 10 majftl/s 20 majflt/s Yes
Swap Used 5% 10% Yes
Memory Committed 70% 90% Yes
Need help or have suggestions? Go to SingleStore Forums