Search Results
MySQL 8.4 Reference Manual :: 19.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-safe-unsafe.html
The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based format. If this is true of the statement, we refer to the statement as safe; otherwise, we ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. This method of index creation is also known as a sorted index build. In the first phase, the clustered index is scanned, and index ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
C API Notes Compilation Notes Configuration Notes SQL Function and Operator Notes JavaScript Programs Performance Schema Notes sys Schema Notes Thread Pool Notes Functionality Added or Changed Bugs Fixed C API Notes The asynchronous interface used ...
https://dev.mysql.com/doc/internals/en/getting-index-information.html
It is preferable for storage engines that support indexing to read the index information provided during a CREATE TABLE operation and store it for future use. The reasoning behind this is that the index information is most readily available during ...
https://dev.mysql.com/doc/internals/en/the-myi-file.html
A .MYI file for a MyISAM table contains the table's indexes. The .MYI file has two parts: the header information and the key values. So the next sub-sections will be "The .MYI Header" and "The .MYI Key Values". The .MYI Header A .MYI file begins ...
https://dev.mysql.com/doc/internals/en/unsafe-statements.html
NOTE: the following list is incomplete; it does not take into account changes made in 2010 or later (roughly). An unsafe statement will be logged in row format if binlog_format=MIXED and will generate a warning if binlog_format=STATEMENT. The ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-5-7.html
This section provides information about keywords and reserved words in MySQL 5.7. MySQL 5.7 Keywords and Reserved Words MySQL 5.7 New Keywords and Reserved Words MySQL 5.7 Removed Keywords and Reserved Words MySQL 5.7 Keywords and Reserved Words ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-8-0.html
This section provides information about keywords and reserved words in MySQL 8.0. MySQL 8.0 Keywords and Reserved Words MySQL 8.0 New Keywords and Reserved Words MySQL 8.0 Removed Keywords and Reserved Words MySQL 8.0 Keywords and Reserved Words ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-8-4.html
This section provides information about keywords and reserved words in MySQL 8.4. MySQL 8.4 Keywords and Reserved Words MySQL 8.4 New Keywords and Reserved Words MySQL 8.4 Removed Keywords and Reserved Words MySQL 8.4 Keywords and Reserved Words ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-9-3.html
This section provides information about keywords and reserved words in MySQL 9.3. MySQL 9.3 Keywords and Reserved Words MySQL 9.3 New Keywords and Reserved Words MySQL 9.3 Removed Keywords and Reserved Words MySQL 9.3 Keywords and Reserved Words ...