4

Error establishing a database connection; how can I determine whether or not these connections are real?

view full story
linux-howto

http://unix.stackexchange.com – I've just run into a problem today with MySQL reaching its database connection capacity. The error I'm receiving is, Error establishing a database connection. When I try to access /phpma, I get this error instead: phpMyAdmin - Error #1040 - Too many connections. I've looked up how to change my.cnf to increase the number of connections, but I think I've already done this a while back and had no issues since. I'm therefore a little worried that these connections are some kind of vulnerability. I'm running CentOS, but I'm a linux noob. Is there any easy way of checking these connections? Is th (HowTos)

Songlist's picture
Submitted by Songlist on 07/09/2012 – Made popular on 07/09/2012

Stories similar to Error establishing a database connection; how can I determine whether or not these connections are real?

I got a big problem, I guess it's something like a dos attack but I am not sure.

Since this morning, my database is very slow and gives me 7/10 times a too many connections error or tries to login with www-data user (as following up of the too many connections error?).

I tried to locate the issue by mysql command line with 'show fullprocess list' but it gives me just one response back and that '

I'm trying to diagnose an issue at a customer site.

I have a php application that uses memcache and a back-end database

At times we see high "current connections" in memcache and can't determine why.

Why php "misses" from memcache and needs to go to the backend db, does it keep a mem cache connection open until the data is returned?

I am seeing "Too many open connections" in my memcache log.

When I try to access a named instance of Microsoft SQL server 2008 R2 SP2 on the local network, I have no problem. But when access it outside office from the internet, I can not connect to the database server.

It send back the "famous" following error:

A network-related or instance-specific error occured while establishing a connection to SQL Server.

I'm getting ready to start using PGBouncer, but I'm unsure of whether it should be used on my database server or on the app servers. If it's on the app servers, there will necessarily be multiple pools of connections, vs one central pool of connections for the app servers to share, but then the TCP connections have to be recreated for each new query instead of also being pooled, presumably.

For some reason my MySQL can't connect any more. I'm running three WordPress sites and I need to save the tables.

For some reason, my mysql cant connect any more. Im running 3 wordpress websites and I need to save the tables.

I have been obtaining errors like below because I did not specify enough ports for the active FTP connections.

Response: 150 Opening data channel for directory list. Response: 425 Can't open data connection.Error: Failed to retrieve directory listing

Things seem to work nicely with limited ports, but when I perform actions that cause very rapid short-lived connections, something like 20-30% o

I've just built a virtual SQL Server 2 node cluster using VMWare workstation.