Have Geek Brain

MySQL resource limits

When I set resource limits for a specific user / database / host, does it propagate after an hour? will it delay requests or prevent you from requesting some kind of error or something?

+1


a source to share


1 answer


http://dev.mysql.com/doc/refman/5.0/en/user-resources.html says:



As the server starts up, it counts the number of times each account uses resources. If an account reaches its connection limit in the last hour, further connections for the account are rejected until that hour ends. Likewise, if an account reaches its limit on the number of requests or updates, further requests or updates are denied until the hour is reached. In all such cases, an appropriate error message is issued.
+1


a source






More articles:


All Articles