pkgsrc-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