... 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
tomh@stripped
