PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/purge-binary-logs.html
To safely purge binary log files, follow this procedure: On each replica, use SHOW SLAVE STATUS to check which log file it is reading. Obtain a listing of the binary log files on the replication source server with SHOW BINARY LOGS. PURGE { BINARY | ...
https://dev.mysql.com/doc/refman/5.7/en/replica-io-thread-states.html
The following list shows the most common states you see in the State column for a replica server I/O thread. This state also appears in the Slave_IO_State column displayed by SHOW SLAVE STATUS, so you can get a good view of what is happening by ...
https://dev.mysql.com/doc/refman/5.7/en/replica-sql-thread-states.html
The Info column for the SQL thread may also show the text of a statement. Making temporary file (create) before replaying LOAD DATA INFILE The thread is executing a LOAD DATA statement and is creating a temporary file containing the data from which ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
This means that fields which display GTID sets, such as gtid_executed, gtid_purged, RECEIVED_TRANSACTION_SET in the replication_connection_status Performance Schema table, and the GTID related results of SHOW SLAVE STATUS, now return the empty ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options.html
In MySQL 5.7, auto.cnf has only a single [auto] section containing a single server_uuid setting and value; the file's contents appear similar to what is shown here: [auto] server_uuid=8a94f357-aab4-11df-86ab-c80aa9429562 Important The auto.cnf file ... The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
To see which plugins are installed, use the SHOW PLUGINS statement, or query the Information Schema PLUGINS table. To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
If the database on the source contains existing data it is necessary to copy this data to each replica. There are different ways to dump the data from the source. To select the appropriate method of dumping the database, choose between these ...
https://dev.mysql.com/doc/refman/5.7/en/revoke.html
To determine what privileges remain after the operation, use SHOW GRANTS. The REVOKE statement enables system administrators to revoke privileges from MySQL accounts. For details on the levels at which privileges exist, the permissible priv_type, ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: $> mysqld ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
To determine all possible values for a SET column, use SHOW COLUMNS FROM tbl_name LIKE set_col and parse the SET definition in the Type column of the output. A SET is a string object that can have zero or more values, each of which must be chosen ...