reconciled without manual intervention; these objects are blocklisted and not considered again for mismatch detection until this has been done. 

The ndb_sync_pending_objects  and ndb_sync_excluded_objects  tables are present only if MySQL has support enabled for the NDBCLUSTER  storage engine. 

## 27.12.12.1 The ndb_sync_pending_objects Table 

These tables are described in more detail in the following two sections. 

This table provides information about NDB  database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB  dictionary and the MySQL data dictionary. 

Example information about NDB  database objects awaiting synchronization: 

mysql> SELECT * FROM performance_schema.ndb_sync_pending_objects; +-------------+------+----------------+ | SCHEMA_NAME | NAME | TYPE | +-------------+------+----------------+ | NULL | lg1 | LOGFILE GROUP | | NULL | ts1 | TABLESPACE | | db1 | NULL | SCHEMA | | test | t1 | TABLE | | test | t2 | TABLE | | test | t3 | TABLE | +-------------+------+----------------+ 

The ndb_sync_pending_objects  table has these columns: 

• SCHEMA_NAME : The name of the schema (database) in which the object awaiting synchronization resides; this is NULL  for tablespaces and log file groups 

• NAME : The name of the object awaiting synchronization; this is NULL  if the object is a schema 

• TYPE : The type of the object awaiting synchronization; this is one of LOGFILE GROUP , TABLESPACE , SCHEMA , or TABLE 

## 27.12.12.2 The ndb_sync_excluded_objects Table 

The ndb_sync_pending_objects  table was added in NDB 8.0.21. 

This table provides information about NDB  database objects which cannot be automatically synchronized between NDB Cluster’s dictionary and the MySQL data dictionary. 

Example information about NDB  database objects which cannot be synchronized with the MySQL data dictionary: 

mysql> SELECT * FROM performance_schema.ndb_sync_excluded_objects\G *************************** 1. row *************************** SCHEMA_NAME: NULL NAME: lg1 TYPE: LOGFILE GROUP REASON: Injected failure *************************** 2. row *************************** SCHEMA_NAME: NULL NAME: ts1 TYPE: TABLESPACE REASON: Injected failure *************************** 3. row *************************** SCHEMA_NAME: db1 NAME: NULL TYPE: SCHEMA 

