Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-server-compatibility.html
To make it easier to load existing databases into the Service, the dump commands in MySQL Shell can detect potential issues and, in some cases, automatically adjust your schema definition to be compliant. Some issues found by the ocimds option may ... MySQL Server Compatibility 7.1.2 MySQL Server Compatibility MySQL HeatWave on AWS has several security-related restrictions that are not present in an on-premise instance of ...
https://dev.mysql.com/doc/connector-j/en/connector-j-client-authentication.html
Once you have the client private key and certificate files you want to use, you need to import them into a Java keystore so that they can be used by the Java SSL library and Connector/J. Import the client key and certificate into a Java keystore: $> ... The server may want to authenticate a client and require the client to provide an SSL certificate to it, which it verifies against its known certificate authorities or performs additional checks on the client identity if needed (see CREATE USER SSL/TLS Options for ...
https://dev.mysql.com/doc/connector-j/en/connector-j-server-authentication.html
This can be accomplished by either importing the certificate (ca.pem or any other certificate) into the Java default truststore (although tampering the default truststore is not recommended) or by importing it into a custom Java truststore file and ... Server authentication via server certificate verification is enabled when the Connector/J connection property sslMode is set to VERIFY_CA or ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
If B2 is a regular join buffer, each row r put into B2 is composed of the columns of a row r1 from B1 and the interesting columns of a matching row r2 from table t3. When these operations are executed with a join buffer, each row put into the buffer ... In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
With this function active, if the primary that is replicating goes offline or into an error state, the new primary starts replication on the same channel when it is elected. After loading the snapshot into the replica to synchronize it with the ...] ...
https://dev.mysql.com/doc/refman/8.4/en/charset-configuration.html
The MySQL server has a compiled-in default character set and collation. To change these defaults, use the --character-set-server and --collation-server options when you start the server. The collation must be a legal collation for the default ...
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature.html
Another method of verifying the integrity and authenticity of a package is to use cryptographic signatures. This is more reliable than using MD5 checksums, but requires more work. GnuPG is an Open Source alternative to the well-known Pretty Good ...
https://dev.mysql.com/doc/refman/8.4/en/component-loading.html
Components must be loaded into the server before they can be used. The SQL statements for component manipulation affect server operation and the mysql.component system table as follows: INSTALL COMPONENT loads components into the server. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
It resolves this issue as follows: Whenever the server reads the user table into memory, it sorts the rows. +-----------+----------+- When the server reads the table into memory, it sorts the rows using the rules just described. When you attempt to ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
mysql> SELECT TO_DAYS(950501); -> 728779 mysql> SELECT TO_DAYS('2007-10-07'); -> 733321 TO_DAYS() is not intended for use with values that precede the advent of the Gregorian calendar (1582), because it does not take into account the days that were ... This section describes the functions that can be used to manipulate temporal ...