Question about threads [beaver challenge]
Petri Helenius
pete at he.iki.fi
Tue Feb 10 14:39:38 PST 2004
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
More information about the freebsd-threads
mailing list