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/show-replica-status.html
Seconds_Behind_Source This field is an indication of how “late” the replica is: When the replica is actively processing updates, this field shows the difference between the current timestamp on the replica and the original timestamp logged on ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
A flush task configured using the audit_log_flush_interval_seconds system variable has a value of zero by default, which means the task is not scheduled to run. Start the server using audit_log_flush_interval_seconds and set the value to a number ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html
The window_size value is the time window in seconds; if omitted, the default window is 60 seconds. This rule throttles plugin-shutdown messages to 5 occurrences per 60 seconds: IF err_code == ER_PLUGIN_SHUTTING_DOWN_PLUGIN THEN throttle 5. The ...
https://dev.mysql.com/doc/refman/8.0/en/error-lost-connection.html
If you know that this is happening, you should try increasing net_read_timeout from its default of 30 seconds to 60 seconds or longer, sufficient for the data transfer to complete. In this case, if your connect_timeout value is set to only a few ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
This user then creates the following event: CREATE EVENT e_insert ON SCHEDULE EVERY 7 SECOND DO INSERT INTO myschema.mytable; After this event has been created, root revokes the EVENT privilege for jon@ghidora. However, e_insert continues to ... To ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
The User_attributes column may contain these attributes: additional_password: The secondary password, if any. For two-factor or three-factor forms of multifactor authentication, that plugin corresponds to the first authentication factor, but ... The ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html
20.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for it. 20.2.1.6.2 Adding Additional Instances Adding additional instances to the group is essentially the same sequence of steps ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
The second member joining the group needs to ask the member that bootstrapped the group to dynamically change the configuration in order for it to be added to the group. Warning When the network round-trip time (RTT) between any group members is 5 ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache.html
The length of this time period is controlled by the group_replication_member_expel_timeout system variable, which determines the waiting period (up to an hour) that is allowed in addition to the initial 5-second detection period for members to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-flushing.html
This is a background operation performed by a page cleaner thread once per second. Also, consider adjusting innodb_lru_scan_depth when changing the number of buffer pool instances, since innodb_lru_scan_depth * innodb_buffer_pool_instances defines ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...