Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
73 views

Does “Connect” statement for every query indicate broken connection pooling?

there's only one client application running queries against a MySQL instance. After enabling MySQL's general query log (configured to log every query) I noticed that every query starts with a ...
2
votes
1answer
95 views

High Number of Connections

The below query tells me there is a total of 520 connections to our SQL Server database. Status of all is 'sleeping' except for 4 connections. The login_time goes back to 2 days ago on some ...
0
votes
0answers
242 views

ORA-12516 but max_utilization not reaching limit

Our app began to raise ORA-12516, TNS:listener could not find available handler with matching protocol stack errors, and I'm trying to diagnose why. The workload has not changed, so I think we might ...
0
votes
0answers
53 views

How can I check the number of TCP/IP connections in MySQL's Connection Queue ( back_log )?`

I'm chasing connection issues with a very busy MySQL server and I've increased the back_log setting from the default of 50 to 2048. I can see that the setting has taken affect in the DB, but I was ...
7
votes
3answers
238 views

“When a connection is closed and returned to the pool, the isolation level from the last SET TRANSACTION ISOLATION LEVEL statement is retained”?

The MSDN online article "Snapshot Isolation in SQL Server" states: "An isolation level has connection-wide scope, and once set for a connection with the SET TRANSACTION ISOLATION LEVEL statement, ...
2
votes
1answer
63 views

When should I start using connection pooling?

I have a MySQL database that peaks at about 300 connections/sec. What is the recommended connections per server and at what point should I start using connection pooling?
0
votes
0answers
248 views

What is the ideal connection pool size for RDS MYSQL?

I have a tomcat server hosting REST APIs. It is connected to a MySQL (RDS Instance) server on the backend. A majority of the operations are write operations (Around 75%). I'm using the Tomcat's ...
1
vote
1answer
257 views

How to handle connection pooling for massive multi-tenancy/multi-schema environment

Here's a quick run down of the situation: We have 1 Schema per customer. We have 2000+ customers. We have 50+ Database servers (with the above schema's distributed unevenly amongst them). We are ...
0
votes
1answer
372 views

connection pooling, transactions, nested transaction and rollback

I've got strange behavior on production. First user request thru application failed, I've got SQLServerException with "Lock request time out period exceeded." After that following requests are ...
2
votes
0answers
137 views

Sleeping connections

I have a dedicated MySQL server(8GB) with following configuration. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql lower_case_table_names = 1 ...
16
votes
1answer
5k views

Connection pools being reset with Error: 18056, Severity: 20, State: 46. & Perfmon Counters not showing

We are using SQL authentication & .net 4.0 Connection strings to connect to an Enterprise Edition 2012 SP1 SQL Server on a windows 2008r2 Enterprise Server. We use about 50 Servers split into 8 ...
1
vote
2answers
327 views

Mysql Connection Pooling Similar To PostgreSQL's PgBouncer

I'm looking for a pooling solution for mysql that is independent of the language. I am using PGBouncer as an example because it Resides on the server the database is on Just change the connection ...