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/replication-functions.html
The functions described in the following sections are used with MySQL Replication. GTID_SUBTRACT() Return all GTIDs in set that are not in subset. MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-system-variables.html
These variables are unavailable unless the appropriate keyring plugin is installed (see Section 8.4.4.3, “Keyring Plugin Installation”). keyring_aws_cmk_id Command-Line Format --keyring-aws-cmk-id=value System Variable keyring_aws_cmk_id Scope ...See the description of that variable for details, as well as for considerations to take into account if you create the directory ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
The index is not required to be a PRIMARY KEY or UNIQUE, but to avoid duplicate values in the AUTO_INCREMENT column, those index types are recommended. ON DUPLICATE KEY UPDATE, which in the worst case is in effect an INSERT followed by a UPDATE, ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
The binary format is structured to enable the server to look up subobjects or nested values directly by key or array index without reading all values before or after them in the document. To display the desired value using mascot as the key, but ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
Important To connect to the server using an account that authenticates with the sha256_password plugin, you must use either a TLS connection or an unencrypted connection that supports password exchange using an RSA key pair, as described later in ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
The conditions for use of SQL_CALC_FOUND_ROWS with UNION are: The SQL_CALC_FOUND_ROWS keyword must appear in the first SELECT of the UNION. ON DUPLICATE KEY UPDATE statements, the affected-rows value per row is 1 if the row is inserted as a new row, ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html
If you have UNIQUE constraints on secondary keys, you can speed up table imports by temporarily turning off the uniqueness checks during the import session: SET unique_checks=0; ... If you have FOREIGN KEY constraints in your tables, you can speed ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
In addition, an INSERT into a table that has a composite primary key containing an AUTO_INCREMENT column that is not the first column of this composite key is unsafe. ON DUPLICATE KEY UPDATE statements on tables with multiple primary or unique keys.
https://dev.mysql.com/doc/refman/8.0/en/insert.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... INSERT with an ON DUPLICATE KEY UPDATE clause enables existing rows to be updated if a row to be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html
This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment values). Primary key values are included in secondary indexes, which takes up unnecessary space if the ...If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of ...