On 2010-11-29 09:54, 7CREWZ wrote:
Hai to all,
This is the snapshot of my mysql server dedicated.i
wondering why the 4 cpu is not utilize and the rest cpu always sleep.. ?
Try to put some pressure on the database. What you describe is typical
behaviour for a multi-threaded application - like mysql.
For any multi-threaded application, doing as much work as possible
within the same core is much more efficient than switching over to
another core - which is very expensive in terms of cpu cycles. So
core-affinity is a good thing!
How threads are scheduled between cores is generally up to the kernel
scheduler.
Cpu0 : 3.3%us, 0.3%sy, 0.0%ni, 93.7%id, 2.3%wa, 0.0%hi, 0.3%si,
0.0%st
Cpu1 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si,
0.0%st
Cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si,
0.0%st
Cpu3 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si,
0.0%st
Mem: 8174224k total, 2500868k used, 5673356k free, 87040k buffers
Swap: 2031608k total, 1044640k used, 986968k free, 1305844k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2173 mysql 15 0 6167m 966m 5720 S 4 12.1 0:39.03 mysqld
2667 root 15 0 12584 1052 804 R 0 0.0 0:00.12 top
1 root 15 0 10324 348 320 S 0 0.0 0:01.50 init
2 root RT -5 0 0 0 S 0 0.0 0:00.00 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0
4 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0 0.0 0:00.00 migration/1
6 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1
7 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0 0.0 0:00.00 migration/2
9 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/2
10 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0 0.0 0:00.00 migration/3
12 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/3
13 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/3
14 root 10 -5 0 0 0 S 0 0.0 0:00.01 events/0
15 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/1
16 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/2
17 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/3
18 root 10 -5 0 0 0 S 0 0.0 0:00.00 khelper
89 root 11 -5 0 0 0 S 0 0.0 0:00.00 kthread
96 root 10 -5 0 0 0 S 0 0.0 0:00.87 kblockd/0
97 root 10 -5 0 0 0 S 0 0.0 0:00.00 kblockd
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
