Suggestions For Server Optimization

[.om_merged]

Well I have just upgraded to mysql 5...Need some help with configuring the server

here is my my.cnf

I got a 1 GB RAM with 2.8 Ghz p4 operating Cent OS

[mysqld]

skip-locking

max_connections=350

interactive_timeout=15

connect_timeout=15

key_buffer_size=128M

join_buffer=1M

record_buffer=1M

sort_buffer_size=2M

myisam_sort_buffer_size=32M

table_cache=768

read_rnd_buffer_size=768K

thread_cache_size=32

max_allowed_packet=16M

max_connect_errors=10

read_buffer_size=1M

wait_timeout=15

query_cache_limit=1M

query_cache_size=16M

query_cache_type=1

thread_concurrency=4

skip-innodb

safe-show-database

old-passwords = 1


[mysqldump]

quick

max_allowed_packet=16M


[safe_mysqld]

err-log=/var/log/mysqld.log

pid-file=/var/lib/mysql/mysql.pid

open_files_limit=8192

[bfarber]

How much activity on the server? 1GB of RAM is low for a server, but if it's not overly active it shouldn't be a huge deal.

[.om_merged]

well we have two major sites running...they both have over 100 users on each at any one time...goes till 200-300 at times..maybe more..you think having a 2 GB RAM improve the performance dramatically...in a couple of months I was thinking of moving over to a dual xeon actually...but for now I need to manage with the current config.

[bfarber]

2GB is still low. I'd be looking at around 4GB

If this server could be taking in 600 connections at once, it needs the memory to be able to handle it.