Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-auto-sync.html
#!/user/bin/perl -w # file: reset-replica.pl # Copyright (c) 2005, 2020, Oracle and/or its affiliates. It is possible to automate much of the process described in the previous section (see Section 25.7.9, “NDB Cluster Backups With NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
Resetting a connection has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, and re-authentication is not done. For example: $> mysql --prompt="(\u@\h) [\d]> " (user@host) [database]> ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
Optimize the use of spin delay by user threads waiting for flushed redo. innodb_log_wait_for_flush_spin_hwm: Defines the maximum average log flush time beyond which user threads no longer spin while waiting for flushed redo. Consider the following ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Account passwords can be expired so that users must reset them. A user who has access to modify the plugin directory (the value of the plugin_dir system variable) or the my.cnf ... Database administrators should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Post-filtering is performed on a per-user basis because individual users select which of the available events are of interest. Reasons to use ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-configuration-table.html
(CHANGE REPLICATION SOURCE TO option: SOURCE_PORT) USER The user name of the replication user account used to connect to the source. (CHANGE REPLICATION SOURCE TO option: SOURCE_USER) NETWORK_INTERFACE The network interface that the replica is bound ... This table shows the configuration parameters used by the replica for connecting to the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
The same replication user account and password must exist on all the source servers in the source list for the channel. In this situation, the replication channel and the replication user account and password for the channel must be set up on all ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-command-line.html
You can stop the MySQL server by executing this command: C:\> "C:\Program Files\MySQL\MySQL Server 8.4\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, you need to invoke mysqladmin with the -p option and supply ... The MySQL server can be started manually from the command ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-configuration-file.html
The mcmd configuration file allows you to configure mcmd with its application options. A sample configuration file is provided with the MySQL Cluster Manager distribution at mcmd8.4.8/doc/sample_mcmd.conf. Edit the [mcmd] section of the file and ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-23.html
Old names have been deprecated—though they are still usable for now, they are to be removed eventually in future releases; users are therefore encouraged to switch to the new names. (WL #14207) Functionality Added or Changed Important Change: A ...