PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/myisam-key-cache.html
To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems. Otherwise, the server chooses a cache block buffer containing a different table index block (or blocks) and replaces the data ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
You can precede the SELECT by IGNORE or REPLACE to indicate how to handle rows that duplicate unique key values. With REPLACE, new rows replace rows that have the same unique key value. If neither IGNORE nor REPLACE is specified, duplicate unique ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
Items then can be selected from registered dictionaries and used as random values or as replacements for other values. Its arguments are the term to replace, the dictionary in which the term appears, and the dictionary from which to choose a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
This includes single-row and multiple-row INSERT and REPLACE statements that do not have a nested subquery, but not INSERT ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
For a comparison of JSON_INSERT(), JSON_REPLACE(), and JSON_SET(), see the discussion of JSON_SET(). If the second object has a member with a key matching a member in the first object, JSON_MERGE_PATCH() replaces the value in the first object with ... The functions in this section modify JSON values and return the ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
This results in a query with no outer joins at all: SELECT * FROM (T1 INNER JOIN T2 ON T2.A=T1.A), T3 WHERE T3.C > 0 AND T3.B=T2.B Sometimes the optimizer succeeds in replacing an embedded outer join operation, but cannot convert the embedding outer ... Table expressions in the FROM clause of a query are simplified in many ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
SQL statements supporting explicit partition selection are listed here: SELECT DELETE INSERT REPLACE UPDATE LOAD DATA. MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. Note Comparison behavior for database and table names in INFORMATION_SCHEMA queries might differ from what you expect. 1) Try to use constant lookup values for ...Certain types of queries for INFORMATION_SCHEMA tables can be optimized to execute more ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
For example, the following statement generates one Query event, two TableRead events, and a TableInsert events: INSERT INTO t3 SELECT t1.* FROM t1 JOIN t2; Each TableXXX event contains <TABLE> and <DB> elements to identify the table to which the ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
YourSQL','When comparing databases ...'), -> ('MySQL Security','When configured properly, MySQL ...'), -> ('Database, Database, Database','database database database'), -> ('1001 MySQL Tricks','1. | 0.36289870738983154 | | 1 | MySQL Tutorial | This ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...