I don't want to have this limit on ip but on ip+database, how can I change this?
at the point at which connections are blocked the database the remote host wants to use is not even known yet, so this blocking mechanism can't take it into account.
afaik you have a connection requist with user/pass/db. So maybe it could be a good option to delay tcp blocking till after you get more info? I donk't think there is much overhead created using these variables that are being send. You don't query the backend looking up users in tables. I think this could be nice feature for design.
The related setting is max_connect_errors, but as far as I can tell it defaults to 100 for all MariaDB releases, and for MySQL, too, at least back to MySQL 5.7
https://mariadb.com/kb/en/server-system-variables/#max_connect_errors
https://dev.mysql.com/doc/refman/5.7/en/server-system- variables.html#sysvar_max_connect_errors
That's why I was asking for specific version information on a previous reply ...
I don't think it is that relevant currently. It takes me a bit of time to gather this. I can remember noticing starting to have these incidents after an upgrade.
PS: your quoting style is confusing, the ">" indentation marker is supposed to mark quoted text, one ">" per level of quoting, not your actual reply.
:) My reply is being quoted? I sort of thought this was a clear way of responding. I am usually annoyed by people not responding clearly, so I definitely want to prevent doing the same.