Search Results
https://dev.mysql.com/doc/internals/en/event-structure.html
This section describes the general properties of events as byte sequences as they are written to binary or relay log files. Some details of event structure are invariant across binary log versions; others depend on the version. Within any given ...
https://dev.mysql.com/doc/internals/en/floating-point-types.html
Both algorithms do not take the limited precision of float and double values into account. The MySQL Reference Manual has a discussion of floating-point numbers in Section 11.2 Numeric Types, including details about the storage. Let us now take up ...
https://dev.mysql.com/doc/internals/en/guided-tour-sedir.html
bdb /* external */ heap innobase /* external */ myisam myisammrg ndb Let's go through the idea of storage engines once more, this time with a list of all the storage engines, both the ones that we produce, and the ones that others produce. We've ...
https://dev.mysql.com/doc/internals/en/implementing-rnd-next-method.html
(The table definition is stored in the .frm file, and the optimizer and the handler are both able to access table metadata from the same source, its TABLE structure). After the table is initialized, the MySQL server will call the handler's ...
https://dev.mysql.com/doc/internals/en/innodb-infimum-and-supremum-records.html
Initially, they both exist on the root page, but as the index grows, the infimum record will exist on the first or lowest leaf page and the supremum will the last record on the last or greatest key page. “Infimum” and “Supremum” are ...
https://dev.mysql.com/doc/internals/en/logging-transactions-preliminary-rules.html
(PR-causality-precedence) If P-causality and P-durability cannot both be fulfilled, then P-causality is considered more important. The following preliminary rules are actually consequences of the principle that statements shall be correctly logged ...
https://dev.mysql.com/doc/internals/en/logging-transactions.html
It is not always possible to log correctly in statement format when both transactional and nontransactional tables are used in the same transaction. Statements that do an implicit commit (that is, most but not all DDL, and some utility commands) are ...
https://dev.mysql.com/doc/internals/en/myisampack.html
When starting to analyze the existing uncompressed data, it collects distinct column values up to a limit of 8KB. If there are more, it falls back to byte value compression for this column. This means also that myisampack may use different ...
https://dev.mysql.com/doc/internals/en/notes-on-mtr2.html
MTR2 has brought some new utility that can improve testing, but also some elements that can be pitfalls. Changes $MYSQLTEST_VARDIR/master-data -> $MYSQLD_DATADIR This change was introduced to work with parallel. Since MTR2 can run several instances ...
https://dev.mysql.com/doc/internals/en/optimizer-and-relations.html
Otherwise, since (both conditions are indexed and have equal join type) pick a driver based on the first index that was created. An ANDed search has the form condition1 AND condition2, as in this example: WHERE column1 = 'x' AND column2 = 'y' Here, ...