Search Results
https://dev.mysql.com/doc/refman/9.7/en/set-variable.html
| @@] system_var_name } SET syntax for variable assignment enables you to assign values to different types of variables that affect the operation of the server or clients: User-defined variables. System variables also can be set at server startup, ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/9.7/en/validate-password-options-variables.html
This section describes the system and status variables that validate_password provides to enable its operation to be configured and monitored. validate_password.check_user_name Command-Line Format --validate-password.check-user-name[={OFF|ON}] ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-binary-log.html
For additional information about using MySQL server options and system variables, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”. When binary logging is enabled, the log_bin system variable, which ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/9.7/en/show-variables.html
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL system variables (see Section 7.1.8, “Server System Variables”). The scope for each system variable is listed at Section 7.1.8, “Server ...System variable information is also available from these sources: Performance Schema ...A WHERE clause can be given to select rows using ...
https://dev.mysql.com/doc/refman/9.7/en/mle-component-options-variables.html
For a summary table that lists all system variables supported by the MySQL server, see Section 7.1.5, “Server System Variable Reference”. The following table lists all MySQL system variables and status variables supported by the ML component.
https://dev.mysql.com/doc/refman/9.7/en/programs-server.html
This section describes mysqld, the MySQL server, and several programs that are used to start the server.
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-status-variable-tables.html
The MySQL server maintains many status variables that provide information about its operation (see Section 7.1.10, “Server Status Variables”). If the performance_schema_max_thread_instances system variable is not autoscaled (signified by a ...
https://dev.mysql.com/doc/mysqld-version-reference/en/options-variables.html
The following table shows all the options and variables available in MySQL Server. Dyn: Whether the item is dynamically settable while the server is running. Whether the item is available in the corresponding MySQL Server release series. Intr: The ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-variables.html
The default_storage_engine system variable is not replicated, regardless of the logging mode; this is intended to facilitate replication between different storage engines. To help reduce possible confusion, we recommend that you always use the same ...However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the full mode value, including NO_DIR_IN_CREATE, is passed to the receiving ...sql_mode is also ...
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-status-variables.html
option_tracker_usage:MySQL Server This status variable is reset to 0 whenever the MySQL server is restarted. The Option Tracker component supplies a number of status variables, which are described in this section. option_tracker_usage:Enterprise ...