Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

29.12.12.1 The ndb_sync_pending_objects Table

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

Example information aboutNDB 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         |+-------------+------+----------------+

Thendb_sync_pending_objects table has these columns:

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

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

  • TYPE: The type of the object awaiting synchronization; this is one ofLOGFILE GROUP,TABLESPACE,SCHEMA, orTABLE

Thendb_sync_pending_objects table was added in NDB 8.0.21.