Date: 24 Jun 2003 19:31:02 -0600 From: Chris Cameron <chris@upnix.com> To: freebsd-isp@freebsd.org Subject: Re: MySQL / apache tuning Message-ID: <1056504662.1544.24.camel@localhost> In-Reply-To: <Pine.LNX.4.44.0306241532210.8450-100000@blue.centerone.com> References: <Pine.LNX.4.44.0306241532210.8450-100000@blue.centerone.com>
next in thread | previous in thread | raw e-mail | index | archive | help
You could possibly try compiling PHP into Apache rather than using a DSO (assuming you're not already). It makes updating either a pain, but it seems to level out memory use. Chris On Tue, 2003-06-24 at 15:51, Ralph Forsythe wrote: > I need some pointers on tuning a server. System has 1gb of RAM, running > MySQL 3.23.57 and Apache 1.3.27. The web site has at any given moment, at > least 200 people browsing online forums (UBB - uses PHP), which are > entirely mysql-driven. > > I don't have the option of separating the DB out onto another box. What > would some of you recommend for values to properly tune MySQL for this > environment? Any special ways to make Apache run with as little memory > and as much speed as possible? > > I am noticing that the box is using swap space, so obviously some changes > need to be made. The forum in question has over 18,000 members, tens of > thousands of posts, and is updated 24/7 - so I'm thinking a table > optimization wouldn't hurt, but I'm looking for ways to tune the mysql > process itself. What environment variables should I be looking to change > to get this as fast and small as possible? (Yes I know RTFM, I'm looking > more for some answers along the lines of "I've tried this with the same > type of application and got best results with 'x'". > > Basically I want to get this under the 1gb mark with lots of room to spare > (if possible), and increase the overall speed in the process. > > Thanks! > - Ralph -- Chris Cameron UpNIX Internet Administrator ardvark.upnix.net bitbucket.upnix.net -- http://www.upnix.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1056504662.1544.24.camel>