https://dev.mysql.com/replication-rbr-safe-unsafe.html
Whenever the 50 most recent ER_BINLOG_UNSAFE_STATEMENT warnings have been generated more than 50 times in any 50-second period, warning suppression is enabled. When activated, this causes such warnings not to be written to the error log; instead, ...
https://dev.mysql.com/replication-semisync.html
If semisynchronous replication is enabled on the master side and there is at least one semisynchronous slave, a thread that performs a transaction commit on the master blocks and waits until at least one semisynchronous slave acknowledges that it ...
https://dev.mysql.com/rewriter-query-rewrite-plugin-reference.html
Rewriter_number_reloads The number of times the rewrite_rules table has been loaded into the in-memory cache used by the Rewriter plugin. Rewriter_reload_error Whether an error occurred the most recent time that the rewrite_rules table was loaded ...
https://dev.mysql.com/roles.html
To specify mandatory roles at server startup, define mandatory_roles in your server my.cnf file: [mysqld] mandatory_roles='role1,role2@localhost,r3@%.example.com' To set and persist mandatory_roles at runtime, use a statement like this: SET PERSIST ...Like user accounts, roles can have privileges granted to and revoked from ...
https://dev.mysql.com/routines-table.html
DATETIME_PRECISION For stored function temporal return values, the fractional seconds precision. LAST_ALTERED The date and time when the routine was last modified. The ROUTINES table provides information about stored routines (stored procedures and ...
https://dev.mysql.com/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. For an inner join between two tables, the join returns a row from one ...The optimizer uses semijoin strategies to improve subquery execution, as described in this ...
https://dev.mysql.com/set.html
It also does not matter how many times a given element is listed in the value. When the value is retrieved later, each element in the value appears once, with elements listed according to the order in which they were specified at table creation time. A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...
https://dev.mysql.com/setting-environment-variables.html
To have the settings take effect each time you log in, use the interface provided by your system or place the appropriate command or commands in a startup file that your command interpreter reads each time it starts. Environment variables can be ...
https://dev.mysql.com/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated and will be removed in a future MySQL release. Use the Performance Schema instead; see Section 26.19.1, “Query Profiling Using Performance Schema”. To control profiling, use the ...
https://dev.mysql.com/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. Prior to the introduction of sorted index builds, index entries were inserted into the B-tree one record at a time using insert APIs.