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/data-masking-function-reference.html
Table 6.35 MySQL Enterprise Data Masking and De-Identification Functions Name Description gen_blacklist() Perform dictionary term replacement gen_dictionary_drop() Remove dictionary from registry gen_dictionary_load() Load dictionary into registry ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Data type specifications can have explicit or implicit default values. Explicit Default Handling Implicit Default Handling Explicit Default Handling A DEFAULT value clause in a data type specification explicitly indicates a default value for a ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
DELETE QUICK is most useful for applications where index values for deleted rows are replaced by similar index values from rows inserted later. DELETE is a DML statement that removes rows from a table. Single-Table Syntax DELETE [LOW_PRIORITY] ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
Invoke the mysql command-line client: mysql -u user -p Issue the following statement: mysql> INSTALL PLUGIN mysqlx SONAME 'mysqlx.so'; Replace mysqlx.so with mysqlx.dll for Windows. To use MySQL 5.7 as a document store, the X Plugin needs to be ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
SHOW WARNINGS displays an empty result for other explainable statements (DELETE, INSERT, REPLACE, and UPDATE). For SELECT statements, the EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
In the original statement, replace the expression with a reference to the variable, which the optimizer can treat as a constant value: SET @keyval = FLOOR(1 + RAND() * 49); UPDATE t SET col_a = some_expr WHERE id = @keyval; Assign the random value ...A function is nondeterministic if, given fixed values for its arguments, it can return different results for different ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
rename result table The thread is processing an ALTER TABLE statement, has created the new table, and is renaming it to replace the original table. The following list describes thread State values that are associated with general query processing ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
Whether use of temporary tables can be replaced by index access also depends on which parts of an index are used in a query, the conditions specified for these parts, and the selected aggregate functions. The most general way to satisfy a GROUP BY ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
Issue the following, replacing rpl_user and password with the values used when creating the user. Group Replication uses the asynchronous replication protocol to achieve Section 17.9.5, “Distributed Recovery”, synchronizing group members before ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html
For an explanation of the inner workings of the InnoDB buffer pool, an overview of its LRU replacement algorithm, and general configuration information, see Section 14.5.1, “Buffer Pool”. InnoDB maintains a storage area called the buffer pool ...