Optimising mysql
I'm trying to lighten the load on a server. Usual scenario, we've had a customer who's site has literally taken off over night, and is very mysql intensive. We're in the process of moving him, but in the meantime I thought it would be a good idea to optimise mysql.
Server is a P4 2.4 with 2GB RAM.
After some research and looking about. I've made some ammendments, and have my config as follows:
[mysqld]
log-slow-queries = /tmp/slow
set-variable = max_connections=300
set-variable = wait_timeout=10
set-variable = key_buffer=512M
set-variable = max_allowed_packet=15M
set-variable = table_cache=1024
set-variable = thread_cache=64
set-variable = thread_concurrency=2
set-variable = sort_buffer=2M
set-variable = ft_min_word_len=3
Does anyone have any particular changes / tweaks they would suggest to improve performance?
Thanks in advance.
