|
Up your system memory. Then adjust these values:
net_buffer_length=8K
max_connections=1000
max_connect_errors=5000
key_buffer=768M
max_allowed_packet=2M
table_cache=2048
sort_buffer_size=2M
read_buffer_size=2M
thread_cache=64
thread_concurrency=8
myisam_sort_buffer_size=64M
wait_timeout=300
delayed_queue_size=10000
query_cache_size=96M
query_cache_type=1
As you get more memory up the key_buffer. It should be around 1/3rd your system memory. I would go for 4GB ram if you can and up the key_buffer to 1024M. To get it tweaked better I would need to see the "mysqladmin extended" info. Also if this is a custom design you should make sure you have proper indexing.
Brad
__________________
Your sig chose me! 
|