K
K
kkoshakk2016-10-15 23:40:37
MySQL
kkoshakk, 2016-10-15 23:40:37

What is the optimal value for max_connect_errors?

Actually, what value should be set and what threatens too large a value, they write differently everywhere, someone puts 1000, 10000, 1000000, etc.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
VsevolodGavrilenko, 2016-10-16
@kkoshakk

This setting is quite pointless, set a lot and monitor aborted_connects/aborted_clients.
Since the problem with aborted connects usually does not arise out of the blue.
Well, reset once a day via flush hosts, for example.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question