MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 551 to 560 of 562 total results

30.4.3.39 The statements_with_sorting and x$statements_with_sorting Views

https://dev.mysql.com/doc/refman/9.7/en/sys-statements-with-sorting.html

The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. db The default database for the statement, or NULL if there is none. total_latency The total wait time of timed occurrences of ...

30.4.3.40 The statements_with_temp_tables and x$statements_with_temp_tables Views

https://dev.mysql.com/doc/refman/9.7/en/sys-statements-with-temp-tables.html

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 in-memory temporary tables used. The statements_with_temp_tables and ...

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/9.7/en/sys-user-summary-by-file-io-type.html

These views summarize file I/O, grouped by user and event type. By default, rows are sorted by user and descending total latency. The user_summary_by_file_io_type and x$user_summary_by_file_io_type views have these columns: user The client user ...

30.4.3.42 The user_summary_by_file_io and x$user_summary_by_file_io Views

https://dev.mysql.com/doc/refman/9.7/en/sys-user-summary-by-file-io.html

By default, rows are sorted by descending total file I/O latency. The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema ...

30.4.3.44 The user_summary_by_stages and x$user_summary_by_stages Views

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

By default, rows are sorted by user and descending total stage latency. The user_summary_by_stages and x$user_summary_by_stages views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema ...

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

The user_summary_by_statement_latency and x$user_summary_by_statement_latency views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background ...

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

These views summarize information about statements executed, grouped by user and statement type. By default, rows are sorted by user and descending total latency. The user_summary_by_statement_type and x$user_summary_by_statement_type views have ...

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

These views summarize statement activity, file I/O, and connections, grouped by user. The user_summary and x$user_summary views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table ...

15.1.42 TRUNCATE TABLE Statement

https://dev.mysql.com/doc/refman/9.7/en/truncate-table.html

Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting data. Thus, it does not cause ...

15.2.19 VALUES Statement

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

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 statement. VALUES row_constructor_list [ORDER BY column_designator] [LIMIT ...

Displaying 551 to 560 of 562 total results