Hi Tom,
As another user of MySQL on FreeBSD, I can tell you from my own
experience that the MySQL Team is dedicated to having MySQL run on as
many platforms as possible. I say this as an almost direct quote from
e-mail Monty sent me. Things were not always smooth with FreeBSD
threads, it is only through quite a bit of work by some dedicated
people that this has smoothed out. There are still issues that
remain, but they are not with MySQL. They MySQL Team has gone out of
thier way to help debug OS threads problems. I imagine more emphasis
will be placed on reliable pthreads libraries when the new threads
based apache web server moves out of alpha test phase and onto
production systems.
It is not easy to debug these these type of things, the main issue is
getting some who understands threads debugging on the OS involved to
look at the code and/or writing a test program that duplicates the
problem. Neither of these is a trivial task, and of course the MySQL
team needs to feed thier families, and continue to move the product
forward. I and my company support MySQL AB (to make it clear) in both
words and financialy (I have a login support contract). They are a
dedicated hard working group, and I am sure they are as interested as
you in the problems on NetBSD, however I think it is amazing that they
run on as many platforms as they do now without problems! But there
is a limited amount of resources to go around, and as there are more
Linux (mysql) users than FreeBSD, problems tend to get noticed and
fixed there first. I think it might be similer with NetBSD and
OpenBSD, there just less users, therefor less testing and since MySQL
is very USER supported there exists less support. I am not saying
anything bad about OpenBSD or NetBSD, just that it seems there are
less users on this list. The more users looking at an issue, the
more likely someone will find the answer/problem.
So in a nutshell what I am saying is you don't have to give up if you
really feel you want to run on NetBSD. Go rally the people together
to find the problem. If you can support financialy do it. If you
support bu collecting the right people, do that. But if the users
don't get involved at some level the problems may not go away, or a
different user group may solve the problem for a different reason (IE
Apache). But the users have to get involved, it's part of what open
source is all about!
Best of luck to you what ever your decison!
Ken
----- Original Message -----
From: "Haapanen, Tom" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 10:05 PM
Subject: MySQL loves FreeBSD (but not NetBSD) ...
> ... or should that be "FreeBSD loves MySQL"?
>
> I finally caved in after a year of increasing (and unexplained)
MySQL
> crashes, despite numerous updates to more recent versions of NetBSD
and
> MySQL, and dozens of experiments with different configuration
options.
> MySQL would die (and restart automatically) every 5-15 minutes on
the
> database server acting as the back end for our web site,
motorsport.com.
> (This on NetBSD/i386, as when we started, MySQL was distinctly
unhappy with
> NetBSD/Alpha)
>
> So I picked up a clean disk, installed FreeBSD 4.3 over the
Internet, booted
> to multiuser, and did "pkg_add -r mysql-server" to installe the
prebuilt
> MySQL binaries. Stopped the server, ftp'd the databases over -- and
it
> worked! Wonderfully, in fact ... in 48 hours now, not a single
crash, and
> the CPU utilization has been quite reasonable, too.
>
> In the end, I suspect that MySQL couldn't deal with the threading
libraries
> available on NetBSD, although I have no proof of this. No other
application
> has given us this much trouble, but nothing else we use uses such
heavy
> threading, either. (We still continue to use NetBSD/Alpha for all
our other
> servers.)
>
> If anyone on the list is running MySQL on NetBSD in a reasonably
busy
> production environment, I would still like to hear about it, though.
>
> Tom Haapanen
> [EMAIL PROTECTED]
>
> --------------------------------------------------------------------
-
> 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
>
>
---------------------------------------------------------------------
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
