该表提供了关于 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 GROUP、TABLESPACE、SCHEMA或TABLE -
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版本中发生变化。 -