View Single Post
  #1   (View Single Post)  
Old 16th May 2008
bdj bdj is offline
New User
 
Join Date: May 2008
Posts: 4
Default mysql using >100% cpu

I'm running freebsd 6.1, mysql 5
dual core 2,33 ghz 4mb cache, 2gb RAM

For some reason mysql is using more than 100% cpu, how can something use more than 100%?

Here's a TOP print:

Code:
last pid: 12809;  load averages:  6.90,  5.38,  4.96                                    up 37+04:21:30  22:26:20
199 processes: 6 running, 193 sleeping
CPU states: 32.5% user,  0.0% nice, 67.1% system,  0.4% interrupt,  0.0% idle
Mem: 752M Active, 332M Inact, 247M Wired, 69M Cache, 112M Buf, 600M Free
Swap: 4068M Total, 4068M Free

  PID USERNAME   THR PRI NICE   SIZE    RES STATE  C   TIME    CPU COMMAND
12483 mysql       69  20    0   453M 84336K kserel 0  23:25 136.67% mysqld
12803 apache       1  20    0 36968K 30544K lockf  1   0:00  0.73% httpd
12741 apache       1  20    0 35808K 29352K lockf  1   0:00  0.39% httpd
  763 root         1   8    0   852K   280K nanslp 0   0:58  0.00% da-popb4smtp
  529 root         1  96    0  3640K  2088K select 1   0:38  0.00% sshd
94077 apache       1   4    0 37572K 30908K sbwait 1   0:30  0.00% httpd
95011 apache       1   4    0 37488K 30824K sbwait 0   0:29  0.00% httpd
93265 apache       1   4    0 37408K 30732K sbwait 0   0:29  0.00% httpd
96241 apache       1   4    0 37432K 30784K sbwait 0   0:28  0.00% httpd
94275 apache       1   4    0 37624K 30976K sbwait 1   0:28  0.00% httpd
94091 apache       1   4    0 37536K 30872K sbwait 0   0:28  0.00% httpd
94365 apache       1   4    0 37380K 30736K sbwait 1   0:28  0.00% httpd
94963 apache       1   4    0 37476K 30812K sbwait 0   0:28  0.00% httpd
95010 apache       1   4    0 37504K 30860K sbwait 1   0:28  0.00% htt
Reply With Quote