Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-howto.html
Start the replica, then disable read-only mode on both servers, so that they can accept updates. To enable GTID-based replication, each server must be started with GTID mode enabled by setting the gtid_mode variable to ON, and with the ...For ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-verify-transactions.html
This is helpful when changing the replication mode online as you can verify that it is safe to change to GTID transactions. This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated.
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
The block_encryption_mode system variable controls the mode for block-based encryption algorithms. Its default value is aes-128-ecb, which signifies encryption using a key length of 128 bits and ECB mode. The optional init_vector argument is used to ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
You can disable most gap locks, including most next-key locks, by using --transaction-isolation=READ-COMMITTED or --innodb_locks_unsafe_for_binlog=1. Default frequency 06:00:00 Default auto-close enabled yes Binary Log Debug Information Disabled The ...However, for performance reasons, it is recommended to run 64-bit binaries on 64-bit platforms, and 32-bit binaries on 32-bit ...
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated Yes Type Enumeration Default Value OFF ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated Yes Type Enumeration Default Value OFF ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
For server side help, type 'help contents' If mysql is invoked with the --binary-mode option, all mysql commands are disabled except charset and delimiter in noninteractive mode (for input piped to mysql or loaded using the source command). mysql ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
Load Data Using Auto Parallel Load First, run Auto Parallel Load in dryrun mode to check for errors and warnings and to inspect the generated load script. For example: mysql> CALL sys.heatwave_load(JSON_ARRAY("tpch"), JSON_OBJECT("mode","normal")); ... You can load data into a MySQL HeatWave Cluster by using the Auto Parallel Load ...
https://dev.mysql.com/doc/refman/8.4/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. Each ...
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
Batch mode can also be useful while you're developing a query, particularly for multiple-line statements or multiple-statement sequences. The default output format is different (more concise) when you run mysql in batch mode than when you use it ...