PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
These statements are subject to rewriting: As of MySQL 8.0.12: SELECT, INSERT, REPLACE, UPDATE, and DELETE. Beginning with MySQL 8.0.31, statements run by users with the SKIP_QUERY_REWRITE privilege are not subject to rewriting, provided that the ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. If the session time zone is UTC, there is effectively no time zone ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
To avoid frequent compression failures in write-intensive workloads, such as for OLTP applications, MySQL sometimes reserves some empty space (padding) in the page, so that the modification log fills up sooner and the page is recompressed while ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filtering.html
Legacy mode (deprecated in MySQL 8.0.34) is filtering behavior as it was prior to MySQL 5.7.13; that is, before the introduction of rule-based filtering. Audit log filtering is used to implement component services from MySQL 8.0.30. By default, ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-dns-srv.html
MySQL supports the use of DNS SRV records for connecting to servers. A client that receives a DNS SRV lookup result attempts to connect to the MySQL server on each of the listed hosts in order of preference, based on the priority and weighting ...
https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html
Prior to MySQL 8.0.14, a derived table cannot contain outer references. This is a MySQL restriction that is lifted in MySQL 8.0.14, not a restriction of the SQL standard. This is also true of the following nested SELECT: mysql> EXPLAIN SELECT NOW() ...For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-component.html
Both files should be readable only by the appropriate user that runs the server, typically mysql. The manifest file must be named mysqld.my and added to the same directory where mysqld is installed. It contains the path to the file where the server ... The component_keyring_file keyring component stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
That is, MySQL account management supports accounts that use 2FA or 3FA, in addition to the existing 1FA support. When a client attempts a connection to the MySQL server using a single-factor account, the server invokes the authentication plugin ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning.html
In MySQL 8.0, partitioning support is provided by the InnoDB and NDB storage engines. MySQL 8.0 does not currently support partitioning of tables using any storage engine other than InnoDB or NDB, such as MyISAM. If you are compiling MySQL 8.0 from ...Note Table partitioning differs from partitioning as used by window ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-prerequisites.html
To install MySQL from source, the following system requirements must be satisfied, regardless of installation method: CMake, which is used as the build framework on all platforms. On Unix-like systems, including Linux, you can check your system's ...