I am running Litespeed (with suExec, PHP SAPI), MySQL, DirectAdmin, named on a VPS with a 16-core Xeon CPU and 2GB RAM.
Currently, only 300 MB out of 2048 are used. It might sound a stupid, but how do i make the vps use more RAM?
my.cnf:
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 512M
max_allowed_packet = 8M
table_cache = 4096
sort_buffer_size = 16M
read_buffer_size = 8M
join_buffer_size = 2M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 128M
myisam_repair_threads = 1
myisam_recover
max_heap_table_size = 8M
tmp_table_size = 8M
thread_cache_size = 8
thread_concurrency = 8
query-cache-type = 1
query_cache_limit = 4M
query-cache-size = 16M
log-slow-queries=/var/log/mysqlslowqueries.log
local-infile = 0
wait_timeout = 10
interactive_timeout = 15
max_connections = 35
character-set-server = utf8
default-character-set = utf8
skip-networking
skip-federated
skip-symbolic-links
skip-innodb
[mysqldump]
quick
max_allowed_packet = 32M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 4M
write_buffer = 4M
[mysqlhotcopy]
interactive-timeout
[isamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M
[mysqld_safe]
open-files-limit = 8192
I actually do need to increase MySQL performance because it's the most cpu-consumming process and there are queries that can't be optimized but take some time to execute.
Any suggestions on how to efficiently use memory to increase performance would be appreciated.