connection pool for MySQL

[Anon]

Hi,

I use MySQL and I often get this error message: "Too many connections" even I increase the number of max_connections for MySQL. Is it possible to create a "connection pool" to reduce the necessary connections?

Thanks 🙂

[[deleted]]

One MySQL connection can handle one query at a time, so if you have 200 scripts running that all need to use the mysql database, you'll need 200 connections to the database, and that's pretty much it.