MySQL in a Nutshell

Name

SHOW BINLOG EVENTS

Synopsis

SHOW BINLOG EVENTS [IN 'filename'] 
   [FROM position] [LIMIT [offset,] count]

Use this statement to display the events in a binary logfile. Use the IN clause to specify a particular logfile. If the IN clause is omitted, the current file is used. To obtain a list of binary logfiles, use the SHOW MASTER LOGS statement. Here is an example of how you can use this statement with the results following the SQL statement:

SHOW BINLOG EVENTS IN 'log-bin.000161'\G
*************************** 1. row ***************************
    Log_name: log-bin.000161
         Pos: 4
  Event_type: Start
   Server_id: 1
Orig_log_pos: 4
        Info: Server ver: 4.1.7-standard-log, Binlog ver: 3
1 row in set (0.00 sec)

This logfile has only one row of data, because the SQL statement was run shortly after the server was started. For a larger logfile with many rows of events recorded, you can focus and limit the results with the FROM and LIMIT clauses. In the results, notice the Pos label with a value of 4. In a large logfile, that number might be higher, in the thousands. The results displayed could be focused only to rows starting from a particular position in the log with the FROM clause. You can limit the number of rows of events displayed with the LIMIT clause. In the LIMIT clause, you can set the starting point of the output based on the number of rows in the results set and limit them to a certain number of rows. Here is an example of both of these clauses:

SHOW BINLOG EVENTS IN 'log-bin.000160' FROM ...