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/faqs-general.html
Does MySQL have a NOW() function with fractions of seconds? A.1.7. Does MySQL have a NOW() function with fractions of seconds? Yes, see Section 13.2.6, “Fractional Seconds in Time Values”. Why did MySQL version numbering skip versions 6 and 7 ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
For example, if the account is set to use FIDO as the second authentication factor, the user invokes mysql with the --fido-register-factor=2 option. If the user account is configured with the authentication_fido plugin set as the second or third ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-query-expansion.html
It works by performing the search twice, where the search phrase for the second search is the original search phrase concatenated with the few most highly relevant documents from the first search. Thus, if one of these documents contains the word ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-new-primary.html
The current primary becomes a read-only secondary, and the specified group member becomes the read-write primary. timeout: An integer specifying a timeout in seconds for transactions that are running on the existing primary when you use the function. You can set a timeout from 0 seconds (immediately) up to 3600 seconds (60 ... The following function enables you to ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
Limits on Transaction Size If an individual transaction results in message contents which are large enough that the message cannot be copied between group members over the network within a 5-second window, members can be suspected of having failed, ... Limit on Group Size Limits on Transaction Size The following known limitations exist for Group ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure.html
If a group member does not receive any messages from a particular fellow member for 5 seconds, when this detection period ends, it creates a suspicion of the fellow member. The member could potentially survive for a further few seconds after the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-tuning-recovery.html
Once the server joining the group has made one attempt to connect to each of the suitable donors in the group, the distributed recovery process sleeps for the number of seconds configured by the group_replication_recovery_reconnect_interval system ... Several aspects of Group Replication's distributed recovery process can be configured to suit your ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html
TIME The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. If a thread stays in a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-configuring-io-capacity.html
The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing dirty pages from the buffer pool and writing changes from the change buffer to the appropriate secondary indexes. It ...InnoDB attempts to perform these tasks in a way that does not adversely affect the normal working of the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
In this case, if the file extension size is larger than 16MB, and the previous file extension occurred within the last second, the new undo tablespace is created at a quarter of the size defined by the innodb_max_undo_log_size variable. To handle ...