Date: Fri, 11 May 2007 11:22:29 +0200 (CEST) From: Martin Blapp <mb@imp.ch> To: Abdullah Ibn Hamad Al-Marri <almarrie@gmail.com> Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: MySQL slowness in SMP Message-ID: <20070511112011.U2786@godot> In-Reply-To: <499c70c0705110212h400d2466wdf4d2fce6ef41884@mail.gmail.com> References: <499c70c0705110107u77f96543le8e2017cda71b67a@mail.gmail.com> <20070511105652.S2786@godot> <499c70c0705110212h400d2466wdf4d2fce6ef41884@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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/ >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070511112011.U2786>