mysqlcluster 创建表出现错误 708

Question

当我在 mysqlcluster 7.5.17 中创建表时，收到如下错误消息

Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDBCLUSTER

所以我使用ndb_config -q MaxNoOfAttributes得到MaxNoOfAttributes的数字是40960，

我从 information_schema 中选择列，获取编号为 28777

select count(*) from information_schema.COLUMNS 
where TABLE_SCHEMA not in ('mysql','information_schema','ndbinfo','performance_schema','sys');
+----------+
| count(*) |
+----------+
|    28777 |
+----------+

我想知道 MaxNoOfAttributes 参数的限制在哪里？

Answer 1

您可以通过此page查看更多信息。我将引用您案例的相关段落:

The default value is 1000, with the minimum possible value being 32. The maximum is 4294967039. Each attribute consumes around 200 bytes of storage per node due to the fact that all metadata is fully replicated on the servers.

需要小心，当使用该表中3倍的属性进行ALTER TABLE时，此参数会产生影响。

During the execution of ALTER TABLE on a Cluster table, 3 times the number of attributes as in the original table are used.

因此有必要评估您的表并找到最大属性数，将其乘以 6 作为此参数的值。