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/function-resolution.html
MySQL supports built-in (native) functions, loadable functions, and stored functions. This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server ...
https://dev.mysql.com/doc/refman/9.7/en/gis-data-formats.html
The second uses a WKT representation converted to a Point with ST_GeomFromText(). Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/grant.html
[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role [, user_or_role] ... These syntax restrictions apply: GRANT cannot mix granting both privileges and roles ...
https://dev.mysql.com/doc/refman/9.7/en/group-by-optimization.html
The second method first performs a range scan, and then groups the resulting tuples. The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-bootstrap.html
If it is saved in the option file, upon restart the server automatically bootstraps a second group with the same name. The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-change-primary.html
When this is done, the current primary becomes a read-only secondary, and the specified group member becomes the read/write primary; this replaces the usual primary election process (see Section 20.1.3.1, “Single-Primary Mode”). You can specify ... This section explains how to change which member of a single-primary group is the primary, using the group_replication_set_as_primary() function, which can be can be run on any member of the ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-fault-tolerance.html
However, if a second server fails involuntarily, then the group (with one server left) blocks, because there is no majority to reach a decision. MySQL Group Replication builds on an implementation of the Paxos distributed algorithm to provide ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-network-partitioning.html
A few seconds after this, looking again at the replication_group_members table on s1 shows that it is still online, but several others members are not. The group needs to achieve consensus whenever a change that needs to be replicated happens. This ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-performance-xcom-cache-increase.html
In this situation, consider increasing the group_replication_message_cache_size limit with reference to the expected volume of messages in the time period specified by the group_replication_member_expel_timeout system variable plus the 5-second ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-primary-election-component.html
This means that, on failover, the component chooses as the new primary the secondary which is most up to date, based on how many transactions are in the secondary's backlog; the secondary with the smallest backlog (fewest transactions behind) is ...