The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
28 views

Unresponsive database, sleeping processes

my mysql database suddenly became unresponsive: OperationalError: (2003, "Can't connect to MySQL server on '<IP_address>' (110)") After killing the processes: ...
1
vote
1answer
34 views

Proxy authentication for PostgeSQL

The following seems likely to be a fairly common situation, but I haven't seen any solutions. I have a PostgreSQL database containing views that are specific to the $user, in order to restrict data ...
0
votes
0answers
27 views

DSN connection and RODBC on windows 8

I wish to run queries on a PostgreSQL database in R using the RODBC package. Before I had windows 7 and it was working but now trying to make it work on windows 8 I have not yet succeeded to find ...
3
votes
2answers
74 views

0xDBE how to connect over local socket?

I want to connect to mysql over socket. This is what I'm trying to do: and it's not working. This is how it works in mysql workbench:
0
votes
1answer
37 views

Postgresql tries to connect to fe80::1, permission denied

I upgraded a couple of days ago to IPv6 on my local test machine and since then I've been experiencing some issue with connecting to my local PostgreSQL server. I set the host to 'localhost', which ...
0
votes
0answers
16 views

How does database connection actually works? [duplicate]

I am wondering, on a practical level : what is a database connection? What does it represent for PHP/Java/Ruby/etc to have an opened connection for instance? What about the MySQL deamon? Does it ...
0
votes
1answer
160 views

How to limit the connections per host in MongoDB?

I'm running a mongo server which accepts connections from other clients through java driver. The thing I have noticed is after a while some users open too many ports, and this prevents other users to ...
1
vote
1answer
65 views

Setting stack-size ulimit for mongodb to reduce connection overhead

I am using MongDB 2.4.9 and working on performance tunung. With reference to the ulimit settings for mongodb, in my linux environment (ubuntu 12.04) the default setting for ulimit -s is 8192. MongoDB ...
0
votes
1answer
71 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 ...
1
vote
2answers
78 views

Analysis Service Connection String

I use sql server 2012, and have multi cube. I can connect to my created cube from Excel (Data Tab\Connections) with windows authentication. How can set permission to SQL Server user on my cube. and ...
0
votes
0answers
30 views

Connecting to postgres server from remote client gives error

I need advice of the following please. I can login to PGAdminIII from my workstation and read/write to my database. However trying to login from the command line gives me an error. After entering ...
2
votes
1answer
93 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 ...
1
vote
1answer
120 views

Get the application name

Is it possible -- does a perfmon counter exist -- that would show the name of the end-user application that is connecting to SQL Server?
0
votes
0answers
24 views

Intermittent Connection Speeds SQL Server 2008

We are having issues with a PHP-based application connecting to an SQL Server database on a separate server. It uses a single PHP page to establish the connection using mssql_connect, and this page ...
0
votes
1answer
65 views

How to avoid/prevent Aborted Connections in mysql

We are using MySQL Version 5.1.73. Database is getting huge number of connections around 600 at one time. I observed Aborted Connections are getting increased from Global Status variables. So I ...