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-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 ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-id.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 the Performance Schema thread ID assigned to a given connection ID, or the thread ID for the ...
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-schema-table-lock-waits.html
The schema_table_lock_waits and x$schema_table_lock_waits views have these columns: object_schema The schema containing the object to be locked. These views display which sessions are blocked waiting on metadata locks, and what is blocking them.
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io-type.html
The user_summary_by_file_io_type and x$user_summary_by_file_io_type 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 and ... These views summarize file I/O, grouped by user and event ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io.html
The user_summary_by_file_io and x$user_summary_by_file_io 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 and are ...By ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-stages.html
The user_summary_by_stages and x$user_summary_by_stages 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 and are reported ...By default, rows are sorted by user and descending total stage ...