我有一个 MySQL 集群,我为每个客户构建一个新数据库。这些数据库的规模相对较小,目前我在这个集群上只有 4 个数据库。我刚刚尝试运行我的脚本为另一个客户创建数据库,但收到此错误:
错误 1114 (HY000) 第 180 行:表“TABLE_locations”已满
我已经确认我有足够的索引和数据内存,并增加了MaxNoOfAttributes
以防万一,但问题仍然存在。我已从下面的管理服务器粘贴了我的 config.ini 文件,并只 XX 了目录名称。我不确定此时还能尝试什么来克服这个错误?真诚感谢任何帮助!
[ndbd default]
# Global NDBD Configuration for All Data Nodes
NoOfReplicas=2 # Number of replicas
DataMemory=1024M # Memory Allocation for data storage
IndexMemory=512M # Memory Allocation for index storage
MaxNoOfAttributes=10000 #Maximum number of attributes
[ndb_mgmd]
# HOST003 (Management Node Options)
HostName=10.100.X.X
DataDir=/XXX/MYSQL
NodeId=1
[ndbd]
# HOST004 (Data Node Options)
HostName=10.100.X.X
DataDir=/XXX/MYSQL
NodeId=20
[ndbd]
# HOST005 (Data Node Options)
HostName=10.100.X.X
DataDir=/XXX/MYSQL
管理节点的my.cnf内容:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
InnoDB文件路径:
| innodb_data_file_path | ibdata1:12M:autoextend
数据库大小:
+--------------------+---------------+
| DB Name | DB Size in MB |
+--------------------+---------------+
| CP_4000002 | 19.4 |
| CP_4000003 | 8.9 |
| CP_4000004 | 5.7 |
| CP_4000005 | 2.8 |
| information_schema | 0.0 |
| mysql | 0.8 |
| ndbinfo | 0.0 |
| performance_schema | 0.0 |
+--------------------+---------------+