Antony T Curtis writes:
> Michael Widenius wrote:
>
> This is a way but not ideal. Linux threading model is very heavyweight
> so you have a performance drop from that. Linux does not scale to very
> many threads due to it's threading model using process ID's.
>
> Reading up the docs on their proposed replacement is very interesting.
> It is very similar to the threading model used in AIX and OS/2 where
> each thread has a "slot id" and with a per-CPU run queue, it should give
> performance and scalability on a par!
>
> ...
>
> Back on to topic... With locking enabled, surely it should be possible
> to run 2 instances of MySQL... And use FreeBSD's NATD round-robin
> processing to "load balance" the connections. Just an idea.
>
>
> --
> ANTONY T CURTIS Tel: +44 (1635) 36222
> Abacus Polar Holdings Ltd Fax: +44 (1635) 38670
> > You have a tendency to feel you are superior to most computers.
>
Hi!
You are right about LinuxThreads and their performance feableness, but
they are not running in user space, thus enabling full use of SMP.
But you should also know that this weakness in LinuxThreads algorithm
only shows up after 400 - 500 threads depending on CPU speed.
And, I do not think that running two instances of MySQL on the same
datadir is such a good idea. I think that it would bring more problems
then LinuxThreads (on Linux, of course).
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
