MySQL tuning, need expert suggestions
I only run ONe site on my server, XP2500 with 1G DDR, cpanel.
Here is my TOP
17:24:02 up 1 day, 16:24, 1 user, load average: 0.27, 0.23, 0.12
135 processes: 133 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: 2.5% user 1.1% system 0.1% nice 0.0% iowait 96.0% idle
Mem: 998592k av, 984152k used, 14440k free, 0k shrd, 122948k buff
687692k actv, 24k in_d, 27100k in_c
Swap: 2048276k av, 135436k used, 1912840k free 532360k cached
as you could see that loading is low but I have started using cache and it is still growing!!! now it is 130mbs
my my.cnf is as follows, Ihave tuned it for a while.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=16M
query_cache_type=1
max_connections=500
interactive_timeout=10
wait_timeout=15
connect_timeout=10
thread_cache_size=64
key_buffer=20M
join_buffer=1M
max_allowed_packet=16M
table_cache=512
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=2M
tmp_table_size=32M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=16M
log-bin
server-id=1
is it ok to have BIG cache? I once had 700MB with only that site, it is a php/MySQL forum,IPB board.
thanks for your kind helps
