https://dev.mysql.com/partitioning-pruning.html
An INSERT statement also accesses only one partition per inserted row; this is true even for a table that is partitioned by HASH or KEY although this is not currently shown in the output of EXPLAIN. The optimization known as partition pruning is ...
https://dev.mysql.com/partitioning-range.html
(See Bug #42849.) Range partitioning is particularly useful when one or more of the following conditions is true: You want or need to delete “old” data. A table that is partitioned by range is partitioned in such a way that each partition ...
https://dev.mysql.com/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...
https://dev.mysql.com/performance-schema-instrument-filtering.html
This affects primarily mutexes, conditions, and rwlocks in the server, although there may be other instruments for which this is true. The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM ...
https://dev.mysql.com/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 12.25.3, “Expression Handling”, and Section 12.25.4, “Rounding Behavior”. Consider the ...
https://dev.mysql.com/program-variables.html
On the other hand, with SET, you can assign a variable's value using an expression, which is not true when you set a variable at server startup. Many MySQL programs have internal variables that can be set at runtime using the SET statement. See ...
https://dev.mysql.com/repeat.html
[begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition expression is true. statement_list consists of one or more statements, each ...
https://dev.mysql.com/replication-administration-status.html
A value of 0 for Seconds_Behind_Master can usually be interpreted as meaning that the slave has caught up with the master, but there are some cases where this is not strictly true. The most common task when managing a replication process is to ...
https://dev.mysql.com/replication-binlog-encryption-encryption-keys.html
The format of binary log encryption keys in the keyring is as follows: MySQLReplicationKey_{UUID}_{SEQ_NO} For example: MySQLReplicationKey_00508583-b5ce-11e8-a6a5-0010e0734796_1 {UUID} is the true UUID generated by the MySQL server (the value of ...
https://dev.mysql.com/replication-features-differing-tables.html
(This is true even if both tables have the same number of columns.) Columns common to both versions of the table must be defined before any additional columns. Source and target tables for replication do not have to be identical. A table on the ...
