<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="permission-optimization">
      </a>
      10.2.6 Optimizing Database Privileges
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045227611008">
  </a>
  <a class="indexterm" name="idm46045227609552">
  </a>
  <p>
   The more complex your privilege setup, the more overhead applies
        to all SQL statements. Simplifying the privileges established by
   <a class="link" href="grant.html" title="15.7.1.6 GRANT Statement">
    <code class="literal">
     GRANT
    </code>
   </a>
   statements enables MySQL to
        reduce permission-checking overhead when clients execute
        statements. For example, if you do not grant any table-level or
        column-level privileges, the server need not ever check the
        contents of the
   <code class="literal">
    tables_priv
   </code>
   and
   <code class="literal">
    columns_priv
   </code>
   tables. 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.
  </p>
 </div>
 <br/>
</div>
