Details
-
Type:
Task
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
Rather than setting max_connect_errors really high, some users would like to skip host blocking entirely. Can we implement someway to allow unlimited max_connect_errors? If so, how would we implement it?
1.) Set max_connect_errors to 0 for unlimited.
2.) Create a new setting, such as "skip_max_connect_errors".
MySQL has said that they don't want to implement this:
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Their explanation about 0 being a valid choice sounds reasonable given the current definition of the variable, only it's wrong, because as the bug report says, you cannot set max_connect_errors=0.
On the other hand, if the definition is changed slightly, 0 could just as well mean unlimited.
Currently it's
In this case, 0 indeed should be a valid value meaning after the very first connection error the host gets blocked. Only, the value is not allowed.
But if it were
then 1 would mean that after the very first connection error the host gets blocked; and then 0 could mean unlimited.
That said, I don't see much problem with setting a really high value, what's wrong with that? We do it for pretty much all variables, e.g cache sizes, log sizes and what not. And if a user does not like big numbers, they can set it to -1, it will be adjusted.