29.12.22.7 The system_cpu_stats Table

System CPU statistics.

mysql> select * from performance_schema.system_cpu_stats\G
*************************** 1. row ***************************
    TIMESTAMP: 2026-09-30 16:46:26
          CPU: cpu
      USER_MS: 737520
      NICE_MS: 48130
    SYSTEM_MS: 830560
      IDLE_MS: 134471270
    IOWAIT_MS: 22570
       IRQ_MS: 4791870
   SOFTIRQ_MS: 253530
     STEAL_MS: 0
     GUEST_MS: 0
GUEST_NICE_MS: 0
*************************** 2. row ***************************
    TIMESTAMP: 2026-09-30 16:46:26
          CPU: cpu0
      USER_MS: 131920
      NICE_MS: 5420
    SYSTEM_MS: 135850
      IDLE_MS: 22496600
    IOWAIT_MS: 4640
       IRQ_MS: 736200
   SOFTIRQ_MS: 49350
     STEAL_MS: 0
     GUEST_MS: 0
GUEST_NICE_MS: 0
*************************** 3. row ***************************
    TIMESTAMP: 2026-09-30 16:46:26
          CPU: cpu1
      USER_MS: 149260
      NICE_MS: 6120
    SYSTEM_MS: 136110
      IDLE_MS: 22291420
    IOWAIT_MS: 1340
       IRQ_MS: 899360
   SOFTIRQ_MS: 36190
     STEAL_MS: 0
     GUEST_MS: 0
GUEST_NICE_MS: 0
*************************** 4. row ***************************

The system_cpu_stats table has the following columns:

• TIMESTAMP: Time when the measurement was taken.

• CPU: CPU times.

  • cpu: Aggregated time.

  • cpu[n]: Individual times.

• USER_MS: Time spent in user mode.

• NICE_MS: Time spent in user mode with low priority.

• SYSTEM_MS: Time spent in system mode.

• IDLE_MS: Time spent idling.

• IOWAIT_MS: Time waiting for I/O to complete.

• IRQ_MS: Time servicing interrupts.

• SOFTIRQ_MS: Time servicing softirqs.

• STEAL_MS: Time of involuntary waits on processor time.

• GUEST_MS: Time spent running a virtual CPU with normal priority.

• GUEST_NICE_MS: Time spent running a virtual CPU with niced priority.