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-features-invoked.html
Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always replicated. The following ...Note ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-temptables.html
In statement-based replication mode, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside a transaction, procedure, function, or trigger when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, event, view, user, role, or grant. In the following special cases, a single statement can ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
When binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside transactions, procedures, functions, and triggers when GTIDs are in use on the server (that is, when the ... Because GTID-based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html
Follow this procedure to set up replication with existing data: If you used MySQL Server's clone plugin to create a clone from an existing replica (see Section 7.6.7.7, “Cloning for Replication”), the data is already transferred. After you have ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-switch.html
To make Source a source again, use the preceding procedure as if Replica 1 were unavailable and Source were to be the new source. During this procedure, do not forget to run RESET MASTER on Source before making Replica 1, Replica 2, and Replica 3 ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
To reconfigure the SSL session cache at runtime, use this procedure: Set each cache-related system variable that should be changed to its new value. For example, change the cache timeout value from the default (300 seconds) to 600 seconds: mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/show-privileges.html
row *************************** Privilege: Alter routine Context: Functions,Procedures Comment: To alter or drop stored functions/procedures *************************** 3. row *************************** Privilege: Create routine Context: Databases ... SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. The ALTER ROUTINE privilege is needed to alter or drop stored routines. This privilege is granted automatically ...