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/fractional-seconds.html
MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-query-expansion.html
The following example shows this difference: mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database' IN NATURAL LANGUAGE MODE); +----+-------------------+------------------------------------------+ | id | title | body | ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...
https://dev.mysql.com/doc/refman/8.0/en/gis-geometrycollection-property-functions.html
mysql> SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))'; mysql> SELECT ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)); +-------------------------------------------------+ | ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)) | ...Unless ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html
mysql> SET @g = "MULTILINESTRING((10 10, 11 11), (9 9, 10 10))"; mysql> SELECT ST_AsText(ST_GeomCollFromText(@g)); +--------------------------------------------+ | ST_AsText(ST_GeomCollFromText(@g)) | +--------------------------------------------+ | ... These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
Group Replication configures this setting automatically for you after it selects a donor from the existing group members. To enable Group Replication to select a remote cloning operation for state transfer where this is more appropriate, set the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
One of the members listed in that table is selected as the donor of the missing data from the group to the joining member. These settings avoid the selection of duplicate auto-increment values for writes on group members, which causes rollback of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-communication-protocol.html
Example: SELECT group_replication_get_communication_protocol(); +------------------------------------------------+ | group_replication_get_communication_protocol() | +------------------------------------------------+ | 8.0.44 | ... The following ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-maximum-consensus.html
Example: SELECT group_replication_get_write_concurrency() For more information, see Section 20.5.1.3, “Using Group Replication Group Write Consensus”. Example: SELECT group_replication_set_write_concurrency(instances); For more information, see ... The following functions enable you to inspect and configure the maximum number of consensus instances that a group can execute in ...