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-errors.html
For example, you might need to create a nonexistent table before you can start the replica again. For nontransactional storage engines such as MyISAM, it is possible to have a statement that only partially updates a table and returns an error code.
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. An alternative is to use the ... Certain ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-concepts.html
When using GTIDs you can take advantage of GTID auto-positioning and automatic failover, and use WAIT_FOR_EXECUTED_GTID_SET(), session_track_gtids, and Performance Schema tables to monitor replicated transactions (see Section 29.12.11, ... Before ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
The REQUIRE_TABLE_PRIMARY_KEY_CHECK option (available from MySQL 8.0.20) makes the replication channel use its own policy for primary key checks. When PRIVILEGE_CHECKS_USER is set, setting REQUIRE_TABLE_PRIMARY_KEY_CHECK to either ON or OFF means ...
https://dev.mysql.com/doc/refman/8.0/en/scalar-subqueries.html
In MySQL 8.0.19 and later, the preceding query can also be written like this, using TABLE: SELECT (TABLE t2) FROM t1; A scalar subquery can be part of an expression, but remember the parentheses, even if the subquery is an operand that provides an ... In its simplest form, a subquery is a scalar subquery that returns a single ...
https://dev.mysql.com/doc/refman/8.0/en/server-side-help-support.html
This information is stored in several tables in the mysql schema (see Section 7.3, “The mysql System Schema”). Proper operation of the HELP statement requires that these help tables be initialized. For a new installation of MySQL using a binary ... MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP ...
https://dev.mysql.com/doc/refman/8.0/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. By ...It ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
This makes PERSIST_ONLY suitable for configuring read-only system variables that can be set only at server startup. The Performance Schema variables_info table contains information showing when and by which user each system variable was most ...
https://dev.mysql.com/doc/refman/8.0/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 29.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html
A standard installation of MySQL using the RPM packages result in files and resources created under the system directories, shown in the following table. The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM ...