Question : I would like to say that i have gone through some of the sql blog and MSDN BOL, […]
Tag: max-connections
How can I find the source of postgresql per-connection memory leaks?
Question : I’m using postgresql 9.5.4 on amazon RDS with ~1300 persistent connections from rails 4.2 with “prepared_statements: false”. Over […]
What reason could cause AWS RDS connections to spike
Question : It’s my first time using RDS on AWS, I use a t2.medium instance running MySQL Aurora with default […]
What limits the number of connections?
Question : As per https://devcenter.heroku.com/articles/heroku-postgres-legacy-plans the connection limit is 500 As per https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server “Generally, PostgreSQL on good hardware can support […]
PostgreSQL Correlation Between “max_connections” and “numbackends”
Question : I’m trying to figure out why the field numbackends in pg_stat_database never goes above 16 (and often stays […]
MySQL max_connection value
Question : Questions I got a 12 GB machine with apache & myqsl, i have may apache max_client set to […]
MySQL stalls and strange threads/connections behavior is observed
Question : We have a MySQL instance which most of the time works just fine. From time to time, however, […]
Determine theoretical max connections for MariaDB
Question : I want to upgrade the ram our MariaDB server (10.1.25-MariaDB-1~xenial) to handle more connections. I have been determining […]
Alternating usernames while connecting to mysql database
Question : My server has a max_connections value of 400 and a max_user_connections of 250. Since I am always connecting […]
How to understand the PostgreSQL discrepancy between connection pool recommendation ((2 * n_cores) + n_disks) and support for 100s of connections?
Question : From PostgreSQL docs: Number of Database Connections -> How to Find the Optimal Database Connection Pool Size for […]