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-multi-source-configuration.html
The replica replicates one database from each of the sources, db1 from source1 and db2 from source2. See Section 19.1.2.1, “Setting the Replication Source Configuration” for how to configure a source using file position based replication. In ...
https://dev.mysql.com/doc/refman/8.0/en/show-master-status.html
SHOW MASTER STATUS This statement provides status information about the binary log files of the source server. row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql ...It requires ...
https://dev.mysql.com/doc/refman/8.0/en/show-replicas.html
Replica_UUID: The globally unique ID of this replica, as generated on the replica and found in the replica's auto.cnf file. {SHOW REPLICAS} Displays a list of replicas currently registered with the source. Host: The host name of the replica server, ...From MySQL 8.0.22, use SHOW REPLICAS in place of SHOW SLAVE HOSTS, which is deprecated from that ...
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-avg-latency.html
These views summarize wait class average latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_avg_latency and ...
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-latency.html
These views summarize wait class total latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_latency and ...
https://dev.mysql.com/doc/refman/8.0/en/tutorial.html
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. mysql may also be used in batch mode: you place your queries in a file beforehand, then tell mysql to execute ...mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
and db_name.event_name notation, as shown here: ALTER EVENT olddb.myevent RENAME TO newdb.myevent; To execute the previous statement, the user executing it must have the EVENT privilege on both the olddb and newdb databases. (See Section 15.1.13, ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-disconnecting.html
If the server runs on a machine other than the one where you log in, you must also specify a host name. For help with other problems often encountered when trying to log in, see Section B.3.2, “Common Errors When Using MySQL Programs”. To ...
https://dev.mysql.com/doc/refman/8.0/en/create-role.html
To use this statement, you must have the global CREATE ROLE or CREATE USER privilege. (These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) CREATE ROLE either succeeds for all ...When the read_only system variable is enabled, CREATE ROLE additionally requires the CONNECTION_ADMIN privilege (or the deprecated SUPER ...
https://dev.mysql.com/doc/refman/8.0/en/drop-role.html
To use this statement, you must have the global DROP ROLE or CREATE USER privilege. DROP ROLE either succeeds for all named roles or rolls back and has no effect if any error occurs. If the IF EXISTS clause is given, the statement produces a warning ...When the read_only system variable is enabled, DROP ROLE additionally requires the CONNECTION_ADMIN privilege (or the deprecated SUPER ...