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-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-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/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/upgrade-before-you-begin.html
The only supported alternative is to restore a backup taken before upgrading. Upgrade procedures vary by platform and how the initial installation was performed. Use the procedure that applies to your current MySQL installation: For binary and ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-transitioning.html
The procedure installs the component before uninstalling the plugin, to avoid having a time window during which no password validation occurs. Uninstall the validate_password plugin: UNINSTALL PLUGIN validate_password; If the validate_password ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
However, you may use FLUSH in stored procedures, so long as these are not called from stored functions or triggers. Note It is not possible to issue FLUSH statements within stored functions or triggers. For information about prepared statement ...| ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 27.6, “Stored Object Access Control”. In general, the rules governing event names are the same as those for names of stored routines. The ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
(NDB 8.0.13) This global parameter can be set only in the [ndbd default] section, and defines the number of fragment replicas for each table stored in the cluster. Warning Setting NoOfReplicas to 1 means that there is only a single copy of all ...