On Thu, Jul 08, 2004 at 09:23:17PM +0300, Egor Egorov wrote: > Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > > >> >> > So I haven't really done much to optimize things, as this seems like a > >> >> > fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux > >> >> > Threads). > >> >> > >> >> Reliability and performance is not what you should expect to find in > >> >> FreeBSD 4.x. MySQL doesn't perform well on it because of threads problems > >> >> in OS itself. > >> > > >> > We're happily running MySQL on FreeBSD 4.x w/LinuxThreads at Yahoo. > >> > So I'm not sure how you back that claim. > >> > >> http://jeremy.zawodny.com/blog/archives/000203.html and so on. :-) > > > > Assuming one follows the *bold* "UPDATE" link at the top, I still > > don't see it... > > What about SMP machines?
Many of our MySQL/FreeBSD 4.x/LinuxThreads machines are SMP. > In general the experience may vary but I have been unable to manage > it to work fine. :( Like, updating the key_buffer variable on the > fly to enlarge it causes the computer to hang at a certain point. I > had LOTS of os-dependent things like that. How is that not a MySQL bug? :-) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]