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

Unlimited connections, how do I edit that setting?

share|improve this question
1  
Please read the documentation provided by MySQL. It's extensive, and it's something you need to learn if you want to run MySQL properly. –  pauska Mar 5 '10 at 16:15

1 Answer 1

There is no such thing as unlimited connections. You must consider system resources, memory usage per thread, as well as types of queries being executed.

If this setting is not properly configured, you risk MySQL running out of memory and restarting, which could result in data loss or corruption.

The support-files directory includes sample configurations, which could be used as starting points. Also, the link below has more a detailed description description with how to tune the setting.

There's also formulae that I like to put in spreadsheets for memory calculation per thread.

share|improve this answer

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.