On Sat, Jun 02, 2001 at 01:49:59PM +0400, Ilya Martynov wrote:
> >> 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.
Good to hear. I've heard similar reports from others. I'm going to
have to find the time to try this myself.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 17 days, processed 133,432,323 queries (86/sec. avg)
---------------------------------------------------------------------
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
