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=C3=A4ude 35.34 - Raum 208
HelmholtzZentrum M=C3=BCnchen
bernd.lentes@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