Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Fine tuning my.cnf MySQL version 4.0.20

[rizwan65]

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

[monaghan]

SQL tuning is not a simple quick fix

You need to look at the queries being run and determine if they could be better written. The default MySQL install should be OK for most things. Quality of the query and lack of correct indexes is usually the biggest problem with any SQL system.

The slow queries log is probably a good place to start.

Have a long read of the mysql.com web site, there's plenty of reading material.

If you want to tune, then you'll need to understand what the database server is being expected to do, then tune to your requirements.