MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 491 to 500 of 506 total results

https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html

If the slow query log is enabled and FILE is selected as an output destination, each statement written to the log is preceded by a line that begins with a # character and has these fields (with all fields on a single line): Query_time: duration The ...To specify the log destination, use the log_output system variable (as described in Section 7.4.1, “Selecting General Query Log and Slow Query Log Output ... The ...

5.3.4.4 Sorting Rows

https://dev.mysql.com/doc/refman/8.0/en/sorting-rows.html

You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...

14.16.11 Spatial GeoJSON Functions

https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html

This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...

15.6.2 Statement Labels

https://dev.mysql.com/doc/refman/8.0/en/statement-labels.html

[begin_label:] BEGIN [statement_list] END [end_label] [begin_label:] LOOP statement_list END LOOP [end_label] [begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] [begin_label:] WHILE search_condition DO statement_list ...

27.7 Stored Program Binary Logging

https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html

Triggers are similar to stored functions, so the preceding remarks regarding functions also apply to triggers with the following exception: CREATE TRIGGER does not have an optional DETERMINISTIC characteristic, so triggers are assumed to be always ... The binary log contains information about SQL statements that modify database ...

30.4.4.3 The execute_prepared_stmt() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-execute-prepared-stmt.html

Parameters in_query LONGTEXT CHARACTER SET utf8mb3: The statement string to execute. Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is deallocated after execution, so it is not subject to reuse.

30.4.5.4 The format_path() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-format-path.html

Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir slave_load_tmpdir or replica_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir ...

30.4.5.5 The format_statement() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-format-statement.html

Example By default, format_statement() truncates statements to be no more than 64 characters. Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns ...

30.4.4.21 The ps_statement_avg_latency_histogram() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-statement-avg-latency-histogram.html

For example, * = 2 units in the histogram legend means that each * character represents 2 statements. Displays a textual histogram graph of the average latency values across all normalized statements tracked within the Performance Schema ...

30.4.5.16 The ps_thread_stack() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-stack.html

Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ID. The value should match the THREAD_ID column from some Performance Schema threads table row. row *************************** ...

Displaying 491 to 500 of 506 total results