[Preston] Optimising Apache/MySQL !

[Colonel NFT]

Thanks Bob....I will start hacking again tonight !  Unfortunately, I
live in Perth now so cannot make it to Preston !

Thanks again

On 2/6/07, B McLellan <bob.mclellan at gmail.com> wrote:
> Its a while since I did this and I don't access to the box anymore (it
> was at a previous workplace) so i'm struggling to remember the
> details, but it did take quite a bit of trial and error to get right.
> There's a tutorial in this months Linux format or here:
> http://www.databasejournal.com/features/mysql/article.php/10897_1402311_2
> which basically describe what i did. Starting the server and using
> show status to see which variables are misbehaving and then editing
> them in my.cnf directly. You might also be able to optimise your
> code/table structure to lessen the load on the server. Could be a
> possible discussion point for tonights meeting, but I'm afraid I can't
> make it this month.  :(
>
>
> On 2/6/07, Colonel NFT <colonelnft at gmail.com> 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 !!!
> >
>
> _______________________________________________
> Preston mailing list
> Preston at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/preston
>