On Friday 26 January 2001 13:51, Denis Pithon wrote:
>Hi all,
>
>Yes, it's again a mail about MySQL parallel server and this one is
>quite long... I work for two months to enable MySQL as a parallel
>server on Linux cluster. As you can guess, I encountered a bunch of
>problems !
>
Looks like you have either found a bug in our external locking code, or your
lockd is buggy. Can you first verify that lockd on your setup works properly
by writing a simple program that will update/read within flock(). If that
works correctly, then we need to investgate what is wrong. It would really
help if you could provide us with a repeatable test case and a login on your
system.
P.S. On FreeBSD, people have to use the multi-daemon hack to take advantage
of SMP, as FreeBSD threads cannot do it yet. However, what they do is have
one writer daemon and many readers to reduce lock contention. I think this
setup will give you much better performance than allowing everyone to write.
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <sasha@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
