How MySQL binlog data is viewed

Binlog Introduction

1. Binlog, the binary log, which records all changes on the database.

2. At the end of the SQL statement that changes the database, a record is written at the end of the Binlog, and the statement parser is notified, and the statement executes.

3. Binlog format

• Statement-based, there is no guarantee that all statements will succeed from the library, such as update ... limit 1;

• Based on the row, each change is recorded as a row in Binlog. Row-based formatting has an advantage when performing a particularly complex update or delete operation.

Log in to MySQL view Binlog

1. View only the contents of the first Binlog file

   Show Binlog events;

2. View the contents of a specified Binlog file

   Show Binlog events in ' mysql-bin.000002 ';

3. View the Binlog file that is currently being written

   Show Master Status\g

4. Get a list of binlog files

   Show binary logs;

View with Mysqlbinlog tool

Attention:

1. Do not view the Binlog file that is currently being written

2. Do not add--force parameters to force access

3. If the Binlog format is in line mode, add the-VV parameter

Local view

1. Based on start/end time

   Mysqlbinlog--start-datetime= ' 2013-09-10 00:00:00 '--stop-datetime= ' 2013-09-10 01:01:01 '-d library name binary file

2. Based on POS value

   Mysqlbinlog--start-postion=107--stop-position=1000-d Library name binary file

Remote Viewing

1. Specify the start/end time and redirect the results to the local T.binlog file.

   Mysqlbinlog-u username-p password-hl-db1.dba.beta.cn6.qunar.com---read-from-remote-server-- Start-datetime= ' 2013-09-10 23:00:00 '--stop-datetime= ' 2013-09-10 23:30:00 ' m

How MySQL binlog data is viewed