CPU: Celeron 1.2Ghz (i know

RAM: 256 MB RAM
So, I know this is not much. Also, I am moving over to a more powerful piece of hardware next week (it's ordered). P4-HT, 3ghz, 1 GB RAM and so on.

However since I am experiencing problems now, I'd like to tune it a little if possible. The problem arrises from out of the blue. Suddenly more and more connections stay open and they are not closed immediately. I tweaked the *_timeout settings for mysqld now, but I am wondering if you had more suggestions.
Here is my my.cnf
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
skip-networking
server-id = 1
interactive_timeout = 10
wait_timeout = 10
ServerRoot "/usr/local"
PidFile /var/run/httpd.pid
Timeout 150
KeepAlive On
MaxKeepAliveRequests 200
KeepAliveTimeout 15
MinSpareServers 20
MaxSpareServers 50
StartServers 15
MaxClients 350
MaxRequestsPerChild 100
ListenBacklog 20
LimitRequestFields 40
LimitRequestFieldSize 1000
LimitRequestLine 1000
Thanks for any advice!
Tom
Comment