MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 751 to 760 of 769 total results

30.4.3.36 The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings Views

https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-errors-or-warnings.html

These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these ...

30.4.3.37 The statements_with_full_table_scans and x$statements_with_full_table_scans Views

https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-full-table-scans.html

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 latency. The statements_with_full_table_scans and ...

30.4.3.38 The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile Views

https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-runtimes-in-95th-percentile.html

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 these columns: query The normalized statement string. db The default ...

30.4.3.39 The statements_with_sorting and x$statements_with_sorting Views

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

10.2.1.23 Avoiding Full Table Scans

https://dev.mysql.com/doc/refman/8.0/en/table-scan-avoidance.html

The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a ...

B.3.3.5 Where MySQL Stores Temporary Files

https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html

Some SELECT queries creates temporary SQL tables to hold intermediate results. On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which to store temporary files. If TMPDIR is not set, MySQL uses ...

10.14 Examining Server Thread (Process) Information

https://dev.mysql.com/doc/refman/8.0/en/thread-information.html

To ascertain what your MySQL server is doing, it can be helpful to examine the process list, which indicates the operations currently being performed by the set of threads executing within the server. row *************************** Id: 5 User: ...

10.15.11 Trace General Structure

https://dev.mysql.com/doc/refman/8.0/en/trace-general-structure.html

A trace follows the actual execution path very closely; for each join, there is a join preparation object, a join optimization object, and a join execution object. Query transformations (IN to EXISTS, outer join to inner join, and so on), ...

27.3.2 Trigger Metadata

https://dev.mysql.com/doc/refman/8.0/en/trigger-metadata.html

To obtain metadata about triggers: Query the TRIGGERS table of the INFORMATION_SCHEMA database.

Displaying 751 to 760 of 769 total results