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-semisync-interface.html
To check the current values of the status variables for semisynchronous replication, use SHOW VARIABLES: mysql> SHOW VARIABLES LIKE 'rpl_semi_sync%'; Beginning with MySQL 8.0.26, new versions of the source and replica plugins are supplied, which ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync.html
In addition to the built-in asynchronous replication, MySQL 8.0 supports an interface to semisynchronous replication that is implemented by plugins. Fully synchronous replication means failover from the source to any replica is possible at any time. The amount of slowdown is at least the TCP/IP roundtrip time to send the commit to the replica and wait for the acknowledgment of receipt by the ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
Each matching row is updated once, even if it matches the conditions multiple times. If you set a column to the value it currently has, MySQL notices this and does not update it. The implicit default value is 0 for numeric types, the empty string ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
(Bug #28086) When one of the tables involved is a log table in the mysql database. The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset ...
https://dev.mysql.com/doc/refman/8.0/en/charset-examples.html
The following examples show how MySQL determines default character set and collation values. Example 2: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 ) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci; This ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
If the column c were nullable (that is, defined only as TINYINT UNSIGNED) the query would be rewritten like this: SELECT * FROM t WHERE ti IS NOT NULL Folding is performed for constants compared to supported MySQL column types as follows: Integer ...
https://dev.mysql.com/doc/refman/8.0/en/correlated-subqueries.html
So, MySQL looks outside the subquery, and finds t1 in the outer query. Beginning with MySQL 8.0.24, the optimizer can transform a correlated scalar subquery to a derived table when the subquery_to_derived flag of the optimizer_switch variable is ...
https://dev.mysql.com/doc/refman/8.0/en/corrupted-myisam-tables.html
Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur: The mysqld process is killed ...An unexpected computer shutdown occurs (for example, the computer is turned ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
If the expression evaluates to a data type that differs from the declared column type, implicit coercion to the declared type occurs according to the usual MySQL type-conversion rules. If a generated column uses the TIMESTAMP data type, the setting ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-components-vs-plugin.html
Prior to 8.0.33, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure in MySQL 8.0.33. The following table briefly compares MySQL Enterprise Data Masking and ...It ...