PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-latency.html
The host_summary_by_statement_latency and x$host_summary_by_statement_latency views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to ...total_latency The total wait time of timed statements for the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-type.html
The host_summary_by_statement_type and x$host_summary_by_statement_type views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for ... These views summarize informaion about statements executed, grouped by host and statement ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary.html
The host_summary and x$host_summary views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported ... These views summarize statement activity, file I/O, and connections, grouped by ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-lock-waits.html
The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. These views summarize the InnoDB locks that transactions are waiting for. wait_age How long the lock has been waited for, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-host-by-current-bytes.html
The memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-user-by-current-bytes.html
The memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads ...By default, rows are sorted by descending amount of memory ...
https://dev.mysql.com/doc/refman/5.7/en/sys-processlist.html
The processlist and x$processlist views have these columns: thd_id The thread ID. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. They provide more complete information ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-thread-instrumented.html
This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Returns YES or NO to indicate whether Performance Schema instrumentation for a given connection ID ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-disable-thread.html
This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Given a connection ID, disables Performance Schema instrumentation for the thread. Example Disable a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-enable-thread.html
This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Given a connection ID, enables Performance Schema instrumentation for the thread. Example Enable a ...