PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-user-by-current-bytes.html
Rows for which the USER 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 ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-id.html
Returns the Performance Schema thread ID assigned to a given connection ID, or the thread ID for the current connection if the connection ID is NULL. Parameters in_connection_id BIGINT UNSIGNED: The ID of the connection for which to return the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html
Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-progress-reporting.html
The following sys schema views provide progress reporting for long-running transactions: processlist session x$processlist x$session Assuming that the required instruments and consumers are enabled, the progress column of these views shows the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io-type.html
Rows for which the USER 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 user and event type. By default, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io.html
Rows for which the USER 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 ...