5 ms·
In addition, when you are dealing with many thousand application servers and many hundred database connections, the database will not end up happy having to mai
by HarrisonFisk 13y ago
In addition, when you are dealing with many thousand application servers and many hundred database connections, the database will not end up happy having to maintain > 10k connections.
So you will end up needing to add a proxy or connect every time. As you indicated, since MySQL connections are so cheap (ie. you can do > 50k per second), it is faster and easier to create a new connection each time.
- falcolas 13y agoNot just the database, at those quantities of connections, the OS itself starts to have problems. One frequently implemented solution is to kill off old idle connections, but you may be surprised at how many pooling solutions don't deal with killed connections well (or force the handling on the application at the wrong layer of abstraction).
- jrochkind1 13y ago> it is faster and easier to create a new connection each time. Unless you're creating an SSL connection, right? Did you guys read the same OP I read?