Sure, this is my current MySQL config:

Code: 
[mysqld]
max_connections = 400
key_buffer = 16M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16M
skip-innodb
 
[mysqld_safe]
open_files_limit = 8192
 
[mysqldump]
quick
max_allowed_packet = 16M
 
[myisamchk]
key_buffer = 32M
sort_buffer = 32M
read_buffer = 16M
write_buffer = 16M
There's also some tips on the Virtualmin site: http://www.virtualmin.com/documentat..._memory_server
Hyperz Reviewed by Hyperz on . Optimizing a VPS Ok so I have my small VPS set up. It only has 256MiB RAM so optimizing some setting and tweaking some stuff would be advised in my case. I installed Webmin, Virtualmin, MySQL, Litespeed (standard), php5 with eAccelerator, BIND, Postfix, etc. All the needed stuff for a webserver basically. Everything seems to be running OK but I want to tweak some stuff to keep mem usage as low as possible. I think MySQL could do with less RAM and that I can disable some unneeded processes. Here's what Rating: 5