SingleStore DB

mv_sysinfo_disk

The mv_sysinfo_disk view in the information_schema database describes the total disk usage breakdown of SingleStore DB 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 DB 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.