Re:About Database Connection Pool Sizing
by tyingq on Monday November 12, 2018 @10:25AM
(#18433116)
I see that Postgres has 3rd party projects related to pooling as well, like PgBouncer. Is MySQL's approach particularly worse than other databases?
[ Parent
| on HN ]
Re:About Database Connection Pool Sizing
by thezviad on Monday November 12, 2018 @10:37AM
(#18433185)
I am not as familiar with Postgres as with MySQL, but in this case they would most likely be similarly deficient.
Databases like MySQL and Postgres have optimized on disk storage engines and query planners, but the other parts that are needed for true high availability, and stability at scale are definitely lacking in both.