Mailing List Archive: DBMail: users

Dbmail not runnig all CPU ?

Index | Next | Previous | View Threaded

7crewz at gmail

Nov 29, 2010, 12:54 AM

Post #1 of 2 (351 views)
Permalink

Dbmail not runnig all CPU ?

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.. ?

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

paul at nfg

Nov 29, 2010, 1:23 AM

Post #2 of 2 (322 views)
Permalink

Re: Dbmail not runnig all CPU ? [In reply to]

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
> DBmail [at] dbmail
> 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
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads