PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The server keeps tablespace metadata in memory for the lifetime of a tablespace. Multiple tables in fewer general tablespaces consume less memory for ...
https://dev.mysql.com/doc/refman/5.7/en/gis-data-formats.html
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 stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-observability.html
The entire state of the system (including the view, conflict statistics and service states) can be queried through performance_schema tables. There is a lot of automation built into the Group Replication plugin. Nonetheless, you might sometimes ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-members.html
The information is shared between all the server instances that are members of the replication group, so information on all the group members can be queried from any member. The performance_schema.replication_group_members table is used for ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-server-states.html
However, if there is a network partition, or a server leaves the group, then different information could be reported, depending on which server is queried. There are various states that a server instance can be in. If servers are communicating ...
https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html
The functions described in this section are used with GTID-based replication. It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. As such, the GTID sets must always be quoted when used ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... ] HANDLER tbl_name READ index_name { FIRST | NEXT | PREV | LAST } [ WHERE where_condition ] [LIMIT ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X.
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...
https://dev.mysql.com/doc/refman/5.7/en/index-preloading.html
Without preloading, the blocks are still placed into the key cache as needed by queries. If there are enough blocks in a key cache to hold blocks of an entire index, or at least the blocks corresponding to its nonleaf nodes, it makes sense to ...