首页 新闻 会员 周边 捐助

mysql集群恢复备份文件(,data)出现数据内存溢出。

0
悬赏园豆:80 [待解决问题]

Processing data in table: operating_db/def/account(65) fragment 0
_____________________________________________________
Processing data in table: operating_db/def/account(65) fragment 2
_____________________________________________________
Processing data in table: sys/def/SYSTAB_0(2) fragment 0
_____________________________________________________
Processing data in table: sys/def/SYSTAB_0(2) fragment 2
_____________________________________________________
Processing data in table: operating_db/def/worldservernotice(98) fragment 0
_____________________________________________________
Processing data in table: operating_db/def/worldservernotice(98) fragment 2
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_sample(5) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_sample(5) fragment 2
_____________________________________________________
Processing data in table: operating_db/def/worldserveronlinecount(107) fragment
0
Permanent: 827: Out of memory in Ndb Kernel, table data (increase DataMemory)
Restore: Failed to restore data due to a unrecoverable error. Exiting...

NDBT_ProgramExit: 1 - Failed

 

每次都是恢复到worldserveronlinecount这个表的时候就报错了。

--------------------------------------------------------------------------

这是我的配置文件(config.ini)

===========================================

[tcp default]
#在向操作系统发出调用请求之前,TCP传输器采用缓冲来保存所有的消息。当该缓冲达到64KB时,将发送其内容,执行完一组消息循环后,也将发送这些内容。发送缓冲的默认值是256KB。
SendBufferMemory=16M

[ndbd default]
# Options affecting ndbd processes on all data nodes:
# Number of replicas
NoOfReplicas=2
DataDir=c:/mysqlcluster/datanode/mysql/bin/cluster-data
# Directory for each data node's data files
# Memory allocated to data storage
#DataMemory=2G
# Memory allocated to index storage
#IndexMemory=300M
# For DataMemory and IndexMemory, we have used the
# default values.
TotalSendBufferMemory=256M
BackupMaxWriteSize=1M
BackupDataBufferSize=16M
BackupLogBufferSize=4M
BackupMemory=20M
BackupReportFrequency=10
MemReportFrequency=30
LogLevelStartup=15
LogLevelShutdown=15
LogLevelCheckpoint=8
LogLevelNodeRestart=15
DataMemory=10000M
IndexMemory=4000M
MaxNoOfTables=4096
MaxNoOfTriggers=3500
StringMemory=25
DiskPageBufferMemory=1024M
SharedGlobalMemory=1000M
LongMessageBuffer=32M
MaxNoOfConcurrentTransactions=16384
BatchSizePerLocalScan=512
FragmentLogFileSize=64M
NoOfFragmentLogFiles=300
RedoBuffer=32M
MaxNoOfExecutionThreads=4
StopOnError=false
LockPagesInMainMemory=1
TimeBetweenEpochsTimeout=32000
TimeBetweenWatchdogCheckInitial=60000
TransactionInactiveTimeout=60000
HeartbeatIntervalDbDb=15000
HeartbeatIntervalDbApi=15000
max_allowed_packet=64M

[ndb_mgmd]
# Management process options:
NodeId=49
# Hostname or IP address of management node ????
HostName=192.168.0.117
# Directory for management node log files
DataDir=C:/mysql/bin/cluster-logs
Portnumber=1186

[ndbd]
NodeId=1
HostName=192.168.0.117

[ndbd]
NodeId=2
HostName=192.168.0.36

[mysqld]
NodeId=53
HostName=192.168.0.117

[mysqld]
NodeId=54
HostName=192.168.0.36

[mysqld]

[mysqld]

[API]

[API]

 

shenz_free的主页 shenz_free | 初学一级 | 园豆:4
提问于:2017-02-14 11:25
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册