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?
[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.