Re: Mysql server not able to stay running on anything but Linux?

From: Kris Kennaway (kris_at_obsecurity.org)
Date: 10/12/05

  • Next message: Duncan Drury: "Downloading 5.4 i386 - MD5 checksum not working for disc 1" 
    Date: Wed, 12 Oct 2005 17:07:57 -0400
To: NMH <drumslayer2@yahoo.com>

    On Wed, Oct 12, 2005 at 01:16:22PM -0700, NMH wrote:
    > Hi
    > I am stuck with a delema and I feel like a damn
    > troll. But.. I have a Mysql Database that I posted
    > about earlier. It seems that it is only able to not
    > die by running on BSD 4.11 with Linux Threads. My boss
    > is convinced this means that Linux is better for MySQL
    > and wants that installed now.
    > We even got a support contact from Mysql that so far
    > has gotten us nothing for almost a month while our
    > production database server died up to 3 times a day.
    > (and lots of we're looking into it's)
    >
    > We were running fine but a little slow on FreeBSD
    > 5.1-P11 and MySQL 4.0.18.(apperantly before a big Lib
    > change) We had to move quicker than we wanted to a new
    > server running FreeBSD 5.4 and MySQL 4.11 (becouse of
    > a dual HD death) Under production load the new 5.4
    > server fell over regulary. It has only now become
    > stable by wiping it and running it on FreeBSD 4.11
    > with Linux Threads. (it regularly has over 400+
    > threads)

    Unfortunately you'll need to provide details of how it "fell over"
    (e.g. panic messages + backtraces). You might have better luck with
    6.0-RELEASE or 5.4-STABLE, since a number of bugs have been fixed in
    5.4-RELEASE..but without more details it's impossible to say whether
    that will help, or if you're encountering something genuinely new.

    > Can anyone help or offer assistance to help track
    > this down? Perhaps also any annecdotes or examples I
    > can show my boss that other people have as busy MYSQL
    > databases on BSD 5.X. We paid 3K to Mysql for help and
    > so far they have been unable to offer any clues as to
    > why ours will not stay stable on anything but Linux
    > threads. I feel really sad that so far no one has
    > responded to my posts and it feels like a victory for
    > linux.

    If I was your boss I'd be asking why mysql hasn't delivered on their
    support contract.

    Kris

    • application/pgp-signature attachment: stored
  • Next message: Duncan Drury: "Downloading 5.4 i386 - MD5 checksum not working for disc 1"

    Relevant Pages

    • Re: free database server for desktop application with ado.net driv
      ... > I've used MySQL on Windows since its 3.x days, ... If it works at all on linux, ... people who have problems compiling it post about it because they want their own optimizations. ...
      (microsoft.public.dotnet.languages.csharp)
    • RE: FreeBSD 5.3 MySQL Performance
      ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
      (freebsd-questions)
    • Re: SMP performance degradation with sysbench
      ... Linux versions on that machine. ... I've reproduced this on a 8-socket/16-way dual core Opteron. ... I am seeing is that MySQL is having trouble putting enough load into the ... seems to be what the clients and server threads use to communicate with. ...
      (Linux-Kernel)
    • Re: Newbie and Debian.
      ... There is no "the Linux equivalent", ... you want to achieve you could use MySQL or PostgreSQL as I said earlier. ... of PostgreSQL and SQL Server. ...
      (alt.os.linux)
    • Re: FreeBSD MySQL still WAY slower than Linux
      ... is that the Mysql folks have agreed to setup ... >tests to profile mysql on identical hardware running FreeBSD and Linux ... I was seeing the same sort of super-smack numbers that everyone's been ...
      (freebsd-stable)