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]
