Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have installed mysql server 5.0 on windows server 2008 R2 64bit OS. max_connection set to 1000 but when 95-100 user connected at a time service stooped. Please help me. I have the following setting in my.ini please check Server have 16GB of RAM

default-storage-engine=INNODB
max_connections=1000<br>
query_cache_size=0<br>
table_cache=256<br>
tmp_table_size=5M<br>
myisam_max_sort_file_size=100G<br>
myisam_max_extra_sort_file_size=100G<br>
myisam_sort_buffer_size=8M<br>
key_buffer_size=1000M<br>
read_buffer_size=64K<br>
read_rnd_buffer_size=256K<br>
sort_buffer_size=212M<br>
innodb_additional_mem_pool_size=2M<br>
innodb_flush_log_at_trx_commit=1<br>
innodb_log_buffer_size=1M<br>
innodb_buffer_pool_size=1024M<br>
innodb_log_file_size=10M<br>
innodb_thread_concurrency=10<br>
connect_timeout=60<br>
interactive_timeout=60<br>
wait_timeout=60<br>
share|improve this question
1  
Are there any relevant messages in your log files ? –  Iain Feb 28 '13 at 8:27
add comment

1 Answer

Check your OS max connection. You could set your max-connection in MySQL to whatever number you want but, if it is more than max connection of your OS then you can't go above that.

share|improve this answer
    
where and how to check os max connection? –  Santu Roy Mar 2 '13 at 4:21
    
have re-installed mysql server and problem solved –  Santu Roy Mar 6 '13 at 17:46
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.