Hi, i'm currently creating a replication and got in contact with the binlog. I use row-based logging. I read already the doc but i still have some questions. Maybe you can help me.
An excerp from a relay-log: # at 329 #160520 17:00:01 server id 1 end_log_pos 259 Query thread_id=94 exec_time=3 error_code=0 SET TIMESTAMP=1463756401/*!*/; SET @@session.sql_mode=524288/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=33/*!*/; BEGIN /*!*/; # at 405 #160520 17:00:01 server id 1 end_log_pos 410 Query thread_id=94 exec_time=3 error_code=0 use `percona`/*!*/; SET TIMESTAMP=1463756401/*!*/; DELETE FROM `percona`.`checksums` WHERE db = 'mausdb' AND tbl = 'GTAS_line_info' /*!*/; # at 556 #160520 17:00:01 server id 1 end_log_pos 437 Xid = 785606 COMMIT/*!*/; # at 583 #160520 17:00:04 server id 1 end_log_pos 512 Query thread_id=94 exec_time=0 error_code=0 SET TIMESTAMP=1463756404/*!*/; Let's begin with "at 329". Ok, that's the byte offset of the event. Next line: Why is here the end_log_pos 259 before the Byte-Offset one line above ? Same happen later on again. Exec_time is 3. Milliseconds, seconds ... ? SET TIMESTAMP=1463756401/*!*/; How can i interpret "1463756401" ? Is there a way to calculate to get a sensefull timestamp ? Xid = 785606. What is Xid ? An id of the event ? Here an excerp from a binlog: # at 226430 #160520 18:00:19 server id 1 end_log_pos 226505 Query thread_id=96 exec_time=4294967295 error_code=0 SET TIMESTAMP=1463760019/*!*/; BEGIN /*!*/; # at 226505 Why is here exec_time=4294967295 ? What does that mean ? Thanks for any help. Bernd -- Bernd Lentes Systemadministration institute of developmental genetics Gebäude 35.34 - Raum 208 HelmholtzZentrum München bernd.len...@helmholtz-muenchen.de phone: +49 (0)89 3187 1241 fax: +49 (0)89 3187 2294 Projektplanung ist der momentane Stand des Irrtums Helmholtz Zentrum Muenchen Deutsches Forschungszentrum fuer Gesundheit und Umwelt (GmbH) Ingolstaedter Landstr. 1 85764 Neuherberg www.helmholtz-muenchen.de Aufsichtsratsvorsitzende: MinDir'in Baerbel Brumme-Bothe Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Alfons Enhsen, Renate Schlusen (komm.) Registergericht: Amtsgericht Muenchen HRB 6466 USt-IdNr: DE 129521671 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
