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-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 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-reference.html
The sys schema includes tables and triggers, views, and stored procedures and functions.
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-usage.html
Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-views.html
The sys schema contains many views that summarize Performance Schema tables in various ways. Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-runtimes-in-95th-percentile.html
full_scan The total number of full table scans performed by occurrences of the statement. These views list statements with runtimes in the 95th percentile. The statements_with_runtimes_in_95th_percentile and ...