Limit connections from same host
How can I limit the connections from the same host in mysql. -- - Scott HanedaTel: 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]
Re: Limit connections from same host
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. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Limit connections from same host
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 HanedaTel: 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]
Re: Limit connections from same host
At 20:32 -0800 2/28/04, Scott Haneda wrote: 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 :-( Um, those are connections to your Web server, not the MySQL server. Connections made by the Web server to your MySQL server are always going to appear to be from the same host. If you want to throttle client connections, you'll need to clearly identify which clients you mean, and what program they are clients *of*. I guess I can limit from same host in apache and do the same, thanks. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]