The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
46 views

Find the last SQL statement executed for a given connection

MySQL running on Windows 7 64 bit. I'm trying to track down a leak of connections, I'm pretty sure the only ASP.NET app using the server is at fault here. We received the "Too many connections" ...
0
votes
3answers
71 views

Can we restrict the number of connections to a database in SQL Server?

I have a database on SQL Server. My web application contacts this database. Is there a way in which I can restrict the number of connections to this database through some settings on the SQL Server?
0
votes
1answer
151 views

MySQL max_connection value

Questions I got a 12 GB machine with apache & myqsl, i have may apache max_client set to 150 will this cause some bottlenecks with the 50 max_connection in mysql? What value should I set mysql ...
1
vote
2answers
592 views

How can I determine the maximum possible number of threads?

What factors determine the maximum possible number of threads mysqld will create? I only care about consideration for mysql and not limitations that may be imposed by the operating system. Further, I ...
0
votes
0answers
47 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 ...
0
votes
0answers
196 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
2answers
354 views

multiple connections on MySQL database with no users on httpd

My database seems to have many open connections despite having no users on httpd. mysql> SHOW PROCESSLIST; ...
0
votes
1answer
395 views

Why does max_connections in my.ini not match concurrent connections in Mysql instance config wizard?

MySQL 5.1.x | Windows Server 2003 Can someone please clarify why max_connections in my.ini is much larger than the manual value I specify in the Concurrent Connections Dialogue? For example, if I ...
3
votes
1answer
223 views

Does the mysql parameter “max_connections” apply for unix socket connections?

The documentation does not specify if max_connections apply only to TCP connections. The way it is said, it looks like it does apply for any kind of connection, but I'd like to be sure because ...
0
votes
1answer
5k views

How to get rid of “maximum user connections” error ?

I am using MySQLi for my webapp but whenever I want to visit some particular page, I get mysqli_connect() [function.mysqli-connect]: (42000/1203): User ***_user already has more than ...
0
votes
1answer
693 views

MySQL PDO Cannot assign requested address

Can someone help me with this error? [08-Apr-2013 17:44:08 Europe/Berlin] PHP Warning: PDO::__construct(): [2002] Cannot assign requested address (trying to connect via tcp://****:3306) in ...
0
votes
0answers
75 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
1answer
443 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
295 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
976 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 ...
1
vote
1answer
1k 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
494 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
29 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
285 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 ...
1
vote
1answer
3k 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
1k 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
177 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
379 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
948 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
1k 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) ...
18
votes
3answers
13k views

How do you calculate mysql max_connections variable?

How do you calculate mysql max_connections ? What do you take into consideration ?