- 论坛徽章:
- 0
|
请高手指点
做了mysql集群的备份后,恢复数据时出现ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
数据量在500W,使用的mysqldump备份,source还原的方法
并且恢复时是恢复一部分报一个错,接着又恢复一部分再报一个错,直到结束,数据会丢失一部分,请教高手该怎么解决?!
解释一下啊,我的是两台data节点,256G内存,redhat5.9系统。
还有两台机器每台上都安了一个sql节点和一个管理节点,16G内存,redhat5.7系统
使用rpm包安装的集群,配置文件如下:
config.ini
[ndbd default]
NoOfReplicas=2
DataMemory=193679M
IndexMemory=24210M
MaxNoOfConcurrentOperations=1000000
MaxNoOfConcurrentTransactions=25000
MaxNoOfTables=4096
MaxNoOfOrderedIndexes=2048
MaxNoOfUniqueHashIndexes=512
MaxNoOfAttributes=24576
MaxNoOfTriggers=14336
[tcp default]
portnumber=2202
SendBufferMemory=64M
ReceiveBufferMemory=64M
[ndb_mgmd]
hostname=192.168.10.2
datadir=/var/lib/mysql-cluster
LogDestination=FILE:filename=ndb_1_cluster.log,maxsize=10000000,maxfiles=6
[ndb_mgmd]
hostname=192.168.10.3
datadir=/var/lib/mysql-cluster
LogDestination=FILE:filename=ndb_1_cluster.log,maxsize=10000000,maxfiles=6
[ndbd]
hostname=192.168.10.9
datadir=/var/lib/mysql/data
[ndbd]
hostname=192.168.10.10
datadir=/var/lib/mysql/data
[mysqld]
hostname=192.168.10.2
[mysqld]
hostname=192.168.10.3
[mysqld]
/etc/my.cnf
[mysqld]
ndbcluster
long_query_time=5
log-bin=/var/lib/mysql/binlog/sqld1
log_output=file
general_log=on
slow_query_log=on
general_log_file=/var/lib/mysql/general.log
slow_query_log_file=/var/lib/mysql/slow.log
expire_logs_days=10
max_binlog_size=5M
skip-name-resolve
back_log = 500
key_buffer_size = 4096M
max_allowed_packet = 128M
max-connections=2000
sort_buffer_size = 6M
query_cache_type = 1
query_cache_size = 2048M
tmp_table_size = 2048M
table_open_cache=1024
character-set-server=utf8
init_connect='SET NAMES utf8'
init_connect='set character_set_database=utf8'
default-storage-engine=ndbcluster
ndb-connectstring=192.168.10.2,192.168.10.3
[mysql_cluster]
ndb-connectstring=192.168.10.2,192.168.10.3
QQ截图20130925171455.jpg (26.42 KB, 下载次数: 0)
问题截图
|
|