MySQL slowness in SMP

[Abdullah Ibn Hamad Al-Marri]

On 5/11/07, Martin Blapp <mb at imp.ch> wrote:
>
> Hi,
>
> It depends on the threading  library you use. Can you please
> show us the output of
>
> ldd /usr/local/libexec/mysqld ?
>
> You should use libthr instead of libpthread or libc_r in /etc/libmap.conf
> for mysqld.
>
> --
> Martin
>
> Martin Blapp, <mb at imp.ch> <mbr at FreeBSD.org>
> ------------------------------------------------------------------
> ImproWare AG, UNIXSP & ISP, Zurlindenstrasse 29, 4133 Pratteln, CH
> Phone: +41 61 826 93 00 Fax: +41 61 826 93 01
> PGP: <finger -l mbr at freebsd.org>
> PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E
> ------------------------------------------------------------------

Here we go.

ldd /usr/local/libexec/mysqld
/usr/local/libexec/mysqld:
        libz.so.3 => /lib/libz.so.3 (0x28498000)
        libwrap.so.4 => /usr/lib/libwrap.so.4 (0x284a9000)
        libcrypt.so.3 => /lib/libcrypt.so.3 (0x284b0000)
        libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x284c9000)
        libm.so.4 => /lib/libm.so.4 (0x28598000)
        libpthread.so.2 => /usr/lib/libthr.so.2 (0x285ae000)
        libc.so.6 => /lib/libc.so.6 (0x285c1000)

and here is the libmap.conf

[/usr/local/libexec/mysqld]
libpthread.so.2         libthr.so.2
libpthread.so           libthr.so


-- 
Regards,

-Abdullah Ibn Hamad Al-Marri
Arab Portal
http://www.WeArab.Net/