MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 521 to 527 of 527 total results

« Previous
51
52
53
Next »

30.4.3.45 The user_summary_by_statement_latency and x$user_summary_by_statement_latency Views

https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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.42 TRUNCATE TABLE Statement

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

14.20.2 Window Function Concepts and Syntax

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

22.5.1 Checking X Plugin Installation

https://dev.mysql.com/doc/refman/9.7/en/x-plugin-checking-installation.html