MySQL Forums
Forum List  »  Source, Builds, Binaries

Re: MySQL Taking Up High CPU Resource
Posted by: jackiehms79
Date: March 11, 2007 11:33PM

Below are the top results that I am getting on mysqld:

top - 13:32:15 up 2 days, 12:52, 4 users, load average: 2.40, 2.09, 2.19
Tasks: 154 total, 1 running, 153 sleeping, 0 stopped, 0 zombie
Cpu0 : 46.5% us, 30.7% sy, 0.0% ni, 22.8% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu1 : 61.4% us, 27.7% sy, 0.0% ni, 10.9% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu2 : 74.3% us, 16.8% sy, 0.0% ni, 8.9% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu3 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu4 : 74.5% us, 19.6% sy, 0.0% ni, 5.9% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu5 : 1.0% us, 1.0% sy, 0.0% ni, 98.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu6 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu7 : 77.0% us, 19.0% sy, 0.0% ni, 4.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 4137672k total, 2658468k used, 1479204k free, 152824k buffers
Swap: 4096532k total, 0k used, 4096532k free, 2176516k cached
PID to kill:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20886 mysql 15 0 373m 57m 3504 S 447 1.4 18:46.75 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
28190 root 17 0 2784 1016 764 S 1 0.0 0:18.39 top -d 1
20975 root 16 0 2196 1008 764 R 1 0.0 0:00.20 top -d1
1 root 16 0 2236 548 472 S 0 0.0 0:01.20 init [3]

Options: ReplyQuote


Subject
Views
Written By
Posted
3476
March 11, 2007 11:31PM
Re: MySQL Taking Up High CPU Resource
2228
March 11, 2007 11:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.