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/json-modification-functions.html
JSON_MERGE_PATCH(json_doc, json_doc[, json_doc] ...) Performs an RFC 7396 compliant merge of two or more JSON documents and returns the merged result, without preserving members having duplicate keys. If both arguments are objects, the result of the ... The functions in this section modify JSON values and return the ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-encrypted-file-plugin.html
Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_encrypted_file keyring plugin stores keyring data in an encrypted, password-protected file local to the server host. To ...
https://dev.mysql.com/doc/refman/5.7/en/midpoint-insertion.html
By default, the key cache management system uses a simple LRU strategy for choosing key cache blocks to be evicted, but it also supports a more sophisticated method called the midpoint insertion strategy. The division point between two parts is not ...When using the midpoint insertion strategy, the LRU chain is divided into two parts: a hot sublist and a warm ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-option-tables.html
ndb-distribution: Default distribution for new tables in NDBCLUSTER (KEYHASH or LINHASH, default is KEYHASH). ndb-log-exclusive-reads: Log primary key reads with exclusive locks; allow conflict resolution based on read conflicts. The following list ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
In addition, an INSERT into a table that has a composite primary key containing an AUTO_INCREMENT column that is not the first column of this composite key is unsafe. ON DUPLICATE KEY UPDATE statements on tables with multiple primary or unique keys.
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--des-key-file=file_name Command-Line Format --des-key-file=file_name Deprecated Yes Read the default DES keys from this file. Consequently, --des-key-file also is deprecated and is removed in MySQL 8.0. InnoDB tablespace encryption relies on the ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-dml.html
These operations are guaranteed to only affect one row when issued through the memcached interface, because the key is unique within the table. key refers to the column listed under key_columns, and val refers to the column listed under ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-memcached.html
This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment values). Primary key values are included in secondary indexes, which takes up unnecessary space if the ...If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-tc-time-track-stats.html
Each TC instance tracks latencies for a set of activities it undertakes on behalf of API nodes or other data nodes; these activities include transactions, transaction errors, key reads, key writes, unique index operations, failed key operations of ... The tc_time_track_stats table provides time-tracking information obtained from the DBTC block (TC) instances in the data nodes, through API nodes access ...