MariaDB 10.2+ resource limits per user

wattie

Verified User
Joined
May 31, 2008
Messages
981
Location
Bulgaria
MariaDB 10.2 introduced resource limits per user. They are the following:

  • 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.
 
Top