[Preston] Optimising Apache/MySQL !

[Colonel NFT]

Thanks Bob.  I used the mySQL performance tool to tweak my.cnf:

http://www.day32.com/MySQL

However, when I tweak it to satisfy the performance tool....the server
load goes sky high  and I am forced to reboot and revert to previous
my.cnf.

I have even taken the generic huge.my.cnf which is placed in the MySQL
directory on a standard install...but this just slows the server right
down....

I guess I am looking for a happy medium but this is proving to be very
difficult to achieve...The server is a AMD 3200+ and has 1gb of RAM so
it shouldnt be struggling too much with the load but it is !!!



On 2/6/07, B McLellan <bob.mclellan at gmail.com> wrote:
> I have played with this before  ... though it was a while ago. It
> helps to know where the bottlenecks are occuring, apache or mySQL. I
> used basic tools like top to monitor this and discovered that mySQL
> was eating most resources, so i concentrated on my.cnf. In the end
> though I found the best solution was to stick Apache and MySQL on
> their own individual boxes.
>
> On 2/6/07, Colonel NFT <colonelnft at gmail.com> wrote:
> > I run a dedicated server running CentOS 4 which has some pretty
> > resource intensive sites on it....
> >
> > I am trying to optimise my.cnf and http.cnf....Is there anyone onboard
> > who is particularly good at doing this ?
> >
> > _______________________________________________
> > Preston mailing list
> > Preston at mailman.lug.org.uk
> > https://mailman.lug.org.uk/mailman/listinfo/preston
> >
>
> _______________________________________________
> Preston mailing list
> Preston at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/preston
>