MySQL and FreeBSD 4.x.. problems, problems with server

From: dap (dap99_at_i-55.com)
Date: 02/29/04

  • Next message: Rob: "Re: NFS sharing /usr/ports and /usr/src"
    To: <questions@freebsd.org>
    Date: Sat, 28 Feb 2004 23:33:46 -0600
    
    

    This has happened with enough servers at different locations that I have to
    believe there is a relationship here. I have servers running the latest
    release of MySQL. I've run the servers on FreeBSD 4.4., 4.7, and 4.8. I am
    not using the threaded version. On all three versions, on different servers
    at different sites, I have seen MySQL just go wacky after a while.

    Two types of symptoms:

    1. mysqld just decides to consume as much of the CPU as possible.
    2. new connections to mysql fail

    It will usually take 1-3 weeks between occurances.

    I have seen posts relating to this off and on. Is there a known problem with
    running mysqld on FreeBSD 4.x? What about 5.x? Is it better? I was talking
    to another FreeBSD admin the other day and he commented on the same thing:
    "mysqld on our FreeBSD 4.7 boxes just lose it sometimes."

    Honestly, I am thinking of converting out MySQL db servers from FreeBSD to
    Linux for this reason, and only this reason. Otherwise, I love FreeBSD, but
    this is just no good. I would blame myself, but I can't when I get wind that
    others are having the same problem.

    Yes, this is a mysql problem probably, and not a FreeBSD problem. However,
    I'm hoping to get some help or hope here as well as with the mysql people.
    :)

    _______________________________________________
    freebsd-questions@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-questions
    To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"


  • Next message: Rob: "Re: NFS sharing /usr/ports and /usr/src"

    Relevant Pages

    • Re: Do you use MySQL?
      ... Also we have many older pieces of hardware that cannot run a newer version because the older hardware cannot support the newer OS, which in turn is required to run the newest MySQL. ... If we install MySQL 5.0 on my new servers, we cannot use replication to my MySQL 3.23 servers, many of which are the old Sparcs. ... Of course any replacement for the old servers will use a newer version of MySQL, and eventually we will get all our servers running version 4.X. ...
      (freebsd-questions)
    • Re: Memory leak in PHP on FreeBSD
      ... memory leak in php and mysql on FreeBSD. ... considering I run quite a few servers with this setup. ...
      (freebsd-questions)
    • Servers Crash every few days
      ... I have six servers running FreeBSD 6.2 and all of them have the same config. ... Memory for the servers are ... 1000 connection and sometimes when the connections is more 10000. ...
      (freebsd-questions)
    • Re: Windows client - internet connection sharing
      ... >> ADSL line to provide internet access via LAN to a ... > This is all about how you interface your FreeBSD ... > servers and so forth. ... This enables you to set up a 'DMZ' network, ...
      (freebsd-questions)
    • Re: MySQL Performance 6.0rc1
      ... Nevertheless I run a production MySQL on a double-Xeon (Supermicro ... etc) which eventually kill MySQL with FreeBSD ... CPU: AMD OpteronProcessor 246 ... <ACPI PCI bus> on pcib0 ...
      (freebsd-current)