Re: MySQL / apache tuning

From: Robin Chen (robinche_at_vividnet.com)
Date: 06/25/03

  • Next message: Chris Cameron: "Re: MySQL / apache tuning" 
    Date: Tue, 24 Jun 2003 17:29:51 -0700
To: Ralph Forsythe <rf-list@centerone.com>

    Make sure you are not running PHP as CGI, and turn on persistent
    connections for MySQL. You may have to tune the number of allowed
    connection in php.ini. Make sure also that your script is using
    persistent connect to access the database. You might also consider
    putting the database files on a different hard drive or even better
    spanning over a couple drives if that's possible. Slower hard drive
    access = slower look up = more threads being run simultaneously = more
    memory usage.

    For faster PHP parsing, try Zend Optimizer. It's free from
    http://www.zend.com/store/products/zend-optimizer.php

    Not sure if this helps much, but when I compile PHP, I try to strip it
    down as much as possible.. I know I'm not going to use xml, gd, imap,
    sessions, etc so I don't build it in.

    Robin

    Ralph Forsythe wrote:

    >Not my server, not my app, and not an option. :)
    >
    >It's not running too slow at the moment actually (could be a little faster
    >tho), but the memory usage is just outrageous. Ways to "trim the fat" so
    >to speak on mysql would be good, with apache I've been finding some things
    >to try. I did read up on mysql.com's site about my.cnf tuning, however
    >they don't really go into the ramifications of changing variables. I
    >don't want to just follow an example, I want to actually base the numbers
    >off something useful.
    >
    >Thanks,
    >-rf
    >
    >On Tue, 24 Jun 2003, Kevin Lyons wrote:
    >
    >
    >
    >>mysql is not your problem. throw php away and write the app in c.
    >>
    >>

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

  • Next message: Chris Cameron: "Re: MySQL / apache tuning"

    Relevant Pages

    • Re: I am totally stumped..with this on..LOAD_FILE Mysql+PHP= FSCK!!
      ... What I am trying to do is to upload files and stuff them in a mysql database. ... I copied the temporary file to somewhere else, and then handed it to MySQL..THAT WORKED.. ... Is there a way to force a close on the file..maybe that's the problem Mysql is opening a file that is not flushed to disk maybe? ... I gew the feeling its maintaining its own picture of file objects, and doesn't actually flush to the disk unless you do a copy or close php.. ...
      (comp.lang.php)
    • Re: I am totally stumped..with this on..LOAD_FILE Mysql+PHP= FSCK!!
      ... What I am trying to do is to upload files and stuff them in a mysql database. ... I copied the temporary file to somewhere else, and then handed it to MySQL..THAT WORKED.. ... Is there a way to force a close on the file..maybe that's the problem Mysql is opening a file that is not flushed to disk maybe? ... I gew the feeling its maintaining its own picture of file objects, and doesn't actually flush to the disk unless you do a copy or close php.. ...
      (comp.lang.php)
    • Re: com_dotnet
      ... And if MySQL isn't installed, the DLL won't load and phpinfowill show MySQL support isn't enabled. ... The MySQL interface is NOT compiled into PHP on the distributed Windows binaries - or you'd never be able to run PHP unless you had MySQL installed. ... *SOME* extensions are protocols, some are functional resources, and some are just type libraries. ... If you're going to compile the extension into PHP itself, the libraries must be available at compile time, and when you run PHP, or PHP won't load. ...
      (comp.lang.php)
    • Re Re: PHP 5.2.4 <= various mysql functions safemode & open_basedir bypass
      ... > various mysql functions safemode & open_basedir bypass ... PHP is currently very used because it's easy to use. ... Apache has directory restrictions. ... # if the mysql user has perms, ...
      (Bugtraq)
    • Re: [PHP] Select record by ID
      ... But I dont want to be a php copy/paste newb who has no clue ... Bad Guys know that you are probably using that user_id in an SQL ... The mysql_real_escape_string() part is a function provided by MySQL ... mysql_real_escape_stringtakes the 'Kevin O'Brien' and converts it ...
      (php.general)