Fine tuning my.cnf MySQL version 4.0.20

Hello,

Me fairly new to Linux and MySQL and need help fine tuning my server

My server Specs:
Cel 1.7 Ghz, 512MB RAM, Fedora Core 1, Apache 2.0.50, MySQL 4.0.20, PHP 4.3.8

I have 12 sites hosted on this server all are using PHP and MySQL

I need fine tuning my mysql, apache and PHP

In peak timing I face extremely slow response of the pages using MySQL DB whereas simple html pages opens fine so I think I need my MySQL need optimization.
below is pasted my.cnf of my server


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


Please suggest the best and optimized setting for mysql server and any other suggestions regarding apache and PHP will be appriciated

Regards
Rizwan

 

 

 

 

Top