optimize my.cnf file

[noworyz]

I am working on getting the VPS I have being setup to best performance and I have seen a lot of talk about changing the my.cnf file for mysql as this seems to be the major performance issue I am having.

Here is the my.cnf for my server which is the default that came with it (except for the slow queries.

Does anyone know what I should do to this file to better the server or know of any resources to tell me what settings to do?

My server specs are:

CPU: AuthenticAMD, Dual-Core AMD Opteron(tm) Processor 2212
Version: psa v8.1.1_build81070423.15 os_FedoraCore 6
OS: Linux 2.6.9-023stab043.1-smp
HD: 25GB Hard Drive Space (3GB Used)
RAM: 1GB Total (about 280 MB used)



Here is 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