PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fetch.html
If a row exists, the fetched columns are stored in the named variables. This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. The number of columns ...
https://dev.mysql.com/doc/refman/8.0/en/fetching-spatial-data.html
Geometry values stored in a table can be fetched in internal format. Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code modifications. Modifying the default behavior in most cases can actually decrease effectiveness. Do not ...
https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html
Syntactic well-formedness is also checked for attempts to store geometries into tables. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial import functions that parse WKT or ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
The most important preconditions for using indexes for GROUP BY are that all GROUP BY columns reference attributes from the same index, and that the index stores its keys in order (as is true, for example, for a BTREE index, but not for a HASH ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
This is why the value of the group_replication_bootstrap_group option was not stored in the instance's option file. 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/8.0/en/group-replication-performance-xcom-cache.html
Note that the limit set using group_replication_message_cache_size applies only to the data stored in the cache, and the cache structures require an additional 50 MB of memory. The group communication engine for Group Replication (XCom, a Paxos ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
Infrastructure Server Instance Configuration Server instances that you want to use for Group Replication must satisfy the following requirements. Transactions are executed optimistically and then, at commit time, are checked for conflicts. If there ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-user-credentials.html
User credentials set using CHANGE REPLICATION SOURCE TO | CHANGE MASTER TO are stored in plain text in the replication metadata repositories on the server. Group Replication uses a distributed recovery process to synchronize group members when ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-view-changes.html
When the server joining the group reaches zero queued transactions and its stored data is equal to the other members, its public state changes to online. When Group Replication's distributed recovery process is carrying out state transfer from the ...