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/ibd2sdi.html
--strict-check, -c Command-Line Format --strict-check=algorithm Type Enumeration Default Value crc32 Valid Values crc32innodbnone Specifies a strict checksum algorithm for validating the checksum of pages that are read. In this example, the strict ... ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
Tables created before MySQL 5.6 that include temporal columns (DATE, DATETIME or TIMESTAMP) and have not been rebuilt using ALGORITHM=COPY do not support ALGORITHM=INPLACE. ALGORITHM=INPLACE operation returns the following error: ERROR 1846 (0A000): ... The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-example.html
ALGORITHM=INPLACE, REORGANIZE PARTITION does not work on tables that were created with the MAX_ROWS option. In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html
compression-algorithms and compression-level: These options are available in MySQL Shell 8.0.20 and later for more control over connection compression. You can specify them to select the compression algorithm used for the connection, and the numeric ... This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
Before upgrading, run mysqlcheck --check-upgrade for removed spatial functions and replace any that you find with their ST_ or MBR named replacements. InnoDB Changes INFORMATION_SCHEMA views based on InnoDB system tables were replaced by internal ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connections.html
Encryption algorithms must include security elements to resist many kinds of known attacks such as changing the order of encrypted messages or replaying data twice. TLS uses encryption algorithms to ensure that data received over a public network ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
If it does, the relative part of the path is replaced with the absolute path set using the --log-bin option. Set to NONE to disable, or the name of the algorithm to be used for generating checksums; currently, only CRC32 checksums are supported, and ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
For statements that insert or ignore new rows, or that replace or modify existing rows, based on values in a PRIMARY KEY or UNIQUE index, MySQL treats invisible columns the same as visible columns: Invisible columns participate in key value ...An ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
The UPDATE statement uses any of the three functions JSON_SET(), JSON_REPLACE(), or JSON_REMOVE() to update the column. All changes replace existing array or object values with new ones, and do not add any new elements to the parent object or array.
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. If none of REPLACE, IGNORE, or ...