# MV\_SYSINFO\_MEM

This view describes the total memory usage breakdown of SingleStore and other processes.

| Column name      | Description                                                                 |
| ---------------- | --------------------------------------------------------------------------- |
| `node_id`        | The ID of the node.                                                         |
| `ip_addr`        | The IP address of the node.                                                 |
| `port`           | The port on which the node is listening.                                    |
| `type`           | `MA`,`Leaf`, or`CA`                                                         |
| `host_total_b`   | The memory available on the physical host.                                  |
| `host_used_b`    | The total memory used on the physical host.                                 |
| `cgroup_total_b` | The memory limit for theSingleStore`node_id`based on its cgroup membership. |
| `cgroup_used_b`  | The memory used by all processes ofSingleStorecgroup.                       |
| `memsql_b`       | The memory used bySingleStoreprocess specified by`node_id`.                 |
| `timestamp_ns`   | The time when the data was received.                                        |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/management/mv-sysinfo-mem/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-sysinfo-mem/)

(An index of the documentation is available at /llms.txt)