PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/privileges-provided.html
This privilege is required to manipulate your own secondary password because most users require only one password. If an account is to be permitted to manipulate secondary passwords for all accounts, it should be granted the CREATE USER privilege ...
https://dev.mysql.com/doc/refman/9.7/en/problems-connecting.html
Because that row has a Host value 'localhost' that is more specific than '%', it is used in preference to the new row when connecting from localhost! The correct procedure is to insert a second row with Host='localhost' and User='some_user', or to ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/9.7/en/regexp.html
A - character between two other characters forms a range that matches all characters from the first character to the second. This section discusses the functions and operators available for regular expression matching and illustrates, with examples, ...
https://dev.mysql.com/doc/refman/9.7/en/repair-table.html
REPAIR TABLE upgrades a table if it contains old temporal columns in pre-5.6.4 format; namely, the TIME, DATETIME, and TIMESTAMP columns that lacked support for fractional seconds precision. [QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a ...
https://dev.mysql.com/doc/refman/9.7/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/9.7/en/replica-sql-thread-states.html
Waiting until SOURCE_DELAY seconds after source executed event The SQL thread has read an event but is waiting for the replica delay to lapse. The following list shows the most common states you may see in the State column for a replication SQL ...
https://dev.mysql.com/doc/refman/9.7/en/replication-administration-status.html
Seconds_Behind_Source: The number of seconds that the replication SQL (applier) thread is behind processing the source binary log. A value of 0 for Seconds_Behind_Source can usually be interpreted as meaning that the replica has caught up with the ... The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-asynchronous-connection-failover-source.html
Suitable values are SOURCE_RETRY_COUNT=3 and SOURCE_CONNECT_RETRY=10, which make the replica retry the connection 3 times with 10-second intervals between. For a managed group, a source’s weight is assigned depending on whether it is a primary or ... To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 in a CHANGE REPLICATION SOURCE TO statement for this ...
https://dev.mysql.com/doc/refman/9.7/en/replication-functions-synchronization.html
If a timeout value is specified, SOURCE_POS_WAIT() stops waiting when timeout seconds have elapsed. The functions listed in this section are used for controlling position-based synchronization of source and replica servers in MySQL Replication.
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-auto-positioning.html
Consider revising the binary log expiration period (binlog_expire_logs_seconds) on the source to ensure that the situation does not occur again. The second channel to attempt it skips the transaction using GTID auto-skip, because the transaction’s ... GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and ...