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?
> -----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.