<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-innodb-session-temp-tablespaces-table">
      </a>
      28.4.22 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045076564064">
  </a>
  <p>
   The
   <a class="link" href="information-schema-innodb-session-temp-tablespaces-table.html" title="28.4.22 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table">
    <code class="literal">
     INNODB_SESSION_TEMP_TABLESPACES
    </code>
   </a>
   table provides metadata about session temporary tablespaces used
      for internal and user-created temporary tables.
  </p>
  <p>
   The
   <a class="link" href="information-schema-innodb-session-temp-tablespaces-table.html" title="28.4.22 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table">
    <code class="literal">
     INNODB_SESSION_TEMP_TABLESPACES
    </code>
   </a>
   table has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       ID
      </code>
     </p>
     <p>
      The process or session ID.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SPACE
      </code>
     </p>
     <p>
      The tablespace ID. A range of 400 thousand space IDs is
          reserved for session temporary tablespaces. Session temporary
          tablespaces are recreated each time the server is started.
          Space IDs are not persisted when the server is shut down and
          may be reused.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PATH
      </code>
     </p>
     <p>
      The tablespace data file path. A session temporary tablespace
          has an
      <code class="filename">
       ibt
      </code>
      file extension.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SIZE
      </code>
     </p>
     <p>
      The size of the tablespace, in bytes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       STATE
      </code>
     </p>
     <p>
      The state of the tablespace.
      <code class="literal">
       ACTIVE
      </code>
      indicates that the tablespace is currently used by a session.
      <code class="literal">
       INACTIVE
      </code>
      indicates that the tablespace is
          in the pool of available session temporary tablespaces.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PURPOSE
      </code>
     </p>
     <p>
      The purpose of the tablespace.
      <code class="literal">
       INTRINSIC
      </code>
      indicates that the tablespace is used for optimized internal
          temporary tables use by the optimizer.
      <code class="literal">
       SLAVE
      </code>
      indicates that the tablespace is
          allocated for storing user-created temporary tables on a
          replica.
      <code class="literal">
       USER
      </code>
      indicates that the tablespace
          is used for user-created temporary tables.
      <code class="literal">
       NONE
      </code>
      indicates that the tablespace is not
          in use.
     </p>
    </li>
   </ul>
  </div>
  <h4>
   <a name="idm46045076541200">
   </a>
   Example
  </h4>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa58145539"><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-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_SESSION_TEMP_TABLESPACES<span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> ID <span class="token punctuation">|</span> SPACE      <span class="token punctuation">|</span> PATH                       <span class="token punctuation">|</span> SIZE  <span class="token punctuation">|</span> STATE    <span class="token punctuation">|</span> PURPOSE   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span>  8 <span class="token punctuation">|</span> 4294566162 <span class="token punctuation">|</span> ./#innodb_temp/temp_10.ibt <span class="token punctuation">|</span> 81920 <span class="token punctuation">|</span> ACTIVE   <span class="token punctuation">|</span> INTRINSIC <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  8 <span class="token punctuation">|</span> 4294566161 <span class="token punctuation">|</span> ./#innodb_temp/temp_9.ibt  <span class="token punctuation">|</span> 98304 <span class="token punctuation">|</span> ACTIVE   <span class="token punctuation">|</span> USER      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  0 <span class="token punctuation">|</span> 4294566153 <span class="token punctuation">|</span> ./#innodb_temp/temp_1.ibt  <span class="token punctuation">|</span> 81920 <span class="token punctuation">|</span> INACTIVE <span class="token punctuation">|</span> NONE      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  0 <span class="token punctuation">|</span> 4294566154 <span class="token punctuation">|</span> ./#innodb_temp/temp_2.ibt  <span class="token punctuation">|</span> 81920 <span class="token punctuation">|</span> INACTIVE <span class="token punctuation">|</span> NONE      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  0 <span class="token punctuation">|</span> 4294566155 <span class="token punctuation">|</span> ./#innodb_temp/temp_3.ibt  <span class="token punctuation">|</span> 81920 <span class="token punctuation">|</span> INACTIVE <span class="token punctuation">|</span> NONE      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  0 <span class="token punctuation">|</span> 4294566156 <span class="token punctuation">|</span> ./#innodb_temp/temp_4.ibt  <span class="token punctuation">|</span> 81920 <span class="token punctuation">|</span> INACTIVE <span class="token punctuation">|</span> NONE      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  0 <span class="token punctuation">|</span> 4294566157 <span class="token punctuation">|</span> ./#innodb_temp/temp_5.ibt  <span class="token punctuation">|</span> 81920 <span class="token punctuation">|</span> INACTIVE <span class="token punctuation">|</span> NONE      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  0 <span class="token punctuation">|</span> 4294566158 <span class="token punctuation">|</span> ./#innodb_temp/temp_6.ibt  <span class="token punctuation">|</span> 81920 <span class="token punctuation">|</span> INACTIVE <span class="token punctuation">|</span> NONE      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  0 <span class="token punctuation">|</span> 4294566159 <span class="token punctuation">|</span> ./#innodb_temp/temp_7.ibt  <span class="token punctuation">|</span> 81920 <span class="token punctuation">|</span> INACTIVE <span class="token punctuation">|</span> NONE      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  0 <span class="token punctuation">|</span> 4294566160 <span class="token punctuation">|</span> ./#innodb_temp/temp_8.ibt  <span class="token punctuation">|</span> 81920 <span class="token punctuation">|</span> INACTIVE <span class="token punctuation">|</span> NONE      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
  <h4>
   <a name="idm46045076537712">
   </a>
   Notes
  </h4>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      You must have the
      <a class="link" href="privileges-provided.html#priv_process">
       <code class="literal">
        PROCESS
       </code>
      </a>
      privilege to query this table.
     </p>
    </li>
    <li class="listitem">
     <p>
      Use the
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      <a class="link" href="information-schema-columns-table.html" title="28.3.8 The INFORMATION_SCHEMA COLUMNS Table">
       <code class="literal">
        COLUMNS
       </code>
      </a>
      table or the
      <a class="link" href="show-columns.html" title="15.7.7.6 SHOW COLUMNS Statement">
       <code class="literal">
        SHOW COLUMNS
       </code>
      </a>
      statement to view
          additional information about the columns of this table,
          including data types and default values.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
