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/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/mysql-cluster-what-is-new.html
Beginning with this release, MySQL NDB Cluster is being developed in parallel with the standard MySQL 8.0 server under a new unified release model with the following features: NDB 8.0 is developed in, built from, and released with the MySQL 8.0 ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
However, it also has compatibility implications that may affect existing MySQL installations: Clients and connectors that have not been updated to know about caching_sha2_password may have trouble connecting to a MySQL 8.0 server configured with ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--safe-recover, -o Command-Line Format --safe-recover Do a repair using an old recovery method that reads through all rows in order and updates all index trees based on the rows found. --keys-used=val, -k val Command-Line Format --keys-used=val Type ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
To work around this issue, use the --result-file option, which creates the output in ASCII format: mysqldump [options] --result-file=dump.sql It is not recommended to load a dump file when GTIDs are enabled on the server (gtid_mode=ON), if your dump ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
As a safety measure, InnoDB prevents INSERT, UPDATE, or DELETE operations when innodb_force_recovery is greater than 0. innodb_strict_mode=ON also enables a row size check when creating or altering a table, to prevent INSERT or UPDATE from failing ...innodb_autoinc_lock_mode Command-Line Format --innodb-autoinc-lock-mode=# System Variable innodb_autoinc_lock_mode Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value 2 Valid Values 012 The lock mode to use for generating auto-increment ...
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/mysqlslap.html
--auto-generate-sql-load-type=type Command-Line Format --auto-generate-sql-load-type=type Type Enumeration Default Value mixed Valid Values readwritekeyupdatemixed Specify the test load type. The permissible values are read (scan tables), write ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html
Changing to Single-Primary Mode Use the group_replication_switch_to_single_primary_mode() function to change a group running in multi-primary mode to single-primary mode by issuing: SELECT group_replication_switch_to_single_primary_mode() When you ... This section explains how to change the mode which a group is running in, either single or ...If you do not ...
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 ...