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 <[EMAIL PROTECTED]> 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
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to