MV_SYSINFO_DISK

This view describes the total disk 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

mount_name

The name of the mount_point for directories in memsql_dirs.

mount_point

The location of the mount.

memsql_dirs

The comma separated list of SingleStore directories (data, plancache, tracelogs) that are tracked.

mount_total_b

The total size of the disk, in bytes, for mount_point.

mount_used_b

The total bytes used by the disk at mount_point.

read_cumulative_b

The total bytes read from the disk across all mount points since the starting of the process.

write_cumulative_b

The total bytes written to the disk across all mount points since the starting of the process.

timestamp_ns

The time when the data was received.

read_operations_cumulative_per_device

Number of read operations performed by the device since start up.

write_operations_cumulative_per_device

Number of write operations performed by the device since start up.

device_name

Name of the device to which the values in read_operations_cumulative_per_device and write_operations_cumulative_per_device are associated.

Last modified: November 21, 2023

Was this article helpful?