Error: 1040 too many connections

2005-01-12 Thread A Z
Hi, MySQL 4.0.14 This may have been queried a lot here. We get this error and after re-starting the server (MySQL) it seems to go away for a while. As per instructions we have changed the max connection in the My.ini to 500 (max_connections=500). MySQLAdmin displays connections = 120. Is

Re: Error: 1040 too many connections

2005-01-12 Thread eben
I had the same error for quite some time, the issue seemed to be server resources not being able to kill off connections quickly enough. We had a lot of traffic and some pretty slow queries. Optimizing the queries bought us some time, but ultimately we had to upgrade hardware. This bought us

Re: Error: 1040 too many connections

2005-01-12 Thread Gleb Paharenko
Hello. There reason can be in big queries wich consume the resources (temp space for example). Turn on log_slow_queries to find the guilty queries. See: http://dev.mysql.com/doc/mysql/en/Slow_query_log.html You have old enough version of MySQL. Use the latest release. A Z

Re: ERROR 1040: Too many connections

2001-01-23 Thread Filippo Carletti
Filippo There must be a problem, then. Filippo It happens to me, often, that I cannot obtain a proc or ext with mysqladmin Filippo as root. Filippo All accesses are through an unpriv username, I have max_connections=1000 and Filippo a Filippo ps ax | grep mysqld | wc -l gives me a value

Re: ERROR 1040: Too many connections

2001-01-22 Thread Michael Widenius
Hi! "Filippo" == Filippo Carletti [EMAIL PROTECTED] writes: Sometimes something bad happens in a server and it is hard to figure out what is going on because we can not get in. I'd like to suggest a change Filippo for MySQL 4 protocol, such that a connection from localhost can still get