Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
16.6: Updating a table that contains a primary key that is either FLOAT or compound primary key that uses FLOAT fails to update the table and raises an exception. 16.6: Updating a table that contains a primary key that is either FLOAT or compound ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-config.html
(To obtain configuration data from the management node instead, simply omit this option.) --connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tls.html
To minimize the impact of certificate expiration on system availability, a cluster should have several certificates with staggered expiration dates; client certificates should expire earliest, followed by data node certificates, and then by ... This ...Note TLS for NDB Cluster on Linux requires compiled-in support for OpenSSL 1.1 or ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
Scenario 7: On the same system as described in Scenario 6, a command that performs analytics needs to be executed daily, using the most up-to-date data. A transaction cannot be on-hold forever, and if the time held exceeds wait_timeout it returns an ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...
https://dev.mysql.com/doc/refman/8.4/en/connection-compression-control.html
Because enabling compression decreases performance, its benefits occur primarily when there is low network bandwidth, network transfer time dominates the cost of compression and decompression operations, and result sets are large. To configure that ... Connections to the server can use compression on the traffic between client and server to reduce the number of bytes sent over the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-uri.html
Note If you are on MySQL 9.1.2 and earlier, you need to update dialect with the field delimiter and record delimiter parameters. As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files ...Review the following examples for different ways to create external ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
TIME Int Time-Millis Value is interpreted as milliseconds since midnight, and corresponds exactly to TIME (3). TIME Long Time-Micros Value is interpreted as milliseconds since midnight, and corresponds exactly to TIME (6). TIME String None DATETIME, ... Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
If a trigger uses a table and the table has changed since the trigger was loaded into the cache, the trigger operates using the outdated metadata. In addition—due to rounding, the nature of threaded applications, and the fact that a nonzero length ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-create.html
The time required to apply patches and updates may extend beyond the maintenance window and require a DB System restart. The default time to start an automatic backup is a time between 11:00 and 07:00 UTC, and will be the same time every day. Select ...The administrator password must be between 8 and 32 characters, and include at least one number, one uppercase letter, one lowercase letter, and one character from ,.-+*;:_!#%&/()=?>< Hardware ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
The I/O patterns for undo logs make undo tablespaces good candidates for SSD storage. The default 16KB page size is appropriate for a wide range of workloads, particularly for queries involving table scans and DML operations involving bulk updates.