Date: Tue, 24 Jun 2003 17:29:51 -0700 From: Robin Chen <robinche@vividnet.com> To: Ralph Forsythe <rf-list@centerone.com> Cc: freebsd-isp@freebsd.org Subject: Re: MySQL / apache tuning Message-ID: <3EF8ECFF.7020302@vividnet.com> In-Reply-To: <Pine.LNX.4.44.0306241806230.15159-100000@blue.centerone.com> References: <Pine.LNX.4.44.0306241806230.15159-100000@blue.centerone.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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. >> >>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3EF8ECFF.7020302>