PHP? MySQL? Or both?

From: Parker Morse (morse_at_sinauer.com)
Date: 08/29/03

  • Next message: Felix Mathais: "Re: Felix?" 
    To: redhat-list@redhat.com
Date: Thu, 28 Aug 2003 19:29:07 -0400

    I'm using RH 9.0 to run our web server. We set it up in the colocation
    center on Monday and moved eight of our ten sites in on Monday and
    Tuesday. Three of the sites already moved are PHP/MySQL sites.

    Intermittently, the database connection function in PHP will fail for
    two of those three sites. (I checked, and the function is identical,
    except for user/password/database arguments, between the three sites.)
    mysqld is still running on the server; however, if I restart mysqld,
    the sites resume working.

    I haven't been able to deliberately crash the sites, nor have I been
    able to confirm absolutely that it only affects the two sites. System
    load doesn't appear to be an issue; the only time I've seen load
    average approach 1.0 was when I did the initial fcheck run. I also
    checked the users in mysql, and all three have identical permissions.
    Nothing helpful in any error logs.

    Right now I have a kludge going where the failure case in the database
    connect function drops a file in a particular path (much like a
    lockfile) and a perl script (run every five minutes by cron) restarting
    mysql (and deleting the file) if it finds that file present. Not a real
    good option for long-term site operation (but handy, I suppose...)

    How can I figure out if the problem resides with MySQL (suggested by
    the fact that a mysqld restart helps - resource issue?) or with PHP
    (suggested by how it doesn't affect all three sites)? I'd like to get
    this sorted before I move the two last (and biggest) sites out of
    shared hosting.

    Thanks for any hints...

    pjm 

    -- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
  • Next message: Felix Mathais: "Re: Felix?"

    Relevant Pages

    • Re: Stability issues with FreeBSD + MySQL
      ... The system seemed to perform fairly well with FreeBSD 5.3/5.4, ... >> web server will fail to connect to the mysql server, ... I was very liberal with this value on both the web server and the ... > in which case persistant connections might help; ...
      (freebsd-questions)
    • Searching python-list and MySQL
      ... I have not found a way to conveniently search the archives of this mailing list. ... I've successfully hooked python up with PostgreSQL, but this MySQL thing has been more difficult. ... In order to create this python module, it appears I've got to create it on a server with mysql and mysql-devel, and various other items, and then move it to the web server. ...
      (comp.lang.python)
    • chroot, apache & mysql.sock
      ... EL3 w/ Apache, MySQL & PHP config. ... The web server and ssh are the only ... assign each company their own chroot jail running Apache w/ PHP using ...
      (comp.os.linux.security)
    • Re: Cannot get mysql_connect to work
      ... You configure a web server for a document root (that's what Apache ... MySQL uses local UNIX-domain (at ... This will have problems if your MySQL client ... the socket. ...
      (comp.lang.php)
    • Re: PC requirements for this configuration.
      ... It would be a web server having 3000 hits a day, ... doing some PHP and MySQL scripts. ...
      (comp.unix.bsd.freebsd.misc)