System Manager

Tables (9)

cpu (CPU Info)

  • mname (model name) — VARCHAR — Primary key
  • package — INT — NOT NULL — slot
  • freq (frequency) — DOUBLE — vendor frequency
  • core (cores) — INT — number of cores
  • thread (threads) — INT — number of threads
  • archi (architecture) — VARCHAR — microarchitecture

cusage (CPU Usage)

  • mname (CPU model) — VARCHAR — Foreign key → cpu.mname
  • datetime — DATETIME — NOT NULL — running time
  • usage (total usage) — DOUBLE — usage ratio

graphic (Graphic Cards)

  • mname (device name) — VARCHAR — Primary key — NOT NULL
  • mfr (manufacturer) — VARCHAR
  • version (driver version info) — VARCHAR
  • vram (vRam) — DOUBLE

lcpu (logical cpu)

  • mname (CPU model) — VARCHAR — Foreign key → cpu.mname
  • thread — INT — NOT NULL
  • datetime — DATETIME
  • usage — DOUBLE

mainboard (MainBoard Info)

  • mname (model name) — VARCHAR — Primary key — NOT NULL
  • mfr (manufacturer) — VARCHAR
  • firmware — VARCHAR
  • version — VARCHAR

memory (RAM Info)

  • mname (memory name) — VARCHAR — Primary key — NOT NULL
  • slot — INT
  • mfr (manufacturer) — VARCHAR
  • cap (capacity) — DOUBLE
  • speed (clock speed) — DOUBLE
  • type (memory type) — VARCHAR — DDR4

musage (Memory Usage)

  • seq (sequence) — INT — Primary key — NOT NULL — 0 ~ 9999
  • datetime — DATETIME — NOT NULL
  • total (total memory) — DOUBLE
  • usage (memory usage) — DOUBLE
  • ratio (usage ratio) — DOUBLE — %

network (Network Interface)

  • iname (interface name) — VARCHAR — Primary key — NOT NULL — eth0
  • mac (MAC address) — VARCHAR — 70:85:c2:c5:cd:1b
  • speed (network speed) — INT — 1000000000
  • ipv4 (IPv4) — VARCHAR — 192.168.35.140/24
  • ipv6 (IPv6) — VARCHAR — fe80:0:0:0:78ba:2215:aa82:443f/64
  • host (host name) — VARCHAR
  • domain (domain name) — VARCHAR
  • dns (DNS server) — VARCHAR
  • gateway4 (IPv4 gateway) — VARCHAR
  • gateway6 (IPv6 gateway) — VARCHAR

sysinfo (System Info)

  • server (server name) — VARCHAR — Primary key — NOT NULL
  • Field