How can I improve MySql Configuration?
Let me start by saying my site has about 40-100 players completing at least one action during any given minute period. Its a Web Based MMORPG and heavy on MySql Usage.
My server is a...
P4 w/ hyperthreading
2gb RAM
Here is my current MySql Configuration...
[mysqld]
max_connections=500
query_cache_type=1
query_cache_limit=1M
query_cache_size=32M
key_buffer=96M
join_buffer=512k
read_buffer=512k
read_rnd_buffer=512k
record_buffer=512k
sort_buffer=768k
table_cache=200
thread_cache_size=32
max_allowed_packet=1M
thread_concurrency=2
safe-show-database
If you need anymore information I will be happy to give it. If you can recommend anything that can help with speed, please let me know. Also it has been brought to my attention that about once a day my site has 'apache fail' and gets automatically restarted.
Regards,
-Dusk
