Documentation Home
MySQL 8.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 294.0Kb
Man Pages (Zip) - 409.0Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

29.12.12.2 ndb_sync_excluded_objects 表

该表提供了关于 NDB 数据库对象无法自动同步到 NDB 集群字典和 MySQL 数据字典之间的信息。

关于 NDB 数据库对象无法与 MySQL 数据字典同步的示例信息:

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
     REASON: Injected failure
*************************** 4. row ***************************
SCHEMA_NAME: test
       NAME: t1
       TYPE: TABLE
     REASON: Injected failure
*************************** 5. row ***************************
SCHEMA_NAME: test
       NAME: t2
       TYPE: TABLE
     REASON: Injected failure
*************************** 6. row ***************************
SCHEMA_NAME: test
       NAME: t3
       TYPE: TABLE
     REASON: Injected failure

ndb_sync_excluded_objects 表具有以下列:

  • SCHEMA_NAME:对象所在的模式(数据库)的名称;对于表空间和日志文件组,该值为 NULL

  • NAME:无法同步的对象的名称;如果对象是模式,该值为 NULL

  • TYPE:无法同步的对象的类型;该值为 LOGFILE GROUPTABLESPACESCHEMATABLE

  • REASON:对象被排除(blocklisting)的原因,即同步失败的原因

    可能的原因包括以下几点:

    • Injected failure

    • Failed to determine if object existed in NDB

    • Failed to determine if object existed in DD

    • Failed to drop object in DD

    • Failed to get undofiles assigned to logfile group

    • Failed to get object id and version

    • Failed to install object in DD

    • Failed to get datafiles assigned to tablespace

    • Failed to create schema

    • Failed to determine if object was a local table

    • Failed to invalidate table references

    • Failed to set database name of NDB object

    • Failed to get extra metadata of table

    • Failed to migrate table with extra metadata version 1

    • Failed to get object from DD

    • Definition of table has changed in NDB Dictionary

    • Failed to setup binlogging for table

    该列表不一定是详尽的,并且可能会在未来 NDB 版本中发生变化。