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-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/5.7/en/sys-schema-reference.html
The sys schema includes tables and triggers, views, and stored procedures and functions.
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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/5.7/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/5.7/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.
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config-update-set-user.html
The sys_config_update_set_user trigger for the sys_config table is similar to the sys_config_insert_set_user trigger, but for UPDATE statements.
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io-type.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. These views summarize file I/O, grouped by user and event type. By default, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io.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 total file I/O latency. The ...