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/network-namespace-support.html
Namespace-specific address spaces can lead to problems when MySQL connections cross namespaces. For example, the network address space for a MySQL instance running in a container or virtual network may differ from the address space of the host ... A ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
The mysql.user system table indicates for each account when its password was last changed, and the server automatically treats the password as expired at client connection time if its age is greater than its permitted lifetime. MySQL supports these ...Password reuse restrictions, to prevent old passwords from being chosen ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
The EXPLAIN statement provides information about how MySQL executes statements. It lists the tables in the output in the order that MySQL would read them while processing the statement. This means that MySQL reads a row from the first table, then ...EXPLAIN returns a row of information for each table used in the SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/entering-queries.html
This section describes the basic principles of entering queries, using several queries you can try out to familiarize yourself with how mysql works. We'll get to others later.) When you issue a query, mysql sends it to the server for execution and ... Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
This restriction is lifted for InnoDB tables in MySQL 8.0.14 and later. The partitioning and (if applicable) subpartitioning used by the partitioned table may be of any type or types supported in MySQL 8.0. Exchanging Partitions Without Row-By-Row ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
The size penalty for storing the hex string in a CHAR column is at least two times, up to eight times if the value is stored in a column that uses the utf8mb4 character set (where each character uses 4 bytes). Caution Passwords or other sensitive ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
Only this format supports the optional query time and size statistics, which are available from MySQL 8.0.30. Adding Query Statistics for Outlier Detection In MySQL 8.0.30 and later, you can extend log files in JSON format with optional data fields ...For best security, write the audit log to a directory accessible only to the MySQL server and to users with a legitimate reason to view the ... This section describes how to configure audit logging characteristics, such as the file to ...
https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html
GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. If necessary, initialize the data directory and create the MySQL grant tables. Windows installation ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
mysql> source MYSQL_HOME/share/innodb_memcached_config.sql Running the innodb_memcached_config.sql script is a one-time operation. Activate the daemon_memcached plugin by running the INSTALL PLUGIN statement: mysql> INSTALL PLUGIN daemon_memcached ... This section describes how to set up the daemon_memcached plugin on a MySQL ...Note Before setting up the daemon_memcached plugin, consult Section 17.20.5, “Security Considerations for the InnoDB memcached ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
In-place upgrade to MySQL 8.0 is not supported if tables contain old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision). Before upgrading to the latest MySQL 8.0 release, ...