Skip to main content

Determining capacity and usage for your license

Using SingleStoreDB Studio

Studio integrates with both RAM-based and unit-based licenses for reporting on capacity versus licensed usage. You can use Studio with existing clusters managed by MemSQL Ops, or use Studio in new deployments managed by SingleStoreDB Tools.

Using SingleStoreDB directly

You can use SHOW STATUS EXTENDED LIKE "%capacity%" to see your license capacity compared to your current usage. For RAM-based licenses, you will see the following output:

SHOW STATUS EXTENDED LIKE "%capacity%";
****
+--------------------------+-----------+
| Variable_name            | Value     |
+--------------------------+-----------+
| License_capacity         | 131072 MB |
| Maximum_cluster_capacity | 131072 MB |
| Used_cluster_capacity    | 13314 MB  |
+--------------------------+-----------+

And if you have a unit-based license, you will see the following output:

SHOW STATUS EXTENDED LIKE "%capacity%";
****
+--------------------------+---------+
| Variable_name            | Value   |
+--------------------------+---------+
| License_capacity         | 4 units |
| Maximum_cluster_capacity | 4 units |
| Used_cluster_capacity    | 2 units |
+--------------------------+---------+

License_capacity and Maximum_cluster_capacity is your allowed capacity, while Used_cluster_capacity shows what you have used against the capacity. In the second example, two out of four units have been used. A unit is a combination of compute (8 vCPU or less) and RAM (32 GB or less) and only applies to host machines that run leaf nodes.

To understand how nodes, host machines, and license units relate to each other, see the SingleStoreDB FAQ.