Increasing MySQLD SuperUser Slots

Question

In my office we sometimes have servers that hit the max_connections limit. As we sometimes have scripts that take up that 1 extra 'superuser' slot for MySQLD, we'd like to raise that.

Google really hasn't turned up much on this, is there a way to raise the number of slots?

Answer 1

You might want to investigate the following options:

• increasing max_connections to a reasonable amount
• timing out idle connections
• using persistent connections