MySQL Cluster集群导入数据问题处理

2018年12月13日 761点热度 0人点赞 0条评论

ERROR 1118 (42000) at line 141: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 14000. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

3.7.5 Limits Associated with Database Objects in NDB Cluster
Some database objects such as tables and indexes have different limitations when using the NDBCLUSTER storage engine:
Database and table names. When using the NDB storage engine, the maximum allowed length both for database names and for table names is 63 characters.
Number of database objects. The maximum number of all NDB database objects in a single NDB Cluster—including databases, tables, and indexes—is limited to 20320.
Attributes per table. The maximum number of attributes (that is, columns and indexes) that can belong to a given table is 512.
Attributes per key. The maximum number of attributes per key is 32.
Row size. The maximum permitted size of any one row is 14000 bytes. Each BLOB or TEXT column contributes 256 + 8 = 264 bytes to this total.
BIT column storage per table. The maximum combined width for all BIT columns used in a given NDB table is 4096.
FIXED column storage. NDB Cluster supports a maximum of 16 GB per fragment of data in FIXED columns.

ERROR 1031 (HY000) at line 141: Table storage engine for 'jc_acquisition' doesn't have this option

ERROR 1051 (42S02) at line 559: Unknown table 'jeecmsv93_local.jc_channel'