Cache Hosts - Which are tempting max_connect_errors?
Hi, Is there a way in 4.X or 5.0 to tell which hosts are running up the counter towards max_connect_errors? We'd like to be able to monitor this and act accordingly? I've seen that they suggest to set it to 9 in 13.5.5.2 FLUSH Syntax to avoid it. I'm just wondering why they didn't say to just use --skip-cache-host . Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
max_connect_errors
Hello, Does MySQL store a current error count (for each host?) internally that I can enquire on? I did not find this information in the MySQL manual. If the current error count is available, so that I can monitor it for specific hosts and issue a alert when it crosses a threshold. Please help! Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Re: How can I disable 'max_connect_errors'?
Daevid Vincent wrote: Is there a way to disable this 'max_connect_errors' thing? http://www.mysql.com/doc/en/Blocked_host.html Tried max_connect_errors=0 but then it shows up as max_connect_errors=1 What is the 'max' that this value can be in case? We have it set to 10,000 now, but that only buys us time. When is this counter reset? on FLUSH HOSTS Is it ongoing until a FLUSH HOSTS? yes Is it until mysql is restarted? it does also reset on restart To disable for practical purposes, set it to 2^32-1 = 4294967295. On top, once a day run FLUSH HOSTS At the same time try to figure out why you are getting so many of them. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How can I disable 'max_connect_errors'?
Is there a way to disable this 'max_connect_errors' thing? http://www.mysql.com/doc/en/Blocked_host.html Tried max_connect_errors=0 but then it shows up as max_connect_errors=1 What is the 'max' that this value can be in case? We have it set to 10,000 now, but that only buys us time. When is this counter reset? Is it ongoing until a FLUSH HOSTS? Is it until mysql is restarted? Is it something else? Daevid Vincent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: max_connect_errors wait_timeout problem?
On Wed, 2002-07-31 at 19:09, Troy Hakala wrote: I decreased wait_timeout (from 28,800 to 300) to kill off sleeping threads. This morning, the server stopped accepting connections and gave me this error: ERROR 1129: Host 'hostname' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' flush-hosts worked and I increased the max_connect_errors from 10 to 1000 to kind of prevent this in the future. But what causes this error? If you read the comments on http://www.mysql.com/doc/B/l/Blocked_host.html it seems that decreasing wait_timeout does cause this. Is there a bug in mysql where it thinks that killing off sleeping threads is really a connect error? I'm using 3.23.45, btw. I'm not shure, but i think it is not a bug. I think a connection is only successfull when it is closed by the same entity who opened it. If it was mysql closing the connection, then it should increment its counter of connection_errors. It tells that someone opened a connection and did not close it. It's only an opinion. -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
max_connect_errors wait_timeout problem?
I decreased wait_timeout (from 28,800 to 300) to kill off sleeping threads. This morning, the server stopped accepting connections and gave me this error: ERROR 1129: Host 'hostname' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' flush-hosts worked and I increased the max_connect_errors from 10 to 1000 to kind of prevent this in the future. But what causes this error? If you read the comments on http://www.mysql.com/doc/B/l/Blocked_host.html it seems that decreasing wait_timeout does cause this. Is there a bug in mysql where it thinks that killing off sleeping threads is really a connect error? I'm using 3.23.45, btw. Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
max_connect_errors security behind a firewall
What is the security concerns about incresing the number of max_connect_errors? And if I am behind a firewall and the server is only accessed by only one machine, in the case it=B4s accessed only by the webserver. I have to admit that I dont understand the purpose of a too low default number for max_connect_errors. Locking the server after only 10 connections seens to be paranoidy precaution. Pedro Furlanetto database,sql,query,table - bypassing the filter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What does the max_connect_errors do ?
What does the max_connect_errors do ? Is it : if I have that many connect errors, MySQL will stop ? [database] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php