top list

tethys ocean tethys.ocean at gmail.com
Wed Dec 22 11:19:10 PST 2004


Mysql running on an IBM dopuble cpu server freebsd 5.2.1 RELEASE 
whenever I said that TOP 



 PID USERNAME      PRI NICE   SIZE    RES STATE  C   TIME   WCPU    CPU COMMAND
 1313 mysql         132    0 79712K 45832K RUN    0  49.0H 93.31% 93.31% mysqld
  333 bind           96    0 11696K 11008K select 1  19:59  0.00%  0.00% named
  524 root          123    0  3852K  2612K select 0   8:24  0.00% 
0.00% sendmail
58617 www             4    0 13792K 10844K accept 1   5:08  0.00%  0.00% httpd
  322 root           96    0  1320K   788K select 0   4:10  0.00%  0.00% syslogd
  191 root            8    0  1836K  1328K nanslp 0   3:42  0.00%  0.00% ipmon
 1314 root          127    0  1420K   968K select 1   2:19  0.00%  0.00% inetd
32189 root           96    0 11272K  7980K select 1   1:24  0.00%  0.00% httpd
  519 mailnull       96    0  1752K  1028K select 0   0:13  0.00% 
0.00% mimedefang
  570 mailnull       -8    0 23196K 22392K piperd 1   0:03  0.00%  0.00% perl
  549 root            8    0  1344K   916K nanslp 0   0:03  0.00%  0.00% cron
  508 mailnull       -8    0 23196K 22392K piperd 1   0:03  0.00%  0.00% perl
  466 root           96    0  3508K  1812K select 0   0:01  0.00%  0.00% sshd
57903 www             4    0 13412K 10480K accept 1   0:01  0.00%  0.00% httpd
67624 root            4    0  4232K  3044K connec 0   0:01  0.00% 
0.00% sendmail
68261 root           96    0  2320K  1444K select 0   0:01  0.00%  0.00% top
57904 www             4    0 13184K 10200K accept 1   0:01  0.00%  0.00% httpd
57907 www             4    0 12328K  9332K accept 1   0:01  0.00%  0.00% httpd
57902 www             4    0 11452K  8388K accept 1   0:01  0.00%  0.00% httpd
58618 www             4    0 11408K  8400K accept 1   0:01  0.00%  0.00% httpd
57901 www             4    0 11456K  8424K accept 1   0:00  0.00%  0.00% httpd
57924 www             4    0 11480K  8424K accept 1   0:00  0.00%  0.00% httpd
68634 root           96    0  2320K  1436K CPU0   0   0:00  0.00%  0.00% top
  527 smmsp          20    0  3604K  2316K pause  1   0:00  0.00% 
0.00% sendmail
57905 www             4    0 11596K  8608K accept 1   0:00  0.00%  0.00% httpd
58404 www             4    0 11404K  8328K accept 1   0:00  0.00%  0.00% httpd
  739 root            8    0  1348K   912K wait   0   0:00  0.00%  0.00% bash
68231 parker         96    0  6244K  2444K RUN    0   0:00  0.00%  0.00% sshd
  506 mailnull       96    0  2300K  1012K select 0   0:00  0.00% 
0.00% mimedefang-multiple



Mysql consume all cpu its just strange any 12 virtual  user that has
database webpage
What mysql can consume nearly all CPU?


More information about the freebsd-database mailing list