MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 511 to 520 of 521 total results

30.4.3.40 The statements_with_temp_tables and x$statements_with_temp_tables Views

https://dev.mysql.com/doc/refman/8.0/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 ...

30.4.3.43 The user_summary_by_file_io_type and x$user_summary_by_file_io_type Views

https://dev.mysql.com/doc/refman/8.0/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, ...

30.4.3.42 The user_summary_by_file_io and x$user_summary_by_file_io Views

https://dev.mysql.com/doc/refman/8.0/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 ...

30.4.3.44 The user_summary_by_stages and x$user_summary_by_stages Views

https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-stages.html

30.4.3.45 The user_summary_by_statement_latency and x$user_summary_by_statement_latency Views

https://dev.mysql.com/doc/refman/8.0/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 ...

30.4.3.46 The user_summary_by_statement_type and x$user_summary_by_statement_type Views

https://dev.mysql.com/doc/refman/8.0/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 ...

30.4.3.41 The user_summary and x$user_summary Views

https://dev.mysql.com/doc/refman/8.0/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 ...

15.1.37 TRUNCATE TABLE Statement

https://dev.mysql.com/doc/refman/8.0/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 ...

15.2.19 VALUES Statement

https://dev.mysql.com/doc/refman/8.0/en/values.html

ROW() cannot be empty (but each of the supplied scalar values can be NULL). VALUES is a DML statement introduced in MySQL 8.0.19 which returns a set of one or more rows as a table. In other words, it is a table value constructor which also ...

14.20.2 Window Function Concepts and Syntax

https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html

NULL values sort first for ascending sorts, last for descending sorts. However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation ...

Displaying 511 to 520 of 521 total results