Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
Be aware that a remote cloning operation removes user-created tablespaces and data from the joining member before transferring the data from the donor. The default setting for the group_replication_clone_threshold Group Replication system variable ... If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-virtual-table.html
The value is large because it encodes the column sequence number and ordinal position. CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-logging.html
Then use either of the following techniques to prevent it from being created again: Set the MYSQL_HISTFILE environment variable to /dev/null. Create .mysql_history as a symbolic link to /dev/null; this need be done only once: ln -s /dev/null ... The ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-multi.html
If the servers that you want to manage have different user names or passwords for the administrative accounts, you might want to create an account on each server that has the same user name and password. For example, you might set up a common ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-user.html
MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. By default, this file is named .mysql_history and is created in your home directory. Passwords can be written as plain text in SQL ... MySQL users should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
Suppose that an administrator has created the following role to confer the ability to set restricted session system variables: CREATE ROLE set_session_sysvars; GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO set_session_sysvars; Any user granted the ...(For ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.encrypted-binlog-relaylog.html
mysqlbackup creates a manifest file and the configuration file component_keyring_file.cnf (which contains the password used with the --encrypt-password option during the restore) on the restored server, so that the server will load ... MySQL ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-19.html
When using connection pooling, Connector/J keeps track of any host it failed to connect to and, for a short waiting period after the failure, avoids connecting to it during the creation or retrieval of a Session. Version 8.0.19 is the latest ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster-upgrade-troubleshoot.html
For example, suppose a cluster was created using the following sequence of commands: mysql-js> \c clusterAdmin@localhost:3306 mysql-js> dba.createCluster("myCluster") Therefore the hostname value stored in the metadata is “localhost” and for ...