PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-partitioning.html
Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the same structure, except where an exception is specifically allowed (see Section 19.5.1.9, “Replication with Differing Table ...Replication between tables that have different partitioning is generally not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-truncate.html
TRUNCATE TABLE is normally regarded as a DML statement, and so would be expected to be logged and replicated using row-based format when the binary logging mode is ROW or MIXED. TRUNCATE TABLE is treated for purposes of logging and replication as ...However this caused issues when logging or replicating, in STATEMENT or MIXED mode, tables that used transactional storage engines such as InnoDB when the transaction isolation level was READ COMMITTED or READ UNCOMMITTED, which precludes statement-based ...
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/sys-host-summary-by-statement-type.html
These views summarize information about statements executed, grouped by host and statement type. By default, rows are sorted by host and descending total latency. The host_summary_by_statement_type and x$host_summary_by_statement_type views have ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-type.html
These views summarize information about statements executed, grouped by user and statement type. By default, rows are sorted by user and descending total latency. The user_summary_by_statement_type and x$user_summary_by_statement_type views have ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/function-optimization.html
This UPDATE statement uses a nondeterministic function to select rows to be modified: UPDATE t SET col_a = some_expr WHERE id = FLOOR(1 + RAND() * 49); Presumably the intent is to update at most a single row for which the primary key matches the ...