Search Results
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-thread-trx-info.html
Configuration Options ps_thread_trx_info() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 30.4.2.1, “The sys_config Table”): ps_thread_trx_info.max_length, ...
https://dev.mysql.com/doc/refman/9.7/en/table.html
With INTO to populate user variables, and with INTO OUTFILE or INTO DUMPFILE to write table data to a file. TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/exec-option.html
To delay any redirection or variable substitution until the command is executed, enclose the entire option value within single quotes. The --exec-when-locked option of mysqlbackup lets you specify a command (together with the desired command ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/configuring-automatic-rejoin-of-instances.html
Instances running MySQL version 8.0.12 and later have the group_replication_exit_state_action variable, which you can configure using the AdminAPI exitStateAction option. If exitStateAction is set to ABORT_SERVER then in the event of leaving the ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-dba-upgrade-metadata.html
As AdminAPI evolves, some releases might require you to upgrade the metadata of existing ClusterSets, ReplicaSets, and Clusters to ensure they are compatible with newer versions of MySQL Shell. For example, the addition of InnoDB ReplicaSet in ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-extension-objects-persist.html
The user configuration path can be overridden on all platforms by defining the environment variable MYSQLSH_USER_CONFIG_HOME. A script to define and register extension objects must have a file extension of .js for JavaScript code, or .py for Python ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-json-integration.html
To activate the JSON shell mode, define the MYSQLSH_JSON_SHELL environment variable. You can activate a JSON shell mode to help with integration of MySQL Shell with other applications that could use its functionality. In this mode, MySQL Shell ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-reporting-builtin-query.html
For example, the following command uses the query report to display the statement counter variables and refresh the results every 0.5 seconds: \watch query --interval=0.5 show global status like 'Com%' . The built-in MySQL Shell report query ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-reporting-create-saving.html
The user configuration path can be overridden on all platforms by defining the environment variable MYSQLSH_USER_CONFIG_HOME. A MySQL Shell report must be saved with a file extension of .js for JavaScript code, or .py for Python code, to match the ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-working-with-history.html
This path can be overridden on all platforms by defining the environment variable MYSQLSH_USER_CONFIG_HOME. Code which you issue in MySQL Shell is stored in the history, which can then be accessed using the up and down arrow keys. You can also ...