on 02/28/2004 07:08 PM, Paul DuBois at [EMAIL PROTECTED] wrote: > At 17:22 -0800 2/28/04, Scott Haneda wrote: >> How can I limit the connections from the same host in mysql. > > You can put a limit on the number of connections per hour from a given > account (WITH MAX_CONNECTIONS_PER_HOUR), but not from a given host.
Any hacks to make this happen? In OS X with safari, if someone holds command-R on the keybaord and points it to any site that is talking to mysql, you are going to fill up all your connections in a few seconds. The best I can tell, Safari sends about 100 page requests per 2 seconds. Pretty bad :-( I guess I can limit from same host in apache and do the same, thanks. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
