/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #141120 12:35:01 server id 11 end_log_pos 248 Start: binlog v 4, server v 10.0.14-MariaDB-wsrep-log created 141120 12:35:01 BINLOG ' BINLOG DATA '/*!*/; # at 248 #141120 12:35:01 server id 11 end_log_pos 319 Gtid list [0-13-46550002, # 0-12-46550005, # 0-11-46550008] # at 319 #141120 12:35:01 server id 11 end_log_pos 358 Binlog checkpoint mysql-bin.000474 # at 358 #691231 18:00:00 server id 11 end_log_pos 397 Binlog checkpoint mysql-bin.000475 # at 2556 #141120 12:35:02 server id 13 end_log_pos 2594 GTID 0-13-46550013 /*!100001 SET @@session.gtid_seq_no=46550013*//*!*/; BEGIN /*!*/; # at 2594 # at 2764 # at 2836 #141120 12:35:02 server id 13 end_log_pos 2764 Annotate_rows: #Q> DELETE FROM `access_logs`.`requests` WHERE (((`id` >= '58180499'))) AND (((`id` <= '58183496'))) AND (time < current_date - interval 2 week) LIMIT 1000 #141120 12:35:02 server id 13 end_log_pos 2836 Table_map: `db`.`recent_activity` mapped to number 58771 #141120 12:35:02 server id 13 end_log_pos 2896 Write_rows: table id 58771 flags: STMT_END_F BINLOG ' BINLOG DATA '/*!*/; ### INSERT INTO `db`.`recent_activity` ### SET ### @1=26567961 /* INT meta=0 nullable=0 is_null=0 */ ### @2=199 /* INT meta=0 nullable=0 is_null=0 */ ### @3=1416508502 /* TIMESTAMP meta=0 nullable=0 is_null=0 */ ### @4=63751 /* INT meta=0 nullable=0 is_null=0 */ ### @5='contacts' /* VARSTRING(300) meta=300 nullable=0 is_null=0 */ ### @6=14611641 /* INT meta=0 nullable=0 is_null=0 */ # at 2896 #141120 12:35:02 server id 13 end_log_pos 2923 Xid = 334158519 COMMIT/*!*/; # at 20082 #141120 12:35:02 server id 13 end_log_pos 20120 GTID 0-13-46550041 /*!100001 SET @@session.server_id=13*//*!*/; /*!100001 SET @@session.gtid_seq_no=46550041*//*!*/; BEGIN /*!*/; # at 20120 # at 20370 # at 20442 #141120 12:35:02 server id 13 end_log_pos 20370 Annotate_rows: #Q> INSERT INTO SystemEvents (Message, Facility,FromHost, Priority, DeviceReportedTime, ReceivedAt, InfoUnitID, SysLogTag, processid) VALUES (' A70EB1440B30: removed', '2', 'web1', '6', '20141120052106', NOW(), '1', 'postfix', '46575') #141120 12:35:02 server id 13 end_log_pos 20442 Table_map: `db`.`recent_activity` mapped to number 58771 #141120 12:35:02 server id 13 end_log_pos 20502 Write_rows: table id 58771 flags: STMT_END_F BINLOG ' BINLOG DATA '/*!*/; ### INSERT INTO `db`.`recent_activity` ### SET ### @1=26567967 /* INT meta=0 nullable=0 is_null=0 */ ### @2=146 /* INT meta=0 nullable=0 is_null=0 */ ### @3=1416508502 /* TIMESTAMP meta=0 nullable=0 is_null=0 */ ### @4=111321 /* INT meta=0 nullable=0 is_null=0 */ ### @5='contacts' /* VARSTRING(300) meta=300 nullable=0 is_null=0 */ ### @6=14276685 /* INT meta=0 nullable=0 is_null=0 */ # at 20502 #141120 12:35:02 server id 13 end_log_pos 20529 Xid = 334158547 COMMIT/*!*/; # at 25233 #141120 12:35:03 server id 12 end_log_pos 25271 GTID 0-12-46550050 /*!100001 SET @@session.gtid_seq_no=46550050*//*!*/; BEGIN /*!*/; # at 25271 # at 25441 # at 25515 #141120 12:35:03 server id 12 end_log_pos 25441 Annotate_rows: #Q> DELETE FROM `access_logs`.`requests` WHERE (((`id` >= '58236782'))) AND (((`id` <= '58239779'))) AND (time < current_date - interval 2 week) LIMIT 1000 #141120 12:35:03 server id 12 end_log_pos 25515 Table_map: `db`.`contacts_notes` mapped to number 57413 #141120 12:35:03 server id 12 end_log_pos 25739 Write_rows: table id 57413 flags: STMT_END_F BINLOG ' BINLOG DATA '/*!*/; ### INSERT INTO `db`.`contacts_notes` ### SET ### @1=11125877 /* INT meta=0 nullable=0 is_null=0 */ ### @2=168 /* INT meta=0 nullable=0 is_null=0 */ ### @3=1416508503 /* TIMESTAMP meta=0 nullable=0 is_null=0 */ ### @4=0 /* INT meta=0 nullable=0 is_null=0 */ ### @5=0 /* INT meta=0 nullable=0 is_null=0 */ ### @6=14657077 /* INT meta=0 nullable=0 is_null=0 */ ### @7='NOTE TEXT' /* BLOB/TEXT meta=2 nullable=0 is_null=0 */ ### @8=1 /* INT meta=0 nullable=0 is_null=0 */ ### @9=0 /* TINYINT meta=0 nullable=0 is_null=0 */ # at 25739 #141120 12:35:03 server id 12 end_log_pos 25766 Xid = 334158556 COMMIT/*!*/; # at 61683 #141120 12:35:04 server id 11 end_log_pos 61721 GTID 0-11-46550088 /*!100001 SET @@session.server_id=11*//*!*/; /*!100001 SET @@session.gtid_seq_no=46550088*//*!*/; BEGIN /*!*/; # at 61721 # at 61865 # at 61937 #141120 12:35:04 server id 11 end_log_pos 61865 Annotate_rows: #Q> INSERT INTO recent_activity (acctID, stamp, user_id, tblname, record_id) VALUES (@acctID,NOW(),@userID,'contacts','15019497') #141120 12:35:04 server id 11 end_log_pos 61937 Table_map: `db`.`recent_activity` mapped to number 58771 #141120 12:35:04 server id 11 end_log_pos 61997 Write_rows: table id 58771 flags: STMT_END_F BINLOG ' BINLOG DATA '/*!*/; ### INSERT INTO `db`.`recent_activity` ### SET ### @1=26567971 /* INT meta=0 nullable=0 is_null=0 */ ### @2=199 /* INT meta=0 nullable=0 is_null=0 */ ### @3=1416508504 /* TIMESTAMP meta=0 nullable=0 is_null=0 */ ### @4=53983 /* INT meta=0 nullable=0 is_null=0 */ ### @5='contacts' /* VARSTRING(300) meta=300 nullable=0 is_null=0 */ ### @6=15019497 /* INT meta=0 nullable=0 is_null=0 */ # at 61997 #141120 12:35:04 server id 11 end_log_pos 62024 Xid = 334158594 COMMIT/*!*/;