Current-Users archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]
Re: Dramatic mysqld slowness when running compiles in parallel
On Monday 06 October 2008, Andrew Doran wrote:
> What happens with 'skip-thread-priority' in my.cnf?
With this option, the slowdown is almost eliminated. I can still observe
occasional delays but they are of the order of a second not ten seconds or
more. I probably would never have noticed the issue if I had used this
option earlier.
> Run "top -t" with a large xterm and post output when it is running slowly.
I've attached the top output (it's from the Dell server rather than from my
laptop [I can provide laptop output too if needed]).
Thanks,
Sverre
load averages: 1.22, 0.67, 0.29; up 4+05:06:11 16:15:06
68 threads: 5 idle, 2 runnable, 60 sleeping, 1 on CPU
CPU states: 94.2% user, 0.0% nice, 4.6% system, 0.0% interrupt, 1.2% idle
Memory: 202M Act, 1084K Wired, 13M Exec, 128M File, 576M Free
Swap: 2000M Total, 2000M Free
kill
PID LID USERNAME PRI STATE TIME WCPU CPU COMMAND NAME
19421 1 root 28 RUN 0:02 74.58% 10.40% cc1 -
10859 1 sverre 85 select 0:00 0.24% 0.24% sshd -
0 35 root 124 syncer 4:10 0.00% 0.00% [system] ioflush
400 7 mysql 85 select 1:06 0.00% 0.00% mysqld -
400 8 mysql 85 select 0:45 0.00% 0.00% mysqld -
0 14 root 96 ipmi_pol 0:18 0.00% 0.00% [system] ipmi0
0 8 root 125 vrele 0:02 0.00% 0.00% [system] vrele
0 9 root 125 cachegc 0:02 0.00% 0.00% [system] cachegc
0 12 root 96 apmev 0:02 0.00% 0.00% [system] apm0
0 15 root 96 iicintr 0:02 0.00% 0.00% [system] iic0
332 1 root 85 kqueue 0:01 0.00% 0.00% master -
627 1 root 76 wait 0:01 0.00% 0.00% nbmake -
0 6 root 223 IDLE 0:00 0.00% 0.00% [system] softser/0
0 3 root 222 IDLE 0:00 0.00% 0.00% [system] softnet/0
0 4 root 221 IDLE 0:00 0.00% 0.00% [system] softbio/0
0 5 root 220 IDLE 0:00 0.00% 0.00% [system] softclk/0
0 2 root 0 IDLE 0:00 0.00% 0.00% [system] idle/0
10758 1 sverre 43 CPU 0:00 0.00% 0.00% top -
400 297 mysql 6 RUN 0:00 0.00% 0.00% mysqld -
0 7 root 127 xcall 0:00 0.00% 0.00% [system] xcall/0
0 34 root 126 pgdaemon 0:00 0.00% 0.00% [system] pgdaemon
0 1 root 125 schedule 0:00 0.00% 0.00% [system] swapper
0 37 root 125 vmem_reh 0:00 0.00% 0.00% [system] vmem_rehash
0 36 root 125 aiodoned 0:00 0.00% 0.00% [system] aiodoned
0 38 root 123 physiod 0:00 0.00% 0.00% [system] physiod
0 17 root 96 atath 0:00 0.00% 0.00% [system] atabus1
0 18 root 96 sccomp 0:00 0.00% 0.00% [system] scsibus0
0 10 root 96 pmfevent 0:00 0.00% 0.00% [system] pmfevent
0 11 root 96 smtaskq 0:00 0.00% 0.00% [system] sysmon
0 33 root 96 crypto_w 0:00 0.00% 0.00% [system] cryptoret
0 32 root 96 sccomp 0:00 0.00% 0.00% [system] atapibus0
0 31 root 96 usbtsk 0:00 0.00% 0.00% [system] usbtask-dr
0 30 root 96 usbtsk 0:00 0.00% 0.00% [system] usbtask-hc
0 29 root 96 usbevt 0:00 0.00% 0.00% [system] usb0
0 28 root 96 ipmi0 0:00 0.00% 0.00% [system] ipmi0
0 19 root 96 sccomp 0:00 0.00% 0.00% [system] scsibus1
0 13 root 96 pmsreset 0:00 0.00% 0.00% [system] pms0
0 16 root 96 atath 0:00 0.00% 0.00% [system] atabus0
16331 1 root 85 netio 0:00 0.00% 0.00% sshd -
404 1 root 85 ttyraw 0:00 0.00% 0.00% getty -
400 1 mysql 85 select 0:00 0.00% 0.00% mysqld -
358 1 root 85 nanoslp 0:00 0.00% 0.00% cron -
325 1 root 85 kqueue 0:00 0.00% 0.00% inetd -
347 1 root 85 wait 0:00 0.00% 0.00% sh -
23482 1 postfix 85 kqueue 0:00 0.00% 0.00% pickup -
247 1 root 85 select 0:00 0.00% 0.00% sshd -
118 1 root 85 kqueue 0:00 0.00% 0.00% syslogd -
1 1 root 85 wait 0:00 0.00% 0.00% init -
7258 1 root 85 netio 0:00 0.00% 0.00% sshd -
6882 1 sverre 85 wait 0:00 0.00% 0.00% bash -
20969 1 root 85 netio 0:00 0.00% 0.00% sshd -
26893 1 sverre 85 select 0:00 0.00% 0.00% sshd -
5416 1 sverre 85 wait 0:00 0.00% 0.00% bash -
27940 1 root 85 wait 0:00 0.00% 0.00% bash -
27779 1 root 85 wait 0:00 0.00% 0.00% sh -
391 1 postfix 85 kqueue 0:00 0.00% 0.00% qmgr -
20005 1 sverre 85 select 0:00 0.00% 0.00% sshd -
11288 1 sverre 85 wait 0:00 0.00% 0.00% bash -
400 10 mysql 85 sigwait 0:00 0.00% 0.00% mysqld -
25977 1 root 84 netio 0:00 0.00% 0.00% mysql -
26186 1 root 84 wait 0:00 0.00% 0.00% bash -
19026 1 root 76 wait 0:00 0.00% 0.00% sh -
6715 1 root 76 wait 0:00 0.00% 0.00% i386--netbsd -
400 9 mysql 43 parked 0:00 0.00% 0.00% mysqld -
400 4 mysql 6 parked 0:00 0.00% 0.00% mysqld -
400 3 mysql 6 parked 0:00 0.00% 0.00% mysqld -
400 5 mysql 6 parked 0:00 0.00% 0.00% mysqld -
400 2 mysql 6 parked 0:00 0.00% 0.00% mysqld -
Home |
Main Index |
Thread Index |
Old Index