insert into user (`USER`,`AGE`,`ADDRESS`,`MAIL`,`ENDTIME`)
values ('aaa',20,'aaa','aaa@aaa.com','2011-02-15 11:35:36'),
('aaa',20,'aaa','aaa@aaa.com','2011-02-15 11:35:36'),('aaa',20,'aaa','aaa@aaa.com','2011-02-15 11:35:36'),('aaa',20,'aaa','aaa@aaa.com','2011-02-15 11:35:36').....
这样类型的插入语句 后面的values值大约有500条,主数据库执行几小时后,从库肯定会报主键错误。后来换成了
insert into user (`USER`,`AGE`,`ADDRESS`,`MAIL`,`ENDTIME`) values ('aaa',20,'aaa','aaa@aaa.com','2011-02-15 11:35:36');
insert into user (`USER`,`AGE`,`ADDRESS`,`MAIL`,`ENDTIME`) values ('aaa',20,'aaa','aaa@aaa.com','2011-02-15 11:35:36');
............
同样执行500条,主从同步就没问题,但效率太低了。。 |