1

Unlimited connections, how do I edit that setting?

Alex
  • 8,111
  • 24
  • 71
  • 99
  • 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 05 '10 at 16:15

1 Answers1

4

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.

Warner
  • 23,440
  • 2
  • 57
  • 69