MySQL 资源限制

Question

每当我为特定用户/数据库/主机设置资源限制时，它会在整个小时内传播吗？它会延迟查询还是不允许您查询会抛出某种错误或其他什么？

Answer 1

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

As the server runs, it counts the number of times each account uses resources. If an account reaches its limit on number of connections within the last hour, further connections for the account are rejected until that hour is up. Similarly, if the account reaches its limit on the number of queries or updates, further queries or updates are rejected until the hour is up. In all such cases, an appropriate error message is issued.