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/outer-join-simplification.html
Table expressions in the FROM clause of a query are simplified in many cases. At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join operations. When the optimizer evaluates plans ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-progress-table.html
DATA_SPEED The current actual speed of data transfer, in bytes per second. NETWORK_SPEED The current speed of network transfer in bytes per second. Note The Performance Schema table described here is available as of MySQL 8.0.17. The clone_progress ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-query-profiling.html
Performance Schema displays event timer information in picoseconds (trillionths of a second) to normalize timing data to a standard unit. In the following example, TIMER_WAIT values are divided by 1000000000000 to show data in units of seconds. The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-table.html
REMAINING_DELAY If the replica is waiting for DESIRED_DELAY seconds to pass since the source applied a transaction, this field contains the number of delay seconds remaining. This table shows the current general transaction execution status on the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-configuration-table.html
(CHANGE REPLICATION SOURCE TO option: SOURCE_RETRY_COUNT, CHANGE MASTER TO option: MASTER_RETRY_COUNT) HEARTBEAT_INTERVAL The replication heartbeat interval on a replica, measured in seconds. This table shows the configuration parameters used by ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variables.html
performance_schema_max_digest_sample_age Command-Line Format --performance-schema-max-digest-sample-age=# System Variable performance_schema_max_digest_sample_age Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 60 Minimum ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...
https://dev.mysql.com/doc/refman/8.0/en/processlist-access.html
If a thread stays in a given state for many seconds, there might be a problem that needs to be investigated. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the ...
https://dev.mysql.com/doc/refman/8.0/en/query-attributes.html
The second SELECT shows that attributes do not persist across statements. The most visible part of an SQL statement is the text of the statement. As of MySQL 8.0.23, clients can also define query attributes that apply to the next statement sent to ...
https://dev.mysql.com/doc/refman/8.0/en/replica-io-thread-states.html
If the wait lasts for replica_net_timeout or slave_net_timeout seconds, a timeout occurs. The thread is sleeping for the number of seconds set by the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before ...