<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-ndb-sync-excluded-objects-table">
      </a>
      29.12.12.2 The ndb_sync_excluded_objects Table
     </h4>
    </div>
   </div>
  </div>
  <p>
   This table provides information about
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   database objects which cannot
          be automatically synchronized between NDB Cluster's
          dictionary and the MySQL data dictionary.
  </p>
  <p>
   Example information about
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   database objects which cannot be synchronized with the MySQL
          data dictionary:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa30486002"><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> performance_schema<span class="token punctuation">.</span>ndb_sync_excluded_objects\G
<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> 1. row <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>
SCHEMA_NAME<span class="token punctuation">:</span> NULL
       NAME<span class="token punctuation">:</span> lg1
       TYPE<span class="token punctuation">:</span> LOGFILE GROUP
     REASON<span class="token punctuation">:</span> Injected failure
<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> 2. row <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>
SCHEMA_NAME<span class="token punctuation">:</span> NULL
       NAME<span class="token punctuation">:</span> ts1
       TYPE<span class="token punctuation">:</span> TABLESPACE
     REASON<span class="token punctuation">:</span> Injected failure
<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> 3. row <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>
SCHEMA_NAME<span class="token punctuation">:</span> db1
       NAME<span class="token punctuation">:</span> NULL
       TYPE<span class="token punctuation">:</span> SCHEMA
     REASON<span class="token punctuation">:</span> Injected failure
<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> 4. row <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>
SCHEMA_NAME<span class="token punctuation">:</span> test
       NAME<span class="token punctuation">:</span> t1
       TYPE<span class="token punctuation">:</span> TABLE
     REASON<span class="token punctuation">:</span> Injected failure
<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> 5. row <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>
SCHEMA_NAME<span class="token punctuation">:</span> test
       NAME<span class="token punctuation">:</span> t2
       TYPE<span class="token punctuation">:</span> TABLE
     REASON<span class="token punctuation">:</span> Injected failure
<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> 6. row <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>
SCHEMA_NAME<span class="token punctuation">:</span> test
       NAME<span class="token punctuation">:</span> t3
       TYPE<span class="token punctuation">:</span> TABLE
     REASON<span class="token punctuation">:</span> Injected failure</span></code></pre>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-ndb-sync-excluded-objects-table.html" title="29.12.12.2 The ndb_sync_excluded_objects Table">
    <code class="literal">
     ndb_sync_excluded_objects
    </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">
       SCHEMA_NAME
      </code>
      : The name of the schema
              (database) in which the object which has failed to
              synchronize resides; this is
      <code class="literal">
       NULL
      </code>
      for
              tablespaces and log file groups
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       NAME
      </code>
      : The name of the object which has
              failed to synchronize; this is
      <code class="literal">
       NULL
      </code>
      if
              the object is a schema
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TYPE
      </code>
      : The type of the object has failed
              to synchronize; this is one of
      <code class="literal">
       LOGFILE
              GROUP
      </code>
      ,
      <code class="literal">
       TABLESPACE
      </code>
      ,
      <code class="literal">
       SCHEMA
      </code>
      , or
      <code class="literal">
       TABLE
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       REASON
      </code>
      : The reason for exclusion
              (blocklisting) of the object; that is, the reason for the
              failure to synchronize this object
     </p>
     <p>
      Possible reasons include the following:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <code class="literal">
          Injected failure
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to determine if object existed in
                  NDB
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to determine if object existed in
                  DD
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to drop object in DD
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to get undofiles assigned to logfile
                  group
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to get object id and version
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to install object in DD
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to get datafiles assigned to
                  tablespace
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to create schema
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to determine if object was a local
                  table
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to invalidate table
                  references
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to set database name of NDB
                  object
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to get extra metadata of
                  table
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to migrate table with extra metadata
                  version 1
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to get object from DD
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Definition of table has changed in NDB
                  Dictionary
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Failed to setup binlogging for
                  table
         </code>
        </p>
       </li>
      </ul>
     </div>
     <p>
      This list is not necessarily exhaustive, and is subject to
              change in future
      <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
       <code class="literal">
        NDB
       </code>
      </a>
      releases.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
