Hive MySQL Limits
How can I use Hive in order to apply MySQL limits to the users on my server?
Hive does not include any specific functionality for limiting MySQL. The reason is that MySQL limits are already available and you can easily use the built-in functionality of MySQL for setting account resource limits. Detailed information can be found in the MySQL documentation:
MySQL natively provides the following limits:
- Maximum simultaneous connections per account (MAX_USER_CONNECTIONS)
- Maximum connections per hour with the same account(MAX_CONNECTIONS_PER_HOUR)
- Maximum queries(of any kind) per hour (MAX_QUERIES_PER_HOUR)
- Maximum updates per hour(MAX_UPDATES_PER_HOUR)