[Preston] Optimising Apache/MySQL !

[Kevin Porter]

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