[Preston] Optimising Apache/MySQL !

[B McLellan]

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 !!!
>