PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
User credentials set using CHANGE REPLICATION SOURCE TO | CHANGE MASTER TO are stored in plain text in the replication metadata repositories on the server, but user credentials specified on START GROUP_REPLICATION are saved in memory only, and are ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrade.html
Choosing between an in-place or logical upgrade depends on the amount of data stored in the group. Group Replication includes compatibility policies that enable you to safely combine members running different versions of MySQL in the same group ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html
For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the INFO value shows the SELECT statement. Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL release.
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Note InnoDB does not support databases that are restored using third-party backup tools. Use the following ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html
To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server startup. The percentage of recently used pages that is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
In MySQL 8.0, InnoDB stores metadata in the MySQL data dictionary. If you encounter this error, restore the previous innodb_data_file_path setting, and refer to the system tablespace resizing instructions. The only option to achieve a smaller system ... The system tablespace is the storage area for the change ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
A password for the superuser is set and stored in the error log file. For more information on the postinstallation procedures, see Section 2.9, “Postinstallation Setup and Testing”. Before You Start As a popular, open-source software, MySQL, in ...
https://dev.mysql.com/doc/refman/8.0/en/loop.html
Within a stored function, RETURN can also be used, which exits the function entirely. Example: CREATE PROCEDURE doiterate(p1 INT) BEGIN label1: LOOP SET p1 = p1 + 1; IF p1 < 10 THEN ITERATE label1; END IF; LEAVE label1; END LOOP label1; SET @x = p1; ... [begin_label:] LOOP statement_list END LOOP [end_label] LOOP implements a simple loop construct, enabling repeated execution of the statement list, which consists of one or more statements, each terminated by a semicolon (;) statement ...
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...