MariaDB 10.2 introduced resource limits per user. They are the following:
I think that wil be a good addition to DirectAdmin if you add easy configuration for them.
- MAX_QUERIES_PER_HOUR Number of statements that the account can issue per hour (including updates)
- MAX_UPDATES_PER_HOUR Number of updates (not queries) that the account can issue per hour
- MAX_CONNECTIONS_PER_HOUR Number of connections that the account can start per hour
- MAX_USER_CONNECTIONS Number of simultaneous connections that can be accepted from the same account; if it is 0, max_connections will be used instead; if max_connections is 0, there is no limit for this account's simultaneous connections.
- MAX_STATEMENT_TIME Timeout, in seconds, for statements executed by the user. See also Aborting Statements that Exceed a Certain Time to Execute.
I think that wil be a good addition to DirectAdmin if you add easy configuration for them.