Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
If it opens in JavaScript (JS) mode, run the following command to switch to SQL execution mode. Start MySQL Shell and connect to the DB System endpoint: $> mysqlsh Username@DBSystem_IP_Address_or_Host_Name Note MySQL Shell opens in SQL execution ...
https://dev.mysql.com/doc/refman/8.4/en/expired-password-handling.html
If disconnect_on_expired_password is disabled, the server puts the client in sandbox mode. For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired password, the server either disconnects ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
The exception is if you use mysqld to initialize the data directory manually by invoking it with the --initialize or --initialize-insecure option, when binary logging is disabled by default, but can be enabled by specifying the --log-bin option. To ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
It uses Electronic Codebook (ECB) block encryption mode for tablespace key encryption and Cipher Block Chaining (CBC) block encryption mode for data encryption. When table_encryption_privilege_check is disabled (the default), the privilege check ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
The outcome of attempting to change the storage engine of a table is affected by whether the desired storage engine is available and the setting of the NO_ENGINE_SUBSTITUTION SQL mode, as described in Section 7.1.11, “Server SQL Modes”. To ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
This memory is not calculated unless global_connection_memory_tracking is enabled (disabled by default). If the value is greater than zero, it is not safe to shut down the replica; see Section 19.5.1.31, “Replication and Temporary Tables”. When ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-filtering.html
To enable or disable a consumer, set its ENABLED value to YES or NO. If you disable a consumer, the server does not spend time maintaining destinations for that consumer. For example, if you do not care about historical event information, disable ...
https://dev.mysql.com/doc/workbench/en/wb-preface.html
If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. If you are using a Commercial release of MySQL Workbench, ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-load-balancing-failover.html
When trying to balance workload between multiple servers, the driver has to determine when it is safe to swap servers, doing so in the middle of a transaction, for example, could cause problems. This allows you to identify a trigger statement that ... Connector/J provides a useful load-balancing implementation for MySQL Cluster or multi-source deployments, as explained in Section 3.8.3, “Configuring Load Balancing with Connector/J” and Support for Multiple-Source Replication ...
https://dev.mysql.com/doc/connectors/en/preface.html
If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. This manual describes the Connectors and APIs that can ...