Ken Menzel wrote:
>
> I wish someone had told me this when I sent my $3000 for login support. If
> you guy's only don't really have the resources or want to support BSDi it
> would have been nice to know that up front, before we had a problem. I
> hope that the BSDi folks consider this before including MySQL on their next
> release. If I switch to FreeBSD your saying I will not have this problem?
> I'll get the software, shipped overnite. I can also have Linux up right
> away, but I lose support for files larger than 2gig. It's unfortunate,
> maybe I will have to call the sloaris people, and go Solaris/Oracle. I was
> trying to avoid that. I have not been entirely pleased with the stability
> of Linux. Buy I'll go ahead and order FreeBSD if that's what you guy's will
> support I just wish I knew that up front. It would have saved all of us
> alot of time. The BSDi folks will support FreeBSD. I will call them about
> changing over to that. But I will be REALLY pissed if I still have the same
> problem on FreeBSD after reloading my servers.
Ken:
first, let's clear up misunderstanding - it is not that we do not support BSDi -
it is just that it would take us longer to resolve a BSDi issue than it would to
fix a problem on Linux or FreeBSD ( due to the fact that most Linux or FreeBSD
problems have already been solved, as evidenced by our internal testing and use
and the large userbase, who run MySQL without problems), which is the reason why
I suggested changing the OS, if it does not matter to you which OS you run. Like
I mentioned earlier, if running on BSDi is really important to you, we can
really go in depth and try to find out what the problem is - my guess is that is
it somewhere in your BSDi libraries, or possibly a compiler bug, as the kind of
query you have provided should executed only very well tested code in mysqld.
If you want to be 100% sure that the reason your query gave you problems had
nothing to do with MySQL itself, you can give us a dump of your tables involved
in the query, and we can test it on our systems for you. If by any chance the
query will fail, we will, of course, provide a fix. It would actually be a
really good idea to do this first before you start the OS reload.
As far as stability is concerned, MySQL+Linux stability record is much better
than MySQL+BSDi, and is similar to MySQL+FreeBSD. As evidenced by my personal
experience and many user reports, a properly configured Linux system on good
hardware gives you very good performance and uptime.
--
Sasha Pachev
+------------------------------------------------------------------+
| ____ __ _____ _____ ___ http://www.mysql.com |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev |
| /*/ /*/ /*/ \*\_ |*| |*||*| sasha@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+------------------------------------------------------------------+
