Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-blob-clob-processing.html
blobSendChunkSize Chunk size to use when sending BLOB/CLOBs via server-prepared statements. Note that this value cannot exceed the value of 'maxAllowedPacket' and, if that is the case, then this value will be corrected automatically. Since Version ...
https://dev.mysql.com/doc/connector-j/en/connector-j-fractional-seconds.html
However, when Connector/J inserted a java.sql.TIME into the server as a MySQL TIME value, the fractional seconds were always truncated. To allow the fractional seconds to be sent to the server, a connection property, sendFractionalSecondsForTime, ...
https://dev.mysql.com/doc/connector-j/en/connector-j-named-pipe.html
Important Minimal permissions on named pipes are granted to clients that use them to connect to the server. As a workaround, the MySQL Server that Connector/J wants to connect to must be started with the system variable ...Connector/J, however, can ...
https://dev.mysql.com/doc/connector-j/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-managing-load-balanced-connections.html
Connector/J has long provided an effective means to distribute read/write load across multiple MySQL server instances for Cluster or source-source replication deployments. In-process transactions are not lost, and no application exceptions are ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-known-issues-limitations.html
Therefore, when setting and retrieving dates that were before the Julian-Gregorian cutover (October 15, 1582) using the PreparedStatement methods, always supply explicitly a proleptic Gregorian calendar to the setDate() and getDate() methods, in ...
https://dev.mysql.com/doc/refman/8.4/en/account-categories.html
If the user that puts a server in offline mode does not have the SYSTEM_USER privilege, connected client users who have the SYSTEM_USER privilege are also not disconnected. However, these users cannot initiate new connections to the server while it ... MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-formats.html
The server uses several logging formats to record information in the binary log: Replication capabilities in MySQL originally were based on propagation of SQL statements from source to replica. You can cause this format to be used by starting the ...In row-based logging (the default), the source writes events to the binary log that indicate how individual table rows are ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-create.html
For example, to specify a directory of C:\temp, use these lines: [mysqld] tmpdir=C:/temp The C:\temp directory must exist and have sufficient space for the MySQL server to write to. Make sure that the MySQL server can write to the tmpdir directory.