User Manual

Table 89 statcpu_<res>_1 Table (continued)
CommentTypeColumn
Difference between usert value from last sample for same CPU.DOUBLE PRECISION NOT
NULL
d_usert
Jiffies (0.01 sec) in system mode.DOUBLE PRECISION NOT
NULL
syst
Difference between syst value from last sample for same CPU.DOUBLE PRECISION NOT
NULL
d_syst
Jiffies (0.01 sec) in idle mode.DOUBLE PRECISION NOT
NULL
idlet
Difference between idlet value from last sample for same CPU.DOUBLE PRECISION NOT
NULL
d_idlet
The CPU tick count. A single count for all CPUs on a node is
maintained in CPU 0, all other CPUs on the node have 0 values for
this column.
DOUBLE PRECISION NOT
NULL
cputicks
Difference between cputicks value from last sample for same CPU.DOUBLE PRECISION NOT
NULL
d_cputicks
The number of interrupts for the CPU. A single count for all CPUs on
a node is maintained in CPU 0, all other CPUs on the node have 0
values for this column.
DOUBLE PRECISION NOT
NULL
intr
Difference between intr value from last sample for same CPU.DOUBLE PRECISION NOT
NULL
d_intr
The number of context switches for the CPU. A single count for all
CPUs on a node is maintained in CPU 0, all other CPUs on the node
have 0 values for this column.
DOUBLE PRECISION NOT
NULL
ctxt
Difference between ctxt value from last sample for same CPU.DOUBLE PRECISION NOT
NULL
d_ctxt
The statcpuinv Table
The statcpuinv_<res>_1 table holds the inventory for the statcpu_<res>_1 table.
Table 90 statcpuinv_<res>_1 Table
CommentTypeColumn
Sample time in secs. This is the Unix time and is the number of
seconds since 0:00:00 Jan 1, 1970 GMT.
INTEGER NOT NULLtsecs
A unique identifier for the system instance refers to the uniq_id for
the system instance in the system_3 table.
INTEGER NOT NULLsys_uid
The node number.INTEGER NOT NULLnode
The CPU number in the node.INTEGER NOT NULLcpu
The statlink Table
The statlink_<res>_2 table holds the inter-node link performance data samples.
214 Database Schema