PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/subquery-materialization.html
The first time MySQL needs the subquery result, it materializes that result into a temporary table. Any subsequent time the result is needed, MySQL refers again to the temporary table. If materialization is not used, the optimizer sometimes rewrites ... The optimizer uses materialization to enable more efficient subquery ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-restrictions.html
FROM t...) AS dt ...); Here the result from the derived table is materialized as a temporary table, so the relevant rows in t have already been selected by the time the update to t takes place. In MySQL, it can produce nondeterministic results ...
https://dev.mysql.com/doc/refman/9.7/en/sys-diagnostics.html
Parameters in_max_runtime INT UNSIGNED: The maximum data collection time in seconds. in_interval INT UNSIGNED: The sleep time between data collections in seconds. Creates a report of the current server status for diagnostic purposes. This procedure ...
https://dev.mysql.com/doc/refman/9.7/en/sys-host-summary-by-file-io.html
io_latency The total wait time of timed file I/O events for the host. By default, rows are sorted by descending total file I/O latency. The host_summary_by_file_io and x$host_summary_by_file_io views have these columns: host The host from which the ...
https://dev.mysql.com/doc/refman/9.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/9.7/en/sys-user-summary-by-file-io.html
io_latency The total wait time of timed file I/O events for the user. By default, rows are sorted by descending total file I/O latency. The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name.
https://dev.mysql.com/doc/refman/9.7/en/telemetry-logs-configuration.html
telemetry.otel_exporter_otlp_logs_timeout System Variable telemetry.otel_exporter_otlp_logs_timeout Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value 10000 Unit milliseconds Time in milliseconds the OTLP exporter waits for ...For information on the configured loggers, see Section 29.12.21.1, “The setup_loggers ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-trace-format.html
This span type has the following attributes: Name: stmt mysql.event_name mysql.lock_time mysql.sql_text mysql.digest_text mysql.current_schema mysql.object_type mysql.object_schema mysql.object_name mysql.sql_errno mysql.sqlstate mysql.message_text ...The following span types are emitted by the telemetry component: Control Span Session Span Statement Span Control Span Issued when the telemetry configuration changes, notifying downstream system of which signal collection has been enabled or ...
https://dev.mysql.com/doc/refman/9.7/en/thread-information.html
row *************************** Id: 5 User: event_scheduler Host: localhost db: NULL Command: Daemon Time: 2756681 State: Waiting on empty queue Info: NULL *************************** 2. row *************************** Id: 20 User: me Host: ... To ...
https://dev.mysql.com/doc/refman/9.7/en/update.html
Each matching row is updated once, even if it matches the conditions multiple times. The implicit default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. UPDATE is a DML ...