Hi,

How can i limit connections to my database?

Regards,

Velen

Hi Velen,

you have to put this parameter in the [mysqld] section of .my.cnf file:

max_connections = n # n is the number of connections desired


don't forget to restart mysql!

Aloha!

Claudio Nanni


-----Messaggio originale-----
Da: Velen [mailto:velen@biz-mu.com]
Inviato: domenica 30 marzo 2008 15.59
A: mysql@lists.mysql.com
Oggetto: Connections on Database


Hi,

How can i limit connections to my database?

Regards,

Velen


"Questo messaggio ed ogni suo allegato sono confidenziali e possono essere riservati o, comunque, protetti dall'essere diffusi. Se il ricevente non é il destinatario diretto del presente messaggio, é pregato di contattare l'originario mittente e di cancellare questo messaggio ed ogni suoallegato dal sistema di posta. Se il ricevente non é il destinatario diretto del presente messaggio, sono vietati l'uso, la riproduzione e la stampa di questo messaggio e di ogni suo allegato, nonché la diffusione del loro contenuto a qualsiasi altro soggetto"
*****
"This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, please contact the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not use, copy or print this message or attachment or disclose the contents to any other person."

On Sun, Mar 30, 2008 at 9:59 AM, Velen <velen@biz-mu.com> wrote:
>
> Hi,
>
> How can i limit connections to my database?

RTFM: http://dev.mysql.com/doc/refman/5.0/...resources.html

--
</Daniel P. Brown>
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283

Velen escribió:
> Hi,
>
> How can i limit connections to my database?
>
> Regards,
>
> Velen
>
max_user_connections = 50
max_connections = 50


--
================================================== ==
Ing. Vidal Garza Tirado
Depto. Sistemas
Aduanet S.A. de C.V.
Tel. (867)711-5850 ext. 4346, Fax (867)711-5855.
Ave. César López de Lara No. 3603 Int. B Col Jardín.
Nuevo Laredo, Tamaulipas, México.



--
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.
For all your IT requirements visit: http://www.aduanet.net

You probably only want max_connections and not max_user_connections.
Max_user_connections is the number of times a user can connect per
hour..

-Eric

2008/3/31 Vidal Garza <vgarza@aduanet.net>:
> Velen escribió:
>
>
> > Hi,
> >
> > How can i limit connections to my database?
> >
> > Regards,
> >
> > Velen
> >
> max_user_connections = 50
> max_connections = 50
>
>
> --
> ================================================== ==
> Ing. Vidal Garza Tirado
> Depto. Sistemas
> Aduanet S.A. de C.V.
> Tel. (867)711-5850 ext. 4346, Fax (867)711-5855.
> Ave. César López de Lara No. 3603 Int. B Col Jardín.
> Nuevo Laredo, Tamaulipas, México.
>
>
>
> --
> Este mensaje ha sido analizado por MailScanner
> en busca de virus y otros contenidos peligrosos,
> y se considera que está limpio.
> For all your IT requirements visit: http://www.aduanet.net
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=e...venscaling.com
>
>



--
high performance mysql consulting.
http://provenscaling.com

Oops. I was wrong on that one. max_user_connections is different from
global max_connections and max_connections per user.

2008/3/31 Eric Bergen <eric@provenscaling.com>:
> You probably only want max_connections and not max_user_connections.
> Max_user_connections is the number of times a user can connect per
> hour..
>
> -Eric
>
> 2008/3/31 Vidal Garza <vgarza@aduanet.net>:
>
>
> > Velen escribió:
> >
> >
> > > Hi,
> > >
> > > How can i limit connections to my database?
> > >
> > > Regards,
> > >
> > > Velen
> > >
> > max_user_connections = 50
> > max_connections = 50
> >
> >
> > --
> > ================================================== ==
> > Ing. Vidal Garza Tirado
> > Depto. Sistemas
> > Aduanet S.A. de C.V.
> > Tel. (867)711-5850 ext. 4346, Fax (867)711-5855.
> > Ave. César López de Lara No. 3603 Int. B Col Jardín.
> > Nuevo Laredo, Tamaulipas, México.
> >
> >
> >
> > --
> > Este mensaje ha sido analizado por MailScanner
> > en busca de virus y otros contenidos peligrosos,
> > y se considera que está limpio.
> > For all your IT requirements visit: http://www.aduanet.net
> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=e...venscaling.com
> >
> >
>
>
>
> --
> high performance mysql consulting.
> http://provenscaling.com
>



--
high performance mysql consulting.
http://provenscaling.com