PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-memory-by-host-by-current-bytes.html
Rows for which the HOST 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-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-thread-id.html
See Section 14.21, “Performance Schema Functions” Returns the Performance Schema thread ID assigned to a given connection ID, or the thread ID for the current connection if the connection ID is NULL. Note As of MySQL 8.0.16, ps_thread_id() is ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-statement-digest.html
Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/sys-statement-analysis.html
db The default database for the statement, or NULL if there is none. The statement_analysis and x$statement_analysis views have these columns: query The normalized statement string. full_scan The total number of full table scans performed by ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-errors-or-warnings.html
db The default database for the statement, or NULL if there is none. These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-full-table-scans.html
db The default database for the statement, or NULL if there is none. These views display normalized statements that have done full table scans. By default, rows are sorted by descending percentage of time a full scan was done and descending total ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-runtimes-in-95th-percentile.html
db The default database for the statement, or NULL if there is none. These views list statements with runtimes in the 95th percentile. The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile views have ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-sorting.html
db The default database for the statement, or NULL if there is none. The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. total_latency The total wait time of timed occurrences of ...