Search Results
https://dev.mysql.com/doc/internals/en/binary-log-versions.html
In v1 and v3, this event is called a "start event." In v4, it is called a "format description event." Elsewhere you may see either term used generically to refer collectively to both types of event. There are several versions of the binary log file ...
https://dev.mysql.com/doc/internals/en/binlog-formats.html
Status of this subsection: Complete but not reviewed 2009-10-21 The binlog is organized as a linear sequence of events. An SQL query that modifies the database will generate one or more events and append them to the binlog. There are also auxiliary ...
https://dev.mysql.com/doc/internals/en/character-set.html
A given collation implies the character set and the names of both can be seen in the INFORMATION_SCHEMA COLLATIONS table. MySQL has a very flexible character set support as documented in Character Sets, Collations, Unicode. Number Hex Character Set ...
https://dev.mysql.com/doc/internals/en/charsets.html
Character sets are used by MySQL when storing information, both to ensure that the information is stored (and returned) in the correct format, but also for the purposes of collation and sorting. Each character set supports one or more collations, ...
https://dev.mysql.com/doc/internals/en/code-tree-representation.html
One more bit per value/offset is written in advance, to distinguish both. Every left branch gets a 0 bit, every right branch gets a 1 bit. The in-memory representation of the trees are two unsigned integers per node. Each describes either a leaf ...
https://dev.mysql.com/doc/internals/en/connection-phase-packets.html
If both server and client support CLIENT_PLUGIN_AUTH capability, server can send this packet to ask client to use another authentication method. Protocol::Handshake Initial Handshake Packet When the client connects to the server the server sends a ...
https://dev.mysql.com/doc/internals/en/determining-authentication-method.html
The method used is Secure Password Authentication if both CLIENT_PROTOCOL_41 and CLIENT_SECURE_CONNECTION are set but CLIENT_PLUGIN_AUTH is not set. Method used for authentication is tied to the user account and stored in the plugin column of ...
https://dev.mysql.com/doc/internals/en/determining-logging-format.html
For each statement, we must determine the logging format: row or statement. At parse time, it is detected if the statement is unsafe to log in statement format (that is, requires row format). This must be done prior to the call to ...
https://dev.mysql.com/doc/internals/en/differences-master-slave.html
Any intermediate state of the slave is identical to some intermediate state of the master. Note: it is not required that each intermediate state of the master is identical to some intermediate state of the slave. We now state the architectural ...
https://dev.mysql.com/doc/internals/en/event-class-archaeological-notes.html
The start events for both v1 and v3 therefore have a type code of 1, although the event structures differ and must be distinguished by examining their contents. Despite the "V3" in the type code name, START_EVENT_V3 currently is used as the type ...