Hello,
I have dual xeon server with 2 GB of ram.
FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007
[EMAIL PROTECTED]:/usr/obj/usr/src/sys/NOC i386
Which runs heavily MySQL with MyISAM, the problem I have it maxes out
one cpu, and doesn't use the other one.
Could someone tell me what shall
On 5/11/07, Martin Blapp [EMAIL PROTECTED] 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, [EMAIL
Hi,
So would upgrading to FreeBSD 7.0-CURRENT would make MySQL runs faster
or it's not optimized for dual cpu yet?
Of course would upgrading to FreeBSD 7.0-CURRENT make it faster because
some bottlenecks (unix domain sockets etc, old malloc) have been removed.
--
Martin
Hi,
Ohh, I overread that you already use libthr.
But ...
90293 mysql19 1000 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
On 5/11/07, Martin Blapp [EMAIL PROTECTED] wrote:
Hi,
Ohh, I overread that you already use libthr.
But ...
90293 mysql19 1000 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
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, [EMAIL PROTECTED] [EMAIL PROTECTED]
Martin Blapp wrote:
So would upgrading to FreeBSD 7.0-CURRENT would make MySQL runs faster
or it's not optimized for dual cpu yet?
Of course would upgrading to FreeBSD 7.0-CURRENT make it faster because
some bottlenecks (unix domain sockets etc, old malloc) have been removed.
On the other
On Fri, 2007-05-11 at 11:07 +0300, Abdullah Ibn Hamad Al-Marri wrote:
Hello,
Hi!
I had the same problem, but i found this blog entry from Jeremy Zawodny:
http://jeremy.zawodny.com/blog/archives/000173.html
After i adjusted the wait_timeout and thread_cache_size, the problem is
gone. CPU