MySQL> SELECT name, subsystem, status FROM INFORMATION_SCHEMA.INNODB_METRICS where NAME like 'cpu%';

+---------------+-----------+----------+
| name          | subsystem | status   |
+---------------+-----------+----------+
| cpu_utime_abs | cpu       | disabled |
| cpu_stime_abs | cpu       | disabled |
| cpu_utime_pct | cpu       | disabled |
| cpu_stime_pct | cpu       | disabled |
| cpu_n         | cpu       | disabled |
+---------------+-----------+----------+
5 rows in set (0.06 sec)
以上查看顯示未開啟統(tǒng)計功能

開啟統(tǒng)計

MySQL> SET GLOBAL innodb_monitor_enable='cpu%';

Query OK, 0 rows affected (0.00 sec)

查看 CPU 相關信息

MySQL> SELECT name, subsystem, status 

    ->        FROM INFORMATION_SCHEMA.INNODB_METRICS 
    ->        WHERE NAME like 'cpu%';
+---------------+-----------+---------+
| name          | subsystem | status  |
+---------------+-----------+---------+
| cpu_utime_abs | cpu       | enabled |
| cpu_stime_abs | cpu       | enabled |
| cpu_utime_pct | cpu       | enabled |
| cpu_stime_pct | cpu       | enabled |
| cpu_n         | cpu       | enabled |
+---------------+-----------+---------+
5 rows in set (0.01 sec)

MySQL> select * from information_schema.INNODB_METRICS  where name = 'cpu_n';

+-------+-----------+-------+-----------+-----------+---------------------+-------------+-----------------+-----------------+-----------------+---------------------+---------------+--------------+------------+---------+---------+----------------+
| NAME  | SUBSYSTEM | COUNT | MAX_COUNT | MIN_COUNT | AVG_COUNT           | COUNT_RESET | MAX_COUNT_RESET | MIN_COUNT_RESET | AVG_COUNT_RESET | TIME_ENABLED        | TIME_DISABLED | TIME_ELAPSED | TIME_RESET | STATUS  | TYPE    | COMMENT        |
+-------+-----------+-------+-----------+-----------+---------------------+-------------+-----------------+-----------------+-----------------+---------------------+---------------+--------------+------------+---------+---------+----------------+
| cpu_n | cpu       |     2 |         2 |         2 | 0.00800981910992277 |           2 |               2 |               2 |            NULL | 2025-09-26 10:10:05 | NULL          |          250 | NULL       | enabled | counter | Number of cpus |
+-------+-----------+-------+-----------+-----------+---------------------+-------------+-----------------+-----------------+-----------------+---------------------+---------------+--------------+------------+---------+---------+----------------+
1 row in set (0.01 sec)

第一列NAME 為 cpu_n 參數(shù)的就是關于 CPU 核數(shù)的，COUNT值 為 2 說明有 2 顆CPU。

查看完后可以關閉

MySQL> SET GLOBAL innodb_monitor_disable='cpu%';
Query OK, 0 rows affected (0.10 sec)

MySQL> SELECT name, subsystem, status 
    ->        FROM INFORMATION_SCHEMA.INNODB_METRICS where NAME like 'cpu%';
+---------------+-----------+----------+
| name          | subsystem | status   |
+---------------+-----------+----------+
| cpu_utime_abs | cpu       | disabled |
| cpu_stime_abs | cpu       | disabled |
| cpu_utime_pct | cpu       | disabled |
| cpu_stime_pct | cpu       | disabled |
| cpu_n         | cpu       | disabled |
+---------------+-----------+----------+
5 rows in set (0.00 sec)