MySQL8.0 中文参考手册

27.12.12.2 ndb_sync_excluded_objects 表

此表提供有关 NDB无法在 NDB Cluster 字典和 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 GROUP, TABLESPACE, SCHEMA, 或TABLE

  • REASON：对象排除（黑名单）的原因；也就是同步这个对象失败的原因

    可能的原因包括：

    • 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 版本中可能会发生变化。

该ndb_sync_excluded_objects 表是在 NDB 8.0.21 中添加的。