The max-connections tag has no wiki summary.
0
votes
0answers
39 views
MySQL max_connections Changed Without Notice
I'm running a Linux (512MB of RAM) server with MySQL 5.1.
I host an app that is used by a small # of users (less than 50). Everything has been working fine until yesterday, connecting to my DB would ...
4
votes
0answers
68 views
Does PgBouncer create a separate pool for every database config entry?
If I set up a pgbouncer.ini config file with several database entries, does pgBouncer create a separate pool for each one? I would think so, but have not been able to confirm this.
For example, ...
2
votes
0answers
72 views
How to properly configure pgBouncer transaction level pooling?
What is a good way to determine the number of available transaction connections when using pgBouncer to pool database connections? Also, how should I determine the number of max_connections and ...
0
votes
1answer
157 views
mysql fine tuning: open_tables, opened_tables
I'm a novice to database administration and have been depending on forum suggestions and answers to help resolve my database hang ups and too many connections errors; I've managed to reduce the ...
0
votes
1answer
162 views
Show processlist / Max concurrent connections seem to max out at 131
When I put my database under a load test (basically just a basic write and basic read from our app), and run show processlist; in the middle of it, there is always 131 rows in the set and that's it. ...
0
votes
1answer
56 views
Mysql not closing connections
I have a Java application that configured with a connection pool. I have ensured that the application terminates the connections properly.
However when I run this command on mysql command line -
...
0
votes
0answers
26 views
Max connections sql server express could have? [duplicate]
Possible Duplicate:
Max connections SQL Server Express could have?
I have sql server 2005 express edition installed on one of my client's machine, and lots of other users are also connected ...
3
votes
1answer
150 views
Named pipes connection closed when subjected to load
We're hosting a service where we have a messaging service. When a message arrives, it checks which subscribers it should be sent to by connecting to the database, and querying the subscriptions ...
0
votes
1answer
541 views
Why does max_used_connections status not get refreshed automatically once it reaches max_connections, even though the Threads_connected falls down
I always wonder, why does the max_used_connections value not come down, once it reaches the peak value of max_connections?
I always flush the status and bring down this value to avoid DB connection ...
1
vote
2answers
439 views
Too many TIME_WAIT connections in PostgreSQL
I am using PostgreSQL 9.0 on Centos 5.7 Final.
At any given there are around 1,500-2,200 connections open for PostgreSQL on port 5432 which are in TIME_WAIT state.
I have a feeling this is not good.
...
1
vote
1answer
125 views
Sudden MySQL connection issue
We have almost 60 network guys working via a proxy server, developing on one Linux-based in-house server.
Suddenly, it is saying to everyone:
Warning: mysql_connect() [function.mysql-connect]:
Too ...
1
vote
1answer
131 views
“Mysql server has gone away” debugging methods
I have been repeatedly facing the issues with mysql on my server recently. I have tried changing "wait_timeout" , "connect_timeout" and several options which I found using google. Are there any ...
1
vote
2answers
460 views
Is problem with parallelism more common today than before? And what issues can arise from paralellism?
This is a very general question so I don't give much specific information. I am more interested in parallelism and its possible drawbacks. Generally I am all for parallelism as something useful and ...
4
votes
1answer
975 views
What are user connections - when are the created and destroyed?
We've been getting an intermittent error on out site:
Warning: mysql_connect() [function.mysql-connect]: User '557574_prod' has exceeded the 'max_user_connections' resource (current value: 10)
...
14
votes
3answers
8k views
How do you calculate mysql max_connections variable?
How do you calculate mysql max_connections ?
What do you take into consideration ?
