Status Page

Info

As of MemSQL 6.7, MemSQL Ops is a deprecated tool. You are encouraged to use the new MemSQL management tools for future deployments. See the installation guides for more details on how to deploy and manage a cluster using the new management tools.

The Status page in MemSQL Ops top level information about the database workload currently running. image

The metrics shown on this page include:

Name Description
Rows Read Total number of rows read in workloads running against the database.
Rows Written Total number of rows written in workloads running against the database.
Leaf Table Memory Amount of memory currently used by MemSQL to store data, relative to the maximum amount of memory MemSQL can use to store data. Note that data can only be stored on leaf nodes. When this is full, no further database inserts will be accepted.
Leaf MemSQL Memory Total amount of memory currently used by MemSQL processes on the leaf nodes, relative to the maximum amount of memory MemSQLis allowed to use on leaf nodes. When this is full, no further database queries will be allowed.
Cluster License Capacity Summation of maximum_memory from each node in the cluster (master aggregator, child aggregators, and leaves) divided by 1024, relative to the maximum capacity licensed for the cluster.
Disk Capacity Amount of disk space MemSQL is using in the system (summed over all aggregator and leaf nodes), relative to the total disk space available in the system. When this is full, no database snapshots, transaction log files, or columnstore data can be created.
Was this article useful?