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-table.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. If the NO_ZERO_DATE or NO_ZERO_IN_DATE SQL mode is ...| ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
enforce_gtid_consistency: Prevents execution of statements that cannot be logged in transactionally safe manner. gtid_mode: Controls whether GTID based logging is enabled and what type of transactions logs can contain. relay_log_recovery: Whether ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
MySQL implements regular expression support using International Components for Unicode (ICU), which provides full Unicode support and is multibyte safe. (Prior to MySQL 8.0.4, MySQL used Henry Spencer's implementation of regular expressions, which ...This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
binlog_row_value_options: Enables binary logging of partial JSON updates for row-based replication. binlog_transaction_dependency_history_size: Number of row hashes kept for looking up transaction that last updated some row. Options and Variables ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
In multi-primary mode (group_replication_single_primary_mode=OFF) no member has a special role. Any member that is compatible with the other group members is set to read/write mode when joining the group, and can process write transactions, even if ...Group Replication does not handle client-side failover itself, so you need to arrange this using a middleware framework such as MySQL Router 8.0, a proxy, a connector, or the application ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-repair.html
Stage 2: Easy safe repair First, try myisamchk -r -q tbl_name (-r -q means “quick recovery mode”). Safe recovery mode uses an old recovery method that handles a few cases that regular recovery mode does not (but is slower). If the mysqld server ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
Partial Updates of JSON Values In MySQL 8.0, the optimizer can perform a partial, in-place update of a JSON column instead of removing the old document and writing the new document in its entirety to the column. This optimization can be performed ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For other types, inverse aggregation is safe; this includes DECIMAL, which permits a fractional part but is an exact-value type. For faster execution, MySQL always uses inverse aggregation when it is safe: For floating-point values, inverse ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
--ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated 8.0.34 Type Enumeration Default Value OFF Valid Values OFFONSTRICT Controls whether to enable FIPS mode on the client side. The --ssl-fips-mode option ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filter-definitions.html
SELECT (for table referenced in REPLACE clause LOAD DATA LOAD XML update event: UPDATE UPDATE ... WHERE (for tables referenced in UPDATE clause) Blocking Execution of Specific Events event items can include an abort item that indicates whether to ...