MySQL / apache tuning

[Robin Chen]

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.
>>    
>>