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/mysql-cluster-log-statistics.html
This is the number of primary key read operations using this TC as the transaction coordinator that were started in the last reporting interval, including simple reads. A unique index read operation generates 2 primary key read operations—1 for ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-example.html
Its use here to redistribute data onto a new NDB Cluster node group is an exception in this regard; when used in this way, no other keywords or identifiers follow REORGANIZE PARTITION. In this section we provide a detailed example illustrating how ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key respects: The partitions to be checked are specified by the issuer of the statement, unlike partition pruning, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
IDEMPOTENT mode causes suppression of duplicate-key and no-key-found errors; STRICT means no such suppression takes place. For storage engines other than NDB, IDEMPOTENT mode should be used only when you are absolutely sure that duplicate-key errors ... This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas Options for Logging Replica Status to Tables System Variables Used on Replicas Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a key lookup. You are using a key with low cardinality (many rows match the key value) through another column.
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
ANALYZE TABLE performs a key distribution analysis and stores the distribution for the named table or tables. To suppress logging, specify the optional NO_WRITE_TO_BINLOG keyword or its alias LOCAL. ANALYZE TABLE Output Key Distribution Analysis ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
This would be the case, for example, were custid a primary key of customers. For example, if name is a primary key, its value determines the value of address because each group has only one value of the primary key and thus only one row. The query ... SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY ...
https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimization.html
In this case, the key column contains a list of indexes used, and key_len contains a list of the longest key parts for those indexes. AND key_partN = constN Any range condition over the primary key of an InnoDB table. Here is an example of such a ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
The conditions for use of SQL_CALC_FOUND_ROWS with UNION are: The SQL_CALC_FOUND_ROWS keyword must appear in the first SELECT of the UNION. ON DUPLICATE KEY UPDATE statements, the affected-rows value per row is 1 if the row is inserted as a new row, ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
Each row in the index node contains the values of the (user-specified or system-generated) primary key and all the other columns of the table. Secondary indexes in InnoDB tables are also B-trees, containing pairs of values: the index key and a ...