This is because only one cpu is enough for your concurrent. On Sun, Jun 22, 2008 at 12:14 AM, Per Jessen <[EMAIL PROTECTED]> wrote:
> Eber Duarte wrote: > > > I noticed that I always have 2 processes runing on Linux doesn't > > matter the amount of concurrent connections that is running on MySQL. > > Due to that, MySQL is using only 1 CPU instead of using 8 CPUs that > > exist on this machine: > > Do you have enough concurrent load to occupy 8 CPUs? > > Here's a sample 'top' from one of my machines (also 8-way): > > top - 18:12:58 up 12 days, 23:22, 6 users, load average: 2.95, 3.02, 3.53 > Tasks: 177 total, 1 running, 175 sleeping, 0 stopped, 1 zombie > Cpu0 : 45.1%us, 13.2%sy, 0.0%ni, 41.4%id, 0.0%wa, 0.0%hi, 0.3%si, > 0.0%st > Cpu1 : 19.0%us, 13.8%sy, 0.0%ni, 67.2%id, 0.0%wa, 0.0%hi, 0.0%si, > 0.0%st > Cpu2 : 23.9%us, 12.7%sy, 0.0%ni, 63.4%id, 0.0%wa, 0.0%hi, 0.0%si, > 0.0%st > Cpu3 : 32.1%us, 11.1%sy, 0.0%ni, 56.7%id, 0.0%wa, 0.0%hi, 0.0%si, > 0.0%st > Cpu4 : 38.0%us, 9.5%sy, 0.0%ni, 52.5%id, 0.0%wa, 0.0%hi, 0.0%si, > 0.0%st > Cpu5 : 98.4%us, 1.6%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, > 0.0%st > Cpu6 : 73.9%us, 16.3%sy, 0.0%ni, 9.8%id, 0.0%wa, 0.0%hi, 0.0%si, > 0.0%st > Cpu7 : 36.7%us, 13.4%sy, 0.0%ni, 49.8%id, 0.0%wa, 0.0%hi, 0.0%si, > 0.0%st > Mem: 5195036k total, 4960136k used, 234900k free, 8k buffers > Swap: 4200956k total, 244k used, 4200712k free, 3469996k cached > > PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND > 4575 mysql 16 0 1152m 1.0g 4792 S 249 21.0 18269:15 mysqld > 16720 root 25 0 0 0 0 Z 5 0.0 0:00.15 make <defunct> > > > > /Per Jessen, Zürich > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn