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

From: Uwe Doering (gemini_at_geminix.org)
Date: 03/02/04

  • Next message: ei02435_at_student.estg.iplei.pt: "what raid system should i purchase for freebsd ?" 
    Date: Tue, 02 Mar 2004 12:07:15 +0100
To: questions@freebsd.org

    dap wrote:
    > 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.

    MySQL always uses threads. It's just that you have the choice which
    implementation to use, native or Linux threads.

    > 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.
    > [...]
    > 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.
    > :)

    There have been some fixes lately to 'libc_r', the threads lib MySQL
    uses by default on FreeBSD 4.x. They deal with EOF conditions in
    connection with write(2) which may very well cause process looping.
    This programming error could be the cause of your problem as well, so it
    might be worthwhile to take a look at the latest CVS commits to
    'uthread_write.c':

    http://www.freebsd.org/cgi/cvsweb.cgi/src/lib/libc_r/uthread/uthread_write.c?sortby=date&only_with_tag=RELENG_4

    BTW, a potentially serious problem with signals in 'uthread_join.c' has
    been fixed recently, too.

    Hope it helps in your case.

        Uwe 

    -- 
Uwe Doering         |  EscapeBox - Managed On-Demand UNIX Servers
gemini@geminix.org  |  http://www.escapebox.net
_______________________________________________
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: ei02435_at_student.estg.iplei.pt: "what raid system should i purchase for freebsd ?"

    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: Experiences with mysql_pconnect?
      ... talk to a MySQL 5.0.45 DB on an Apache 1.3 series server. ... dangling connections to the server at the php.net site. ... especially when the server is remote as it requires multiple calls to MySQL. ... queries that you execute on a regular basis, preparing it and then ...
      (comp.lang.php)
    • Re: Experiences with mysql_pconnect?
      ... talk to a MySQL 5.0.45 DB on an Apache 1.3 series server. ... dangling connections to the server at the php.net site. ... > Using prepared statements will probably speed up your app a lot. ... especially when the server is remote as it requires multiple calls to MySQL. ...
      (comp.lang.php)
    • Re: Reducing load for LAMP app?
      ... MySQL: as much as possible, he keeps query results in RAM, but ... His hoster says that Apache server is under significant load. ... Using apc is pretty much transparent, but memcached will require modifying your database abstraction layer using the memcached functions. ... With persistent connections, you must have the maximum number of connections *ever* required allocated *all of the time* - even if no one is using your server. ...
      (comp.lang.php)
    • Re: [PHP-DEV] [PHP4] Logging native PHP function calls
      ... X (number of mysql usernames) ... If you really have 150 MaxClients in httpd.conf and 140 mysql ... 15,600 mysql connections is a LOT of connections, and will take a LOT ... I've never tried to run a server with 140 mysql usernames, ...
      (php.general)