用ps取数据为什么mysql的cpu值这么高

spouter

使用ps -eo pcpu,args查出来mysql占用cpu的百分比数值是463392，这个怎么回事？

%CPU COMMAND
0.0 /sbin/init
0.0 [kthreadd]
0.0 [migration/0]
0.0 [ksoftirqd/0]
0.0 [migration/0]
0.0 [watchdog/0]
0.0 [migration/1]
0.0 [migration/1]
0.0 [ksoftirqd/1]
0.0 [watchdog/1]
0.0 [migration/2]
0.0 [migration/2]
0.0 [ksoftirqd/2]
0.0 [watchdog/2]
0.0 [migration/3]
0.0 [migration/3]
0.0 [ksoftirqd/3]
0.0 [watchdog/3]
0.0 [migration/4]
0.0 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/BJ14-172-SCM-DB.wom-inc.com.pid
0.0 cleanup -z -t unix -u
0.0 local -t unix
0.0 bounce -z -t unix -u
463392 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/BJ14-172-SCM-DB.wom-inc.com.err --pid-file=/usr/local/mysql/var/BJ14-172-SCM-DB.wom-inc.com.pid --socket=/usr/local/mysql/var/mysql.sock --port=3306
2.0 ps -eo pcpu,args

q1208c

这个不是 百分比吧?

wenhq

lscpu输出下。

wenhq

看了下man手册
pcpu       %CPU     see %cpu. (alias %cpu).
%cpu       %CPU     cpu utilization of the process in "##.#" format. Currently, it is the CPU time used divided by the time the process has been
                    running (cputime/realtime ratio), expressed as a percentage. It will not add up to 100% unless you are lucky. (alias pcpu).

看样子是cpu分配给该进程的时间比。一般不会超过100%，

spouter

回复 3# wenhq

难道是因为是虚机的原因才算错！

[root@LA14-12-CMS-DB ~]# lscpu
Architecture:          x86_64
CPU op-mode(s):        32-bit, 64-bit
Byte Order:            Little Endian
CPU(s):                24
On-line CPU(s) list:   0-23
Thread(s) per core:    2
Core(s) per socket:    6
CPU socket(s):         2
NUMA node(s):          2
Vendor ID:             GenuineIntel
CPU family:            6
Model:                 45
Stepping:              7
CPU MHz:               1200.000
BogoMIPS:              4999.27
Virtualization:        VT-x
L1d cache:             32K
L1i cache:             32K
L2 cache:              256K
L3 cache:              15360K
NUMA node0 CPU(s):     0-5,12-17
NUMA node1 CPU(s):     6-11,18-23


   

wenhq

你能重新输出下ps -eo pcpu,xargs?

spouter

# ps -eo pcpu,args | less
%CPU COMMAND
0.0 /sbin/init
0.0 [kthreadd]
0.0 [migration/0]
0.0 [ksoftirqd/0]
0.0 [migration/0]
0.0 [watchdog/0]
0.0 [migration/1]
0.0 [migration/1]
0.0 [ksoftirqd/1]
0.0 [watchdog/1]
0.0 [migration/2]
0.0 [migration/2]
0.0 [ksoftirqd/2]
0.0 [watchdog/2]
0.0 [migration/3]
0.0 [migration/3]
0.0 [ksoftirqd/3]
0.0 [watchdog/3]
0.0 [migration/4]
0.0 [migration/4]
0.0 [ksoftirqd/4]
0.0 [watchdog/4]
0.0 [migration/5]
0.0 [migration/5]
0.0 [ksoftirqd/5]
0.0 [watchdog/5]
0.0 [migration/6]
0.0 [migration/6]
0.0 [ksoftirqd/6]
0.0 [watchdog/6]
0.0 [migration/7]
0.0 [migration/7]
0.0 [ksoftirqd/7]
0.0 [watchdog/7]
0.0 [migration/8]
0.0 [migration/8]
0.0 [ksoftirqd/8]
0.0 [watchdog/8]
0.0 [kslowd001]
0.0 [nfsiod]
0.0 [nfsv4.0-svc]
0.0 [bluetooth]
0.0 /sbin/udevd -d
0.0 /sbin/udevd -d
0.0 sshd: root@pts/0,pts/2
0.0 -bash
0.0 sshd: root@pts/1   
0.0 -bash
0.0 -bash
0.0 /usr/local/nagios/bin/nrpe -c /usr/local/nagios/etc/nrpe.cfg -d
0.0 sshd: root@pts/3   
0.0 -bash
0.0 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/BJ14-172-SCM-DB.wom-inc.com.pid
461955 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/BJ14-172-SCM-DB.wom-inc.com.err --pid-file=/usr/local/mysql/var/BJ14-172-SCM-DB.wom-inc.com.pid --socket=/usr/local/mysql/var/mysql.sock --port=3306
0.0 sshd: root@pts/4   
0.0 -bash
0.0 /usr/libexec/gdm-simple-slave --display-id /org/gnome/DisplayManager/Display1
0.0 /usr/bin/Xorg :0 -br -verbose -auth /var/run/gdm/auth-for-gdm-jwdFLp/database -nolisten tcp
0.0 /usr/bin/dbus-launch --exit-with-session
0.0 /bin/dbus-daemon --fork --print-pid 5 --print-address 7 --session
0.0 /usr/bin/gnome-session --autostart=/usr/share/gdm/autostart/LoginWindow/
0.0 /usr/libexec/gconfd-2
0.0 /usr/libexec/at-spi-registryd
0.0 /usr/libexec/gnome-settings-daemon --gconf-prefix=/apps/gdm/simple-greeter/settings-manager-plugins
0.0 /usr/libexec/bonobo-activation-server --ac-activate --ior-output-fd=12
0.0 /usr/libexec/gvfsd
0.0 metacity
0.0 gnome-power-manager
0.0 /usr/libexec/gdm-simple-greeter
0.0 /usr/libexec/polkit-gnome-authentication-agent-1
0.0 /usr/bin/pulseaudio --start --log-target=syslog
0.0 pam: gdm-password
0.0 /sbin/rsyslogd -i /var/run/syslogd.pid -c 4
(END)