Web lists-archives.com

understanding the binlog




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.lentes@xxxxxxxxxxxxxxxxxxxxx 
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