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 utili
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 ha
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]>
---
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
_
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 ar
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
/usr
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 PR
