From: Tauren Mills
Date: March 16 1999 10:17am
Subject: RE: Limiting number of connections to database for a user
List-Archive: http://lists.mysql.com/mysql/312
Message-Id: <045101be6f96$346ba540$1ad7a2d1@yowza.easystreet.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I would certainly be interested in this.  Alternatively, is there a way to
get some sort of status report that shows the maximum simultaneous
connections that a user had at any given time.  I'm envisioning something
that keeps a counter of the maximum used until a command is sent to reset
the counters.  I suppose just adding a limit would be easier.  Would it be
best to store the connection limit allowed for each user in the User table?

Tauren

> -----Original Message-----
> From: Michael Widenius [mailto:monty@stripped]
> Sent: Monday, March 15, 1999 4:53 PM
> To: Tauren Mills
> Cc: mysql@stripped
> Subject: Limiting number of connections to database for a user
>
>
> >>>>> "Tauren" == Tauren Mills <tauren@stripped> writes:
>
> Tauren> Is it possible to set a limit on the number of
> simultaneous database
> Tauren> connections that can be in use for a certain user?
>
> Not for the moment;  (This shouldn't be that hard to fix if anyone is
> interested in this...)
>
> Tauren> How do ISPs that offer MySQL take care of sharing these
> resources between
> Tauren> all their users?
>
> One way is to have a separate MySQL daemon for each user.
>
> Regards,
> Monty
>