PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/en/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-statement-avg-latency-histogram.html
Displays a textual histogram graph of the average latency values across all normalized statements tracked within the Performance Schema events_statements_summary_by_digest table. This procedure can be used to display a very high-level picture of ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-account.html
The value should match the THREAD_ID column from some Performance Schema threads table row. Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. Parameters in_thread_id BIGINT UNSIGNED: The ...
https://dev.mysql.com/doc/refman/8.0/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. Note As of MySQL 8.0.16, ps_thread_id() is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-stack.html
The value should match the THREAD_ID column from some Performance Schema threads table row. Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ID. row *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-overview.html
object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, PROCEDURE, TRIGGER, VIEW. This view summarizes the types of objects within each schema. Note For MySQL instances with a large number of objects, this view might take a ...