该表提供了关于 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
版本中发生变化。 -