PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-encryption-keys.html
The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL Keyring”).
https://dev.mysql.com/doc/refman/8.0/en/replication-channels.html
In MySQL multi-source replication, a replica opens multiple replication channels, one for each source server. For instructions to configure sources and replicas for multi-source replication, to start, stop and reset multi-source replicas, and to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-reset-replica.html
The RESET REPLICA statement can be used to reset a multi-source replica. By default, if you use the RESET REPLICA statement on a multi-source replica all channels are reset. Optionally, use the FOR CHANNEL channel clause to reset only a specific ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-stop-replica.html
The STOP REPLICA statement can be used to stop a multi-source replica. By default, if you use the STOP REPLICA statement on a multi-source replica all channels are stopped. Optionally, use the FOR CHANNEL channel clause to stop only a specific ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-account.html
From MySQL 8.0.19, the REQUIRE_ROW_FORMAT setting can be applied to secured channels, which restricts the channel from executing events that would require these privileges. The REPLICATION_APPLIER privilege explicitly or implicitly allows the ...
https://dev.mysql.com/doc/refman/8.0/en/select-benchmarking.html
To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client program. The return value is always zero, but mysql prints a line displaying approximately how long the statement took to ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-user.html
The statement requires the SELECT privilege for the mysql system schema, except to see information for the current user. For the current user, the SELECT privilege for the mysql.user system table is required for display of the password hash in the ... SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...
https://dev.mysql.com/doc/refman/8.0/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-elements.html
Prior to MySQL 8.0.14, the monitoring tables are INFORMATION_SCHEMA tables; see Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”. The INFORMATION_SCHEMA tables now are deprecated; expect them to be removed in a future version of MySQL. For ...Applications should transition away from the INFORMATION_SCHEMA tables to the Performance Schema ...