Contact MySQL  | 
Login  |  Register
The world's most popular open source database
  • MySQL.com
  • Downloads
  • Documentation
  • Developer Zone
Developer Zone Downloads MySQL.com
Documentation
  • MySQL Server
  • MySQL Enterprise
  • Workbench
  • Router
  • MySQL NDB Cluster
  • Connectors
  • More
  • MySQL.com
  • Downloads
  • Developer Zone
Section Menu:  
Documentation Home
MySQL Internals Manual
  • Preface and Legal Notice
  • A Guided Tour Of The MySQL Source Code
  • Coding Guidelines
  • Reusable Classes and Templates
  • Building MySQL Server with CMake
  • Plugins
  • Transaction Handling in the Server
  • The Optimizer
  • Tracing the Optimizer
  • Memory Allocation
  • Important Algorithms and Structures
  • File Formats
  • How MySQL Performs Different Selects
  • How MySQL Transforms Subqueries
  • MySQL Client/Server Protocol
  • X Protocol
  • Stored Programs
  • Prepared Statement and Stored Routine Re-Execution
  • Writing a Procedure
  • Replication
  • The Binary Log
    • Binary Log Overview
    • High-Level Binary Log Structure and Contents
    • Source Files Related to the Binary Log
      • Source File Archaeological Notes
    • Generating Browsable Binary Log Information
    • Event Classes and Types
      • Event Class Archaeological Notes
    • Event Meanings
    • Event Structure
      • Event Content-Writing Conventions
      • Event Header Fields
        • Event Flags
      • Event Data Fields (Event-Specific Information)
        • Event Data Field Notational Caveat
    • Binary Log Versions
      • Determining the Binary Log Version
      • Ensuring Compatibility of Future Binary Log Versions
    • Event Data for Specific Event Types
      • LOAD DATA INFILE Events
    • Row-Based Binary Logging
    • Additional Resources
  • MyISAM Storage Engine
  • InnoDB Storage Engine
  • Writing a Custom Storage Engine
  • Test Synchronization
  • Injecting Test Faults
  • How to Create Good Test Cases
  • Error Messages
  • MySQL Source Code Distribution
  • InnoDB Source Code Distribution
  • Index
Download this Manual
EPUB - 1.2Mb


MySQL Internals Manual  /  The Binary Log

Chapter 20 The Binary Log

Table of Contents     [+/-]

20.1 Binary Log Overview
20.2 High-Level Binary Log Structure and Contents
20.3 Source Files Related to the Binary Log     [+/-]
20.3.1 Source File Archaeological Notes
20.4 Generating Browsable Binary Log Information
20.5 Event Classes and Types     [+/-]
20.5.1 Event Class Archaeological Notes
20.6 Event Meanings
20.7 Event Structure     [+/-]
20.7.1 Event Content-Writing Conventions
20.7.2 Event Header Fields
20.7.3 Event Data Fields (Event-Specific Information)
20.8 Binary Log Versions     [+/-]
20.8.1 Determining the Binary Log Version
20.8.2 Ensuring Compatibility of Future Binary Log Versions
20.9 Event Data for Specific Event Types     [+/-]
20.9.1 LOAD DATA INFILE Events
20.10 Row-Based Binary Logging
20.11 Additional Resources

This chapter describes the MySQL binary log, which contains information about data modifications made to a MySQL server instance.

Most of the information here applies equally to the relay log used on replication slave servers because a relay log has the same format as a binary log.


PREV   HOME   UP   NEXT
Download this Manual
EPUB - 1.2Mb
User Comments
Sign Up Login You must be logged in to post a comment.

Contact Sales

USA: +1-866-221-0634
Canada: +1-866-221-0634

Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447

Japan: 0120-065556
China: 10800-811-0823
India: 0008001005870

More Countries »
Contact Us Online »

  • Products
  • MySQL Enterprise Edition
  • MySQL Standard Edition
  • MySQL Classic Edition
  • MySQL Cluster CGE
  • MySQL Embedded (OEM/ISV)

  • Services
  • Training
  • Certification
  • Consulting
  • Support
  • Downloads
  • MySQL Community Server
  • MySQL NDB Cluster
  • MySQL Shell
  • MySQL Router
  • MySQL Workbench

  • About MySQL
  • Contact Us
  • How to Buy
  • Partners
  • Job Opportunities
  • Site Map
  • Documentation
  • MySQL Reference Manual
  • MySQL Workbench
  • MySQL NDB Cluster
  • MySQL Connectors
  • Topic Guides

  • Legal
  • Legal Policies
  • Your Privacy Rights
  • Terms of Use
  • Trademark Policy
  • Contributor Agreement
  © 2017, Oracle Corporation and/or its affiliates