Tarball with:
* transaction log after the randgen run
* dumpfile to create the initial test bed
* dumpfile from master post-run
* dumpfile from slave post-run (generated / populated from transaction log via transaction_reader)
* output from the randgen - this is the list of queries generated and sent to the server. Each query includes the thread_id in the comments.
This is from a 5 thread, 75 query run. The diff is easier than in many previous runs (only one query appears to differ between master and slave):
--- /tmp//translog_rpl_dump_6637_9306.sql 2010-11-09 12:20:38.670957495 -0500
+++ /tmp//translog_rpl_dump_6637_9307.sql 2010-11-09 12:20:39.171210764 -0500
@@ -1930,6 +1930,22 @@
INSERT INTO `aa` VALUES ('','e','d','',270270464,64290816,9,'EOADF','e','2','KQZTC','VWWRE','d','',990,'my','say','just','7','k','3','','y',5,'5');
INSERT INTO `aa` VALUES ('','z','o','',5,6,NULL,'EPLEV','m','6','f','not','w','',991,'RHVXU','s','I\'m','9','f','-7584061772491915264','','j',1863581696,'9');
INSERT INTO `aa` VALUES ('','o','x','',2,166133760,NULL,'RQWBU','g','3','your','QTFXV','h','',992,'a','hey','going','2','p','5483695496277000192','','e',751239168,'5769111122661605376');
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',993,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',994,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',995,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',996,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',997,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',998,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',999,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1000,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1001,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1002,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1003,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1004,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1005,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1006,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1007,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
+INSERT INTO `aa` VALUES ('','been','e','',3,5,NULL,'a','z',NULL,'OIILA','r','o','',1008,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',9,NULL);
INSERT INTO `aa` VALUES ('','been','e','',8,5,3,'a','z',NULL,'OIILA','r','o','',1021,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',1,NULL);
INSERT INTO `aa` VALUES ('','been','e','',8,5,3,'a','z',NULL,'OIILA','r','o','',1022,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',1,NULL);
INSERT INTO `aa` VALUES ('','been','e','',50,5,3,'a','z',NULL,'OIILA','r','o','',1023,'NILAN','about','CVZCR','5','z','-4307411568603168768','','I',1,NULL);
Tarball with:
* transaction log after the randgen run
* dumpfile to create the initial test bed
* dumpfile from master post-run
* dumpfile from slave post-run (generated / populated from transaction log via transaction_reader)
* output from the randgen - this is the list of queries generated and sent to the server. Each query includes the thread_id in the comments.
This is from a 5 thread, 75 query run. The diff is easier than in many previous runs (only one query appears to differ between master and slave): rpl_dump_ 6637_9306. sql 2010-11-09 12:20:38.670957495 -0500 rpl_dump_ 6637_9307. sql 2010-11-09 12:20:39.171210764 -0500 ,'d','' ,270270464, 64290816, 9,'EOADF' ,'e','2' ,'KQZTC' ,'VWWRE' ,'d','' ,990,'my' ,'say', 'just', '7','k' ,'3','' ,'y',5, '5'); ,'o','' ,5,6,NULL, 'EPLEV' ,'m','6' ,'f','not' ,'w','' ,991,'RHVXU' ,'s','I\ 'm','9' ,'f','- 758406177249191 5264',' ','j',186358169 6,'9'); ,'x','' ,2,166133760, NULL,'RQWBU' ,'g','3' ,'your' ,'QTFXV' ,'h','' ,992,'a' ,'hey', 'going' ,'2','p' ,'5483695496277 000192' ,'','e' ,751239168, '57691111226616 05376') ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',993, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',994, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',995, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',996, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',997, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',998, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',999, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1000, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1001, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1002, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1003, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1004, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1005, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1006, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1007, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,3,5,NULL, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1008, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,9,NULL) ; ,'e','' ,8,5,3, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1021, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,1,NULL) ; ,'e','' ,8,5,3, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1022, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,1,NULL) ; ,'e','' ,50,5,3, 'a','z' ,NULL,' OIILA', 'r','o' ,'',1023, 'NILAN' ,'about' ,'CVZCR' ,'5','z' ,'-430741156860 3168768' ,'','I' ,1,NULL) ;
--- /tmp//translog_
+++ /tmp//translog_
@@ -1930,6 +1930,22 @@
INSERT INTO `aa` VALUES ('','e'
INSERT INTO `aa` VALUES ('','z'
INSERT INTO `aa` VALUES ('','o'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
+INSERT INTO `aa` VALUES ('','been'
INSERT INTO `aa` VALUES ('','been'
INSERT INTO `aa` VALUES ('','been'
INSERT INTO `aa` VALUES ('','been'