MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 101 to 107 of 107 total results

« Previous
9
10
11
Next »

19.1.6.1 Replication and Binary Logging Option and Variable Reference

https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html

binlog_row_value_options: Enables binary logging of partial JSON updates for row-based replication. The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the ...

16.6 Serialized Dictionary Information (SDI)

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

In addition to storing metadata about database objects in the data dictionary, MySQL stores it in serialized form. Other storage engines store SDI data in .sdi files that are created for a given table in the table's database directory. Serialized ...

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 *************************** ...

30.4.2.1 The sys_config Table

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

ps_thread_trx_info.max_length, @sys.ps_thread_trx_info.max_length The maximum length for JSON output produced by the ps_thread_trx_info() function. This table contains sys schema configuration options, one row per option. Configuration changes made ...

10.15.2 System Variables Controlling Tracing

https://dev.mysql.com/doc/refman/8.0/en/system-variables-controlling-tracing.html

end_markers_in_json: If set to 1, causes the trace to repeat the key (if present) near the closing bracket. This also affects the output of EXPLAIN FORMAT=JSON in those versions of MySQL which support this statement. The following system variables ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/8.0/en/user-variables.html

A value having the JSON data type is converted to a string with a character set of utf8mb4 and a collation of utf8mb4_bin. You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables ...

10.2.1.21 Window Function Optimization

https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html

To see windowing information, use EXPLAIN FORMAT=JSON and look for the windowing element. Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions.