Re: Debian sarge Mysql 4.1 (Too many connections)

[Jean-Paul Blaquiere <jeanpaul@blaquiere.id.au>]

> On Aug 08, Roberto C. Sanchez illuminated :

> Have you considered switching to PostgreSQL?  Seriously, it is more
> robust, more scalable and much more compliant with the SQL language
> specification.
> 
*smack*
and not answer the question he is asking?
sheesh!
I have a small number of mysql databasese (less than twenty) and there's
no way I'd switch them to postgresql without extensive testing, even
though I would really like to do so.

in /etc/mysql/my.cnf, try upping the number of connections.

set-variable=max_connections=500

also, get a hold of the mysql administrator tool (available on the mysql
web site) and use the 'server health' page to watch what's happening on
the box.  It will show the number of users, memory usage, all nifty stuff.


./jp
-- 
Jean-Paul Blaquiere
 jeanpaul@blaquiere.id.au
  http://www.blaquiere.id.au
   http://japester.ucc.asn.au/