The more complex your privilege setup, the more overhead applies to all SQL statements. 权限设置越复杂,应用于所有SQL语句的开销就越大。Simplifying the privileges established by 通过简化GRANT
statements enables MySQL to reduce permission-checking overhead when clients execute statements. GRANT
语句建立的权限,MySQL可以减少客户端执行语句时的权限检查开销。For example, if you do not grant any table-level or column-level privileges, the server need not ever check the contents of the 例如,如果不授予任何表级或列级权限,则服务器永远不需要检查tables_priv
and columns_priv
tables. tables_priv
表和columns_priv
表的内容。Similarly, if you place no resource limits on any accounts, the server does not have to perform resource counting. 类似地,如果您对任何帐户都没有资源限制,则服务器不必执行资源计数。If you have a very high statement-processing load, consider using a simplified grant structure to reduce permission-checking overhead.如果有非常高的语句处理负载,请考虑使用简化的授权结构来减少权限检查开销。