PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... It can take the following forms: mysql_error_code: ...HANDLER statement specifies a handler that deals with one or more ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
The UNDO keyword, introduced in MySQL 8.0.14, must be specified to drop an undo tablespace. mysql> CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' Engine=InnoDB; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) TABLESPACE ts1 Engine=InnoDB; mysql> DROP ...
https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html
The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a schedule. The following discussion covers the Event Scheduler and is divided into the following sections: Section 27.4.1, “Event ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html
In a MySQL source distribution, you can find this list in the storage/myisam/ft_static.c file. The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
MySQL supports built-in (native) functions, loadable functions, and stored functions. The following list names the functions in MySQL 8.0 that are affected by the IGNORE_SPACE setting and listed as special in the sql/lex.h source file. ADDDATE ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html
If any member is running a MySQL Server version between MySQL 8.0.13 and MySQL 8.0.16, this safeguard is not enforced for the group and you can specify any new primary member, but it is recommended to select a primary that is running the lowest ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-methods.html
The primary cannot remain as the primary unless it is running the lowest MySQL Server version in the group. The group elects a new primary whenever necessary from among the members running the lowest MySQL Server version, following the election ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. To enable read-only mode for an entire MySQL instance, specify the following configuration ...How to Enable To prepare an instance for read-only operation, make sure all the necessary information is flushed to the data files before storing it on the read-only ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-support.html
Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over IPv6. For example, this command connects over IPv6 to the MySQL server on the local host: $> mysql -h ::1 To use this ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html
Each MySQL Instance on a machine should have its own data directory. Permitting multiple MySQL servers to access a common data directory over NFS is a very bad idea. Create a New Data Directory With this method, the data directory is in the same ...