>> AFAIK you can compile mysql on FreeBSD with LinuxThreads (they have
>> been ported on FreeBSD). In this case threads will spread across the
>> CPUs as on Linux.
JZ> Funny you mention that... It comes up once in a while, but almost
JZ> everytime it's someone saying "I've heard that you can..." I've yet to
JZ> meet someone who does it and likes it.
JZ> I'm not saying it's bad, but it just seems like one of those things
JZ> that people suggest but don't actually have experience with.
Ok. I did not compile MySQL with LinuxThreads on FreeBSD myself. I
have no idea how to do it because I never tried to do it. But I do
know that production server owned by company at which I work do run
MySQL with LinuxThreads on FreeBSD. After switch on MySQL with
LinuxThreads it was possible to see that perfomance was
increased. Output of 'show proceslist' shows that MySQL server is much
less loaded (because it handles requests faster) than before. Also
people who tested it on test server before deploying on production
said that it worked faster.
This is real experience.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/) |
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 |
| AGAVA Software Company (http://www.agava.com/) |
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
