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/replication-features-variables.html
In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL versions. In statement-based replication, session variables are not replicated properly ...sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
If you are already running a replication solution and want to convert your existing tables to another engine type, follow these steps: Stop the replica from running replication updates: mysql> STOP SLAVE; Or from MySQL 8.0.22: mysql> STOP REPLICA; ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/which-version.html
When preparing to install MySQL, decide which version and distribution format (binary or source) to use. The naming scheme in MySQL 8.0 uses release names that consist of three numbers and an optional suffix (for example, mysql-8.0.34). Taken ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-rejoin.html
The auto-rejoin attempts and the time between them are called the auto-rejoin procedure. The group_replication_autorejoin_tries system variable, which is available from MySQL 8.0.16, makes a member that has been expelled or reached its unreachable ...Up to MySQL 8.0.20, the value of the system variable defaults to 0, so auto-rejoin is not activated by ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-table.html
For usage information, see Section 17.9.1.4, “Monitoring InnoDB Table Compression at Runtime” and Section 17.15.1.3, “Using the Compression Information Schema Tables”. The INNODB_CMP and INNODB_CMP_RESET tables provide status information on ...Pages are compressed whenever an empty page is created or the space for the uncompressed modification log runs ...
https://dev.mysql.com/doc/refman/8.0/en/help.html
The HELP statement searches the help tables for the given search string and displays the result of the search. The search string can contain the wildcard characters % and _. If X is less than or equal to 0.0E0, the function returns NULL and a ...
https://dev.mysql.com/doc/refman/8.0/en/changing-mysql-user.html
On Unix (or Linux for installations performed using tar.gz packages) , the MySQL server mysqld can be started and run by any user. If it does not, you must also follow those links and change the directories and files they point to. Another ... On ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-installation.html
This section describes how to install and configure the clone plugin. For remote cloning operations, the clone plugin must be installed on the donor and recipient MySQL server instances. For general information about installing or uninstalling ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-limitations.html
For example, you cannot clone between MySQL 8.0 and MySQL 8.4, but can clone within a series such as MySQL 8.0.37 and MySQL 8.0.42. Before 8.0.37, the point release number also had to match, so cloning the likes of 8.0.36 to 8.0.42 or vice-versa is ... The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-foreign-key.html
MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. MATCH FULL, MATCH PARTIAL, and MATCH SIMPLE are allowed, but their use should be avoided, as they cause the MySQL Server to ignore any ON ...