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/charset-repertoire.html
For the second call, the repertoire is UNICODE because the second argument is outside the ASCII range. IF(column1 < column2, 'smaller', 'greater') The result repertoire is ASCII because the two string arguments (the second argument and the third ...
https://dev.mysql.com/doc/refman/9.7/en/error-log-configuration.html
Consider this log_error_services value: log_filter_internal; log_sink_1; log_sink_2 In this case, log events pass to the built-in filter, then to the first sink, then to the second sink. Compare that to this log_error_services value: log_sink_1; ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/group-replication-performance-xcom-cache.html
The length of this 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 return to ... The group communication engine for Group Replication (XCom, a Paxos variant) includes a cache for messages (and their metadata) exchanged between the group members as a part of the consensus ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 ...