<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-session-account-connect-attrs-table">
      </a>
      29.12.9.1 The session_account_connect_attrs Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045071848976">
  </a>
  <a class="indexterm" name="idm46045071847472">
  </a>
  <p>
   Application programs can provide key-value connection
          attributes to be passed to the server at connect time. For
          descriptions of common attributes, see
   <a class="xref" href="performance-schema-connection-attribute-tables.html" title="29.12.9 Performance Schema Connection Attribute Tables">
    Section 29.12.9, “Performance Schema Connection Attribute Tables”
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="performance-schema-session-account-connect-attrs-table.html" title="29.12.9.1 The session_account_connect_attrs Table">
    <code class="literal">
     session_account_connect_attrs
    </code>
   </a>
   table contains connection attributes only for the current
          session, and other sessions associated with the session
          account. To see connection attributes for all sessions, use
          the
   <a class="link" href="performance-schema-session-connect-attrs-table.html" title="29.12.9.2 The session_connect_attrs Table">
    <code class="literal">
     session_connect_attrs
    </code>
   </a>
   table.
  </p>
  <p>
   The
   <a class="link" href="performance-schema-session-account-connect-attrs-table.html" title="29.12.9.1 The session_account_connect_attrs Table">
    <code class="literal">
     session_account_connect_attrs
    </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">
       PROCESSLIST_ID
      </code>
     </p>
     <p>
      The connection identifier for the session.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ATTR_NAME
      </code>
     </p>
     <p>
      The attribute name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ATTR_VALUE
      </code>
     </p>
     <p>
      The attribute value.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ORDINAL_POSITION
      </code>
     </p>
     <p>
      The order in which the attribute was added to the set of
              connection attributes.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-session-account-connect-attrs-table.html" title="29.12.9.1 The session_account_connect_attrs Table">
    <code class="literal">
     session_account_connect_attrs
    </code>
   </a>
   table has these indexes:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Primary key on (
      <code class="literal">
       PROCESSLIST_ID
      </code>
      ,
      <code class="literal">
       ATTR_NAME
      </code>
      )
     </p>
    </li>
   </ul>
  </div>
  <p>
   <a class="link" href="truncate-table.html" title="15.1.37 TRUNCATE TABLE Statement">
    <code class="literal">
     TRUNCATE TABLE
    </code>
   </a>
   is not permitted
          for the
   <a class="link" href="performance-schema-session-account-connect-attrs-table.html" title="29.12.9.1 The session_account_connect_attrs Table">
    <code class="literal">
     session_account_connect_attrs
    </code>
   </a>
   table.
  </p>
 </div>
 <br/>
</div>
