PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
A user can be assigned only one filter, so if the user was already assigned a filter, the assignment is replaced. Note Setting audit_log_max_size by itself is not sufficient to cause log file pruning to occur because the pruning algorithm uses ...
https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html
For a query in which the condition is on the tables of a view created using ALGORITHM=TEMPTABLE instead of on the view itself, the multiple equality is not recognized at resolution, and thus the condition cannot be not pushed down. This is not an ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
If the table was created in an external directory by specifying the DATA DIRECTORY clause in the CREATE TABLE statement, the table that you replace on the destination instance must be defined with the same DATA DIRECTORY clause. Attempting to import ... This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption.html
The encryption algorithm used for the files, the AES (Advanced Encryption Standard) cipher algorithm, is built in to MySQL Server and cannot be configured. The two tier encryption key architecture means that the binary log master key can be rotated ... From MySQL 8.0.14, binary log files and relay log files can be encrypted, helping to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from unauthorized viewing by users of the operating system where they are ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/data-masking-component-usage.html
Terms then can then be added, removed, and selected from 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 ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-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/8.0/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/8.0/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/8.0/en/partitioning-selection.html
SQL statements supporting explicit partition selection are listed here: SELECT DELETE INSERT REPLACE UPDATE LOAD DATA. Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is ...