<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="innodb-disabling-tablespace-path-validation">
      </a>
      17.6.3.7 Disabling Tablespace Path Validation
     </h4>
    </div>
   </div>
  </div>
  <p>
   At startup,
   <code class="literal">
    InnoDB
   </code>
   scans directories defined by
      the
   <a class="link" href="innodb-parameters.html#sysvar_innodb_directories">
    <code class="literal">
     innodb_directories
    </code>
   </a>
   variable
      for tablespace files. The paths of discovered tablespace files are
      validated against the paths recorded in the data dictionary. If
      the paths do not match, the paths in the data dictionary are
      updated.
  </p>
  <p>
   The
   <a class="link" href="innodb-parameters.html#sysvar_innodb_validate_tablespace_paths">
    <code class="literal">
     innodb_validate_tablespace_paths
    </code>
   </a>
   variable permits disabling tablespace path validation. This
      feature is intended for environments where tablespaces files are
      not moved. Disabling path validation improves startup time on
      systems with a large number of tablespace files. If
   <a class="link" href="server-system-variables.html#sysvar_log_error_verbosity">
    <code class="literal">
     log_error_verbosity
    </code>
   </a>
   is set to 3,
      the following message is printed at startup when tablespace path
      validation is disabled:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa95487896"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token punctuation">[</span>InnoDB<span class="token punctuation">]</span> Skipping InnoDB tablespace path validation<span class="token punctuation">.</span> 
Manually moved tablespace files will not be detected!</code></pre>
  </div>
  <div class="warning" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Warning
   </div>
   <p>
    Starting the server with tablespace path validation disabled
        after moving tablespace files can lead to undefined behavior.
   </p>
  </div>
 </div>
 <br/>
</div>
