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 <[EMA
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 abo
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 th
> 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
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
> >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
for
> >MySQL 4 protocol, such that a connection from localhost can still get
> >through even if there are too many connections.
>
> It is already
On Monday 22 January 2001 11:11, Steven Roussey wrote:
>Hi!
>
>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 for
>MySQL 4 protocol, such that a connection from localhost can still get
>through even
Hi!
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 for
MySQL 4 protocol, such that a connection from localhost can still get
through even if there are too many connections.
Sincerely,
Steven Rouss
