[Preston] Optimising Apache/MySQL !

[Colonel NFT]

I optimise and repair all databases at least once a week.  I think
they are configured correctly....it may just be the my.cnf
optimisation that needs concentrating on.

Thanks

On 2/6/07, Kevin Porter <kev at 9ballpool.co.uk> wrote:
> You said there were some 'pretty intensive' sites running.
> Maybe the problem is with one or more of the sites, rather than your
> configuration? A badly
> indexed database will often slow your server down no matter how good the
> config.
>
> regards,
>
> - Kev
>
> Colonel NFT wrote:
> > 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
> >>
> >
> > _______________________________________________
> > Preston mailing list
> > Preston at mailman.lug.org.uk
> > https://mailman.lug.org.uk/mailman/listinfo/preston
> >
> >
> >
>
>
> --
> Kevin Porter
> Advanced Web Construction Ltd
> http://www.9ballpool.co.uk
>
>
>
> _______________________________________________
> Preston mailing list
> Preston at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/preston
>