Search Results
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-temp-tables.html
db The default database for the statement, or NULL if there is none. These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-stages.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 user and descending total stage latency. The ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-latency.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. The user_summary_by_statement_latency and x$user_summary_by_statement_latency ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-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 information about statements executed, grouped by user ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary.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 statement activity, file I/O, and connections, grouped ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
TRUNCATE TABLE can be used with Performance Schema summary tables, but the effect is to reset the summary columns to 0 or NULL, not to remove rows. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of ...
https://dev.mysql.com/doc/refman/8.4/en/values.html
ROW() cannot be empty (but each of the supplied scalar values can be NULL). VALUES is a DML statement which returns a set of one or more rows as a table. In other words, it is a table value constructor which also functions as a standalone SQL ...