Re: MySQL Max connections?

[Jacob S <stormspotter@6Texans.net>]

On Tue, 07 Dec 2004 19:07:08 +0100
Achim Schmidt <schmidt@waaf.net> wrote:

> Am Dienstag, den 07.12.2004, 11:47 -0600 schrieb Jacob S:
<snip>
> > Can anyone tell me if this is the correct way to increase the max
> > number of connections, or how to do it if it's not? I would try to
> > test it myself, but it is a bit hard to do on a busy server and when
> > I would need a huge number of connections. 
> > 
> 
> There are tow ways to set the limit of maximium connections at one
> time:
> 
> - connect to mysql as root and type:
> mysql> set global max_connections=xxx;
> 
> you can check your vars with:
> mysql> show variables;
> 
> -->> after restart of mysqld the default value is back.
> 
> - edit /etc/my.cnf and add
> 
> max_connections = xxx
> 
> to the "[mysqld]" section
> 
> -->> this would cause mysqld to use this var after next restart

Excellent information. Thanks.

Do you or anybody else know what the default number is for
max_connections? I suppose it could be system load causing my problem,
since top usually shows an average of 4.0 or 5.0 when the problem
occurs. It seems like the whole mysql server or apache would be killed
though if that were the case. (Server is a 2.2Ghz P4 with 512MB of ram.)

Thanks again,
Jacob