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/create-index.html
For more information, see Section 15.1.20.9, “Secondary Indexes and Generated Columns”. For example (col1, col2, col3) specifies a multiple-column index with index keys consisting of values from col1, col2, and col3. As of MySQL 8.0.12, ASC and ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.html
However, if you are unable to update your clients and applications to support this new authentication method, you can configure the MySQL server to use mysql_native_password for legacy authentication. Use Legacy Authentication Method (Retain MySQL ... MySQL Installer provides a wizard-like tool to install and configure new MySQL products for ...Note Full ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-issues.html
Examples of incidents are server failures, database resynchronization, some software updates, and some hardware changes.) When the replica encounters a gap in the replication log, it stops with an error message. All SQL nodes acting as sources and ...A loss of connection can occur either between the source cluster SQL node and the replica cluster SQL node, or between the source SQL node and the data nodes of the source ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
For UPDATE and DELETE statements, if the optimizer falls back to a full table scan and the sql_safe_updates system variable is enabled, an error occurs rather than a warning because, in effect, no key is used to determine which rows to modify. For ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
Sequence numbers start at 1 and increase for passwords that have the same pwd_timestamp value. Only this format supports the optional query time and size statistics, which are available from MySQL 8.0.30. Adding Query Statistics for Outlier ... This ...The audit log plugin can also control which audited events are written to the audit log file, based on event content or the account from which events ...
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
PAM enables a system to use a standard interface to access various kinds of authentication methods, such as traditional Unix passwords or an LDAP directory. PAM pluggable authentication provides these capabilities: External authentication: PAM ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
This works for these algorithms since they both map a WRITE_ROW event to an insert or update depending on whether the row already exists, and the required metadata (the “after” image for the timestamp column) is present in the “WRITE_ROW” ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
Tx2: INSERT INTO t1 (c2) VALUES ('xxx'); InnoDB cannot tell in advance how many rows are retrieved from the SELECT in the INSERT statement in Tx1, and it assigns the auto-increment values one at a time as the statement proceeds. With a table-level ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...To use the AUTO_INCREMENT mechanism with an InnoDB table, an AUTO_INCREMENT column must be defined as ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
Options and Variables Introduced in MySQL 8.0 Options and Variables Deprecated in MySQL 8.0 Options and Variables Removed in MySQL 8.0 This section lists server variables, status variables, and options that were added for the first time, have been ...Options and Variables Introduced in MySQL 8.0 The following system variables, status variables, and server options have been added in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
Examples: SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(time_col))) FROM tbl_name; SELECT FROM_DAYS(SUM(TO_DAYS(date_col))) FROM tbl_name; Functions such as SUM() or AVG() that expect a numeric argument cast the argument to a number if necessary. For a faster ...For more information, see Section 14.19.3, “MySQL Handling of GROUP ...