SingleStore DB

mv_sysinfo_cpu

The mv_sysinfo_cpu view in the information_schema database describes the total CPU usage breakdown of SingleStore DB and other processes per node.

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

memsql_total_cumulative_ns

CPU usage by the SingleStore DB process since its startup.

memsql_user_cumulative_ns

CPU usage by the SingleStore DB process, in user mode, since process startup.

memsql_system_cumulative_ns

CPU usage by the SingleStore DB process, in kernel mode, since process startup.

total_used_cumulative_ns

CPU usage since the startup of the machine. It refers to the whole machine, and not to SingleStore DB cgroup.

user_used_cumulative_ns

CPU usage in user mode since the startup of the machine.

nice_cumulative_ns

CPU usage in nice mode since the startup of the machine.

system_cumulative_ns

CPU usage in kernel mode since the startup of the machine.

idle_cumulative_ns

CPU idle time since the startup of the machine.

iowait_cumulative_ns

CPU waiting time for I/O since the startup of the machine.

irq_cumulative_ns

Time spent on servicing interrupts.

softirq_cumulative_ns

Time spent on servicing soft interrupts.

steal_cumulative_ns

Stolen time, which is the time spent in other operating systems when running in a virtualized environment.

guest_cumulative_ns

Time spent running a virtual CPU for guest operating systems under the control of the Linux kernel.

guest_nice_cumulative_ns

Time spent running a nice guest (virtual CPU for guest operating systems under the control of the Linux kernel).

cfs_quota_ns

The amount of time in nanoseconds that the cgroup (that this SingleStore DB process is a member of) is allowed to spend per cfs_period_ns.

cfs_period_ns

Used in conjunction with cfs_quota_ns.

num_cpus

The number of cores on host.

timestamp_ns

The time when the data was received.