> > >>> 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. _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
