List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:January 12 2005 5:47pm
Subject:Re: Error: 1040 too many connections
View as plain text  
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 <xtcsuk@stripped> wrote:
> 
> 
> 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 there anything else we can do to deal with this
> issue?
> 
> regards
> 
> 
> 
>        
>        
>                
> ___________________________________________________________ 
> ALL-NEW Yahoo! Messenger - all new features - even more fun!
> http://uk.messenger.yahoo.com
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
Error: 1040 too many connectionsA Z12 Jan
  • Re: Error: 1040 too many connectionseben12 Jan
  • Re: Error: 1040 too many connectionsGleb Paharenko12 Jan