Re: MySQL Max connections?
On Tue, 7 Dec 2004 14:14:41 -0500
Stephen Gran <sgran@debian.org> wrote:
> This one time, at band camp, Jacob S said:
> > 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.)
>
> IIRC it's 100 by default. With basically no tuning here:
> mysql> show variables like 'max%';
whoops... I guess that should have been obvious from Achim Schmidt's
e-mail. Thanks just the same!
> +-----------------------+------------+
> | Variable_name | Value |
> +-----------------------+------------+
> | max_connections | 100 |
<snip>
Jacob
Reply to: