mysql load issues
I admin a very busy forum that has around 150k members. Generally at busy times we have around 1000 active members posting and browsing. We have a dedicated server for apache and another for mysql. They are connected over a gigabit network. My load is around 20ish for the mysql serverHere is the server specs. They are the same for both servers
Dual Xeon 2.66GHz HT enabled
2gig RAM
2 10k SCSI drives
Here is my status for mysql
Code:
Uptime: 429 Threads: 57 Questions: 101487 Slow queries: 3 Opens: 575 Flush tables: 1 Open tables: 569 Queries per second avg: 236.566
Code:
total used free shared buffers cached Mem: 2026 1483 542 0 57 1225 -/+ buffers/cache: 200 1825 Swap: 1992 0 1992
Code:
top - 19:23:37 up 23:34, 2 users, load average: 9.85, 10.45, 11.14 Tasks: 276 total, 1 running, 275 sleeping, 0 stopped, 0 zombie Cpu0 : 22.6% us, 3.4% sy, 0.0% ni, 72.8% id, 0.4% wa, 0.2% hi, 0.5% si Cpu1 : 19.6% us, 2.3% sy, 0.0% ni, 77.3% id, 0.7% wa, 0.0% hi, 0.1% si Cpu2 : 23.8% us, 2.6% sy, 0.0% ni, 73.1% id, 0.5% wa, 0.0% hi, 0.1% si Cpu3 : 17.2% us, 2.0% sy, 0.0% ni, 80.1% id, 0.7% wa, 0.0% hi, 0.1% si Mem: 2075104k total, 1512832k used, 562272k free, 59196k buffers Swap: 2040244k total, 0k used, 2040244k free, 1255104k cached
Code:
[mysqld] max_connections = 800 skip-locking key_buffer=512M join_buffer=1M record_buffer=1M sort_buffer=2M table_cache=1028 thread_cache_size=286 max_allowed_packet=5M query_cache_limit=1M query_cache_size=32M query_cache_type=1 thread_concurrency=8 query_cache_limit=4M query_cache_size=64M query_cache_type=1
Thanks