PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
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-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. row *************************** thread_stack: {"rankdir": "LR","nodesep": "0.10", "stack_created": "2014-02-19 13:39:03", "mysql_version": ... Returns a JSON ...
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-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 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-sorting.html
sorts_using_scans The total number of sorts using table scans by occurrences of the statement. The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. db The default database for the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config-insert-set-user.html
For rows added to the sys_config table by INSERT statements, the sys_config_insert_set_user trigger sets the set_by column to the current user.