MySQL Cluster导入数据表时报错:Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDBCLUSTER
2023-09-14 08:57:27 时间
准备把以前的非集群版MySQL数据导入到MySQL Cluster中,出现
'No more attribute metadata records (increase MaxNoOfAttributes)' from NDBCLUSTER
的错误,如下图所示:(注:数据表引擎已改为 ENGINE=ndbcluster)
【解决方案】
修改 MGM节点配置,把 [ndbd]中的 “MaxNoOfAttributes=1000”改成 “MaxNoOfAttributes=5000000”:
vim /usr/local/mysql/etc/config.ini
#部分资料参考如下:
[ndbd default]
NoOfReplicas = 2
DataMemory = 80M
IndexMemory = 18M
datadir = /usr/local/mysql/data
MaxNoOfTables = 1024
MaxNoOfAttributes = 5000000
MaxNoOfOrderedIndexes = 10000
#修改了配置文件后,需要添加--initial参数重新读取才行
/usr/local/mysql/bin/ndb_mgmd -f /usr/local/mysql/etc/config.ini --initial
#查看变量修改是否生效
[root@localhost bin]# /usr/local/mysql/bin/ndb_config -q MaxNoOfAttributes 5000000 5000000
注:如果加了 --initial 参数,还是没生效的话,那就先 kill掉ndb_mgm,再重新 --initial 启动 ndb_mgmd 吧!
【参数说明】 MaxNoOfAttributes 表示 MySQL Cluster集群中,所有数据表的字段总数能达到的上限!
参考:
相关文章
- Navicat Premium连接MySQL 1251错误和Mysql初始化root密码和允许远程访问
- 【MySQL】一次修改mysql 默认路径的经历
- Linux - mysql 异常: ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
- linux - mysql - 卸载:RPM包安装方式的MySQL卸载
- MySQL配置文件mysql.ini参数详解、MySQL性能优化
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- mysql性能分析工具
- mysql 字符串截取
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- PHP连接MySQL数据库的三种方式(mysql、mysqli、pdo)
- MySQL保留字不能作为字段名使用_Table字段不能设为关键字range,range在mysql中是分区,是mysql的关键字
- 【收藏】windows下 Mysql 错误 Can‘t open and lock privilege tables: Table ‘mysql.user‘ doesn‘t exist
- Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/mysql.pid).
- error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
- mysql常用基础操作语法(二)~~对表的增删改操作【命令行模式】
- 详解MySQL information_schema数据库常用的表信息以及各表对应的字段信息;以及如何登录mysql和创建视图
- ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 5
- MYSQL导入数据报错|MYSQL导入超大文件报错|MYSQL导入大数据库报错:2006 - MySQL server has gone away
- csv批量导入mysql命令
- MySQL Study之--Mysql无法启动“mysql.host”
- Prometheus MySQL_exporter
- Linux MySQl 5.7.17 MySQL ERROR 1366(HY000):Incorrect string value 解决方法
- Mysql报错:Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- MySQL远程连接报错2003-cant connection to mysql server on ‘IP’(10061 unknown error)
- Redis_14_三种方式实现分布式锁(MySQL、Zookeeper、Redis)