Question about threads [beaver challenge]

[Petri Helenius]

Daniel Eischen wrote:

>On Tue, 10 Feb 2004, Petri Helenius wrote:
>
>  
>
>>Craig Rodrigues wrote:
>>
>>    
>>
>>>How did you compile and configure MySQL with KSE?
>>>
>>> 
>>>
>>>      
>>>
>>I just did build it out of ports, using libmap.conf to map it to libkse. 
>>No extra options given.
>>    
>>
>
>"map it" equates to what?  Mapping all libc_r to libkse or just
>mysql?
>
>  
>
All. (any other executables you´re interested in?)
 > ldd /usr/local/libexec/mysqld
/usr/local/libexec/mysqld:
        libwrap.so.3 => /usr/lib/libwrap.so.3 (0x28377000)
        libz.so.2 => /lib/libz.so.2 (0x2837f000)
        libcrypt.so.2 => /lib/libcrypt.so.2 (0x2838d000)
        libc_r.so.5 => /usr/lib/libkse.so.1 (0x283a6000)
        libstdc++.so.4 => /usr/lib/libstdc++.so.4 (0x283ca000)
        libm.so.2 => /lib/libm.so.2 (0x28486000)
        libc.so.5 => /lib/libc.so.5 (0x2849f000)
 >

>Can you also do a 'top -H' and see if mysql is running
>with multiple system scope threads?
>
>  
>
  PID USERNAME PRI NICE   SIZE    RES STATE  C   TIME   WCPU    CPU COMMAND
  642 mysql     96    0   284M   250M select 0  67:13  1.37%  1.37% mysqld
  642 mysql     20    0   284M   250M kserel 1  67:13  1.37%  1.37% mysqld
  642 mysql     -8    0   284M   250M biowr  1  67:13  1.37%  1.37% mysqld
  642 mysql     20    0   284M   250M kserel 1  67:13  1.27%  1.27% mysqld
  642 mysql      4    0   284M   250M sbwait 1  67:13  0.93%  0.93% mysqld
  642 mysql     20    0   284M   250M kserel 1  67:13  0.00%  0.00% mysqld
  642 mysql     20    0   284M   250M ksesig 1  67:13  0.00%  0.00% mysqld
  642 mysql     20    0   284M   250M sigwai 1  67:13  0.00%  0.00% mysqld
  642 mysql      4    0   284M   250M sbwait 1  67:13  0.00%  0.00% mysqld
  642 mysql      4    0   284M   250M sbwait 0  67:13  0.00%  0.00% mysqld

>Libc_r use to have the same exactl problem with MySql if I recall.
>
>  
>
Cannot recall that happening to me, though I´ve been mostly using 
linuxthreads due to the performance increase they give.

>We need to get someone familiar with mysql to help figure out
>what is going on.
>
>  
>
Pete