MySQL slowness in SMP

[Martin Blapp]

Hi,

Ohh, I overread that you already use libthr.

But ...

> 90293 mysql        19 100    0   434M   187M ucond  1 176.6H 95.95% mysqld

It looks like you did not turn on 'showing threads' in top, else you would
have seen that many mysqld's are running on cpu 0, other on cpu 1.

--
Martin

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