PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/federated-storage-engine.html
The FEDERATED storage engine lets you access data from a remote MySQL database without using replication or cluster technology. Querying a local FEDERATED table automatically pulls the data from the remote (federated) tables. To include the ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
In addition, since returned rows must be stored in memory, such a query can also lead to the local server swapping, or even hanging. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server ...
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 ...