Re: Peter Zaitsev: Best way to use 10,000 connections with MySQL

[Peter Zaitsev]

Well,

The queueing on OS level works but for different purpose - it allows you to handle spikes with a lot of connections being established at the same time.
Otherwise you might get "connection refused" error.

It is not really going to queue connections on OS level unfortunately because MySQL will always try to accept connection as fast as it can. But if it is out of max_connections it will close connection with error code just after accepting.

If MySQL would behave same as Apache - waiting for slot to open before calling accept that would work.

This works for Apache but it is mostly helpful for handling spikes of a lot of connects comming at the same time. If you have slow clients and you need 200 apache children to feed them you will not get away with 40 and large backlog. The queue will simply grow until it is full :)