Need help optimizing my.cnf

[noworyz]

I am new to the whole server management thing and I am kinda enjoying learning it but definitely need some more knowledge.  I need help optimizing my.cnf file for my server as it seems the mysql isn't running the best it should.  I only have like 11 sites on the server with one being the major traffic site.

 

My server is:

 

CPU: AuthenticAMD, Dual-Core AMD Opteron Processor 2212

Version: psa v8.1.1_build81070423.15 os_FedoraCore 6

OS: Linux 2.6.9-023stab043.1-smp

PHP version = 5.1.6 apache2handler

Webserver = Apache/2.2.3 (Fedora)

Database = mysql 5.0.27-log, lock.system=flock

 

The my.cnf file for the server is currently in its default state and doesn't seem to be handling my sites the best it could.  Here is the contents of the my.cnf file

 

[mysqld]

set-variable=local-infile=0

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with mysql 3.x

# clients (those using the mysqlclient10 compatibility package).

old_passwords=1

 

skip-bdb

 

set-variable = innodb_buffer_pool_size=2M

set-variable = innodb_additional_mem_pool_size=500K

set-variable = innodb_log_buffer_size=500K

set-variable = innodb_thread_concurrency=2

log-slow-queries = slow_queries.log

[mysql.server]

user=mysql

basedir=/var/lib

 

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

skip-bdb

 

 

set-variable = innodb_buffer_pool_size=2M

set-variable = innodb_additional_mem_pool_size=500K

set-variable = innodb_log_buffer_size=500K

set-variable = innodb_thread_concurrency=2

 

log-slow-queries = slow_queries.log

 

If someone could please help me figure out what modifications to make to this file to optimize my server I would be greatly appreciated.

 

Thanks

[fenway]

What makes you think it is slow? What shows up in your slow query log?

[noworyz]

there were some queries in there but I have since optimized them.

 

I have just seen a lot of people working on their my.cnf file and they had a lot of settings in it that I do not have.  I just figured that there were some changes I could make to optimize my server.  Is the one I have fine?

 

Thanks

[fenway]

Impossible to say -- there is no "ideal" configuration, depends on load, queries, etc.

[noworyz]

ok, thanks for the info. I guess I hope it works.

 

If it is in need of tweaking someday.  How do I go about figuring out what changes to make?

[fenway]

Depends on the symptions.