PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/subquery-materialization.html
oe [NOT] IN (SELECT ie ...) The predicate is IN or NOT IN and a result of UNKNOWN (NULL) has the same meaning as a result of FALSE. The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-file-io-type.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. These views summarize file I/O, grouped by host and event type. By default, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-file-io.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by descending total file I/O latency. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-stages.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by host and descending total latency. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-latency.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. The host_summary_by_statement_latency and x$host_summary_by_statement_latency ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-type.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. These views summarize informaion about statements executed, grouped by host ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. These views summarize statement activity, file I/O, and connections, grouped ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-lock-waits.html
This field reports NULL if the session that issued the blocking query becomes idle. These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-by-thread-by-latency.html
These views summarize I/O consumers to display time waiting for I/O, grouped by thread. The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns: user For foreground threads, the account associated with the thread.
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-host-by-current-bytes.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by descending amount of memory used. The ...