MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 101 to 107 of 107 total results

« Previous
9
10
11
Next »

30.4.4.13 The ps_setup_reset_to_default() Procedure

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-reset-to-default.html

Parameters in_verbose BOOLEAN: Whether to display information about each setup stage during procedure execution. row *************************** status: Resetting: setup_actors DELETE FROM performance_schema.setup_actors WHERE NOT (HOST = '%' AND ...

30.4.5.16 The ps_thread_stack() Function

https://dev.mysql.com/doc/refman/9.7/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.4.24 The ps_truncate_all_tables() Procedure

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-truncate-all-tables.html

Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Example mysql> CALL ...

35.5.1 Configuring Log Telemetry

https://dev.mysql.com/doc/refman/9.7/en/telemetry-logs-configuration.html

Server Configuration System Variables Server Configuration Status Variables Server Configuration Command Line Server Configuration System Variables The following are the server telemetry logging system variables: telemetry.log_enabled System ...For ...

35.4.1 Configuring Metrics Telemetry

https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-configuration.html

Server Configuration telemetry.metrics_enabled System Variable telemetry.metrics_enabled Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value OFF Controls whether telemetry metrics are collected or not. This section lists the ...

5.3.4.6 Working with NULL Values

https://dev.mysql.com/doc/refman/9.7/en/working-with-null.html

The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL means false and anything else means true. This special ...

22.5.6.2 X Plugin Options and System Variables

https://dev.mysql.com/doc/refman/9.7/en/x-plugin-options-system-variables.html

mysqlx_enable_hello_notice Command-Line Format --mysqlx-enable-hello-notice[={OFF|ON}] System Variable mysqlx_enable_hello_notice Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON Controls messages sent to classic MySQL ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...