FBSD 5.2.1-p4 and mysqld problems

From: Daryl Chance (chancedj_at_yahoo.com)
Date: 04/01/04

  • Next message: FreeBSD Tinderbox: "[current tinderbox] failure on ia64/ia64" 
    Date: Wed, 31 Mar 2004 19:10:36 -0800 (PST)
To: current@freebsd.org

    we are having a couple problems with mysql on FreeBSD
    5.2.1

    the dmesg is located here:
    http://sql.tribalwar.com/dmesg.today

    It's just a generic config with IPv6 removed and the
    ix86 stuff removed (just i686 left).

    one of the problems we are having is that there is 1
    specific table in the db (and it's only 1 database too
    that this happens) is getting corrupted and forcing us
    to have to repair it. This one could just be a
    problem with mysql and it's just accelerated w/ using
    it on FreeBSD 5.x. We haven't nailed any specific
    time that this happens nor any specific
    insert/select/update that could cause it. Is there
    any way to verify (through FreeBSD userland commands
    or ports that you may know of) that this isn't a drive
    problem? Is there something I can run on FBSD that
    will help me to track this problem down (perhaps some
    sort of GEOM logging)?

    the other problem we are having is that mysql will
    lock up. 1 of the mysqld processes freezes (uses up
    all the cpu) and it won't allow anymore queries
    against it until we shutdown. Is there any way for me
    to debug this and find out where it is hanging? Is
    there a working alternative to truss? Or should I
    just compile option PROCFS in and use it next time it
    locks?

    I realize that we shouldn't be running this as a
    production server, but other then these issues with
    mysql, the server and it's webserver counterpart are
    rock solid.

    Should I upgrade to 5-CURRENT and run it for a couple
    days before trying to assuming these are new issues
    :)?

    also, we are running against linuxthreads but also
    get this problem with the default threading in FBSD
    (libc_r?) for 5.2.1

    Daryl

    __________________________________
    Do you Yahoo!?
    Yahoo! Small Business $15K Web Design Giveaway
    http://promotions.yahoo.com/design_giveaway/
    _______________________________________________
    freebsd-current@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-current
    To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org"

  • Next message: FreeBSD Tinderbox: "[current tinderbox] failure on ia64/ia64"

    Relevant Pages

    • 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)
    • What am I doing wrong with MOUNT?
      ... I'm brand new to FreeBSD and Unix world in general. ... I installed MySQL version 3.23 from the ports ... of his database that I had MySQL dump on his FreeBSD server and FTP'd it to ... I mounted the new drive 1 to a temporary mount point and used the cp command ...
      (freebsd-newbies)
    • Re: FreeBSD MySQL still WAY slower than Linux
      ... I hope this can help us out to get MySQL humming on -STABLE, ... >> To make benchmarks a help provided to improve FreeBSD, ... > This box is currently setup to slave from the master. ... > System crashed while simply slaving from the master. ...
      (freebsd-stable)
    • 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)
    • Re: Mysql server not able to stay running on anything but Linux?
      ... >> As you know from various threads on the FreeBSD ... >> significant issue just reproducing the problem. ... > So far we have had only one crash that seemed to have ... >> MYSQL doesn't ...
      (freebsd-questions)