PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/flush.html
If the --skip-grant-tables option was specified at server startup to disable the MySQL privilege system, FLUSH PRIVILEGES provides a way to enable the privilege system at runtime. This operation is a very convenient way to get backups if you have a ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/9.7/en/grant-tables.html
At startup, and at runtime when FLUSH PRIVILEGES is executed, the server checks user table rows. password_last_changed is a TIMESTAMP column indicating when the password was last changed. If the password is past its lifetime (assessed using the ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-adding-instances.html
It is now time to expand the group by adding the other two servers configured previously. In other words, the transactions applied on s1 up to the point in time that s2 joined the group have been replicated to s2. At this point, the group has one ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-background.html
The group can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. There is a built-in group membership service that keeps the view of the group consistent and available for all servers ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-change-primary.html
You can specify a timeout from 1 to 3600 seconds (60 minutes) for transactions that are running when you use the function. Specify 0 for no timeout (or do not specify a timeout value), in which case the group waits indefinitely. If you do not set ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-cloning.html
To avoid this situation, ensure that you set the threshold to a number higher than the number of transactions that you would expect to occur in the group during the time taken for the remote cloning operation. A remote cloning operation might take ... If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-communication-protocol.html
For example: SELECT group_replication_set_communication_protocol("8.0.16"); The group_replication_set_communication_protocol() function is implemented as a group action, so it is executed at the same time on all members of the group. If a member ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-distributed-recovery.html
As state transfer from the binary log is based on classic asynchronous replication, it might take a very long time if the server joining the group does not have the group's data at all, or has data taken from a very old backup image. This minimizes ... Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-flow-control-stats-component.html
Gr_flow_control_throttle_last_throttle_timestamp: The most recent date and time that a transaction was throttled. The Group Replication Flow Control Statistics component (component_group_replication_flow_control_stats) enables a number of global ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-functions-for-new-primary.html
You can specify a timeout for transactions that are running when you use the function. For the timeout to work, all members of the group must be MySQL version 8.0.29 or newer. When the timeout expires, for any transactions that did not yet reach ...