Can I please get some assistance to determine best settings for a Debian linux server that is dual-core and has 2GB RAM? It is your typical all-around web server running Apache2 (mpm worker), PHP5 (fcgid), MySQL5, PureFTPd.
MySQL is serving around a dozen databases, both MyISAM and InnoDB tables. Biggest databases are 2GB, biggest tables 1.5GB.
I need to tune MySQL so that it doesn’t take all RAM even under heavy load but leaves plenty to Apache and other services running on the server. Before applying values below on live server, I’d like to hear expert opinions on them. )
key_buffer = 128M
query_cache_limit = 1M
innodb_buffer_pool_size = 256M
Thanks in advance!