PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT NAME, ENABLED, TIMED FROM ...If you disable a consumer, ... Events are processed in a producer/consumer fashion: Instrumented code is the source for events and produces events to be ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/federated-description.html
To read a result set, it uses mysql_store_result() and fetches rows one at a time using mysql_fetch_row(). A FEDERATED table consists of two elements: A remote server with a database table, which in turn consists of the table definition (stored in ... When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-message-compression.html
From MySQL 8.0.18, you can also configure compression for messages sent for distributed recovery by the method of state transfer from a donor's binary log. Binary log transaction compression (available as of MySQL 8.0.20), which is activated by the ... For messages sent between online group members, Group Replication enables message compression by ...