Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-known-issues-limitations.html
The following are some known issues and limitations for MySQL Connector/J: When Connector/J retrieves timestamps for a daylight saving time (DST) switch day using the getTimeStamp() method on the result set, some of the returned values might be ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
So, if some other query happens on the same connection, the value is overwritten. On the other hand, the getGeneratedKeys() method is scoped by the Statement instance, so it can be used even if other queries happen on the same connection, but not on ... getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-sql-modes.html
Using the statement SET [GLOBAL|SESSION] sql_mode='modes', you can change the settings from within a connection, either locally to the connection, or to take effect globally. Is the mode dependent on the database or connection? A mode is not linked ...What is the default server SQL mode when MySQL 8.4 is installed? ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
Create the table on the local server with an identical table definition, but adding the connection information that links the local table to the remote table. You can either create the local table and specify the connection string (containing the ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
When using a CONNECTION string, you cannot use an '@' character in the password. You can get round this limitation by using the CREATE SERVER statement to create a server connection. The following items indicate features that the FEDERATED storage ...
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
FIPS mode also applies to attempts by clients to connect to the server. FIPS mode also applies to attempts by clients to connect to the server. However, enabling FIPS mode does not require that an encrypted connection must be used, or that user ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-servers.html
To see the values used by a given instance, connect to it and execute a SHOW VARIABLES statement. In addition to using different data directories, several other options must have different values for each server instance: --port=port_num --port ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
The send buffer reserved size is calculated in two steps: Use the value of the TotalSendBufferMemory configuration parameter (no default value) or the sum of the individual send buffers used by all individual connections to the data node. A data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-initial-start.html
(For more information, see Section 25.3.2.4, “Installing NDB Cluster Processes as Windows Services”.) Do not start the SQL node yet; it cannot connect to the cluster until the data nodes have finished starting, which may take some time. You can ... Once the NDB Cluster executables and needed configuration files are in place, performing an initial start of the cluster is simply a matter of starting the NDB Cluster executables for all nodes in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
A loss of connection can occur either between the source cluster SQL node and the replica cluster SQL node, or between the source SQL node and the data nodes of the source cluster. The source SQL node issues a “gap” event when connecting or ...