Hello, On a dual core E8500 @ 3.16GHz with 4GB of RAM, 32bit centos I have the followings: set-variable = max_connections=105 safe-show-database long_query_time = 2 log-slow-queries = /var/log/mysql-slow.log log-queries-not-using-indexes query_cache_limit=512M query_cache_size=512M query_cache_type=1 query_cache_min_res_unit=2k table_cache=3072 tmp_table_size=640M max_heap_table_size=592M key_buffer=16M sort_buffer_size=16M read_buffer_size=4M key_buffer_size=150M join_buffer=3M interactive_timeout=8 wait_timeout=18 connect_timeout=10 thread_cache_size=4 thread_concurrency=4 concurrent_insert=2 low_priority_updates=1 Code (markup): What can I do to improve my server performances ? Thanks!
Use tuning primer to improve mysql performance http://launchpad.net/mysql-tuning-primer/trunk/1.5-r5/+download/tuning-primer.sh
Exactly!! Use a 64-bits OS with mysql and the rest going with it. You'll see such an improvement. Otherwise, you can host your mysql server elsewhere as a dedicated mysql server. What does your top command show??