Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-debugging-profiling.html
logger The name of a class that implements 'com.mysql.cj.log.Log' that will be used to log messages to. Default Value com.mysql.cj.log.StandardLogger Since Version 3.1.1 profilerEventHandler Name of a class that implements the interface ...Default ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-charsets.html
For example, to use the 4-byte UTF-8 character set with Connector/J, configure the MySQL server with character_set_server=utf8mb4, and leave characterEncoding and connectionCollation out of the Connector/J connection string. MySQL to Java Encoding ...Setting the Character Encoding For Connector/J 8.0.25 and earlier: The character encoding between the client and the server is automatically detected upon connection (provided that the Connector/J connection properties characterEncoding and connectionCollation are not ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test suite. This section gives details on an interface-by-interface level about implementation ...
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. If you now had an additional instance of MySQL running on port 3309, you ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config.html
This article will focus on Java-oriented access to MySQL databases with Spring 2.0. For the examples in this section the MySQL world sample database will be used. The first task is to set up a MySQL data source through Spring. For example, to ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The MySQL 8.4 server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is ...
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or both. Backing up the physical database ...
https://dev.mysql.com/doc/refman/8.4/en/backup-strategy-example.html
You should include such options as necessary to enable client programs to connect to the MySQL server. Assume also that the MySQL server is under load at the time of the crash. For cases of operating system crashes or power failures, we can assume ...Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. For information about semijoin strategies, see Optimizing IN and EXISTS Subquery Predicates with Semijoin ...The BKA ...
https://dev.mysql.com/doc/refman/8.4/en/call.html
When the procedure returns, a client program can also obtain the number of rows affected for the final statement executed within the routine: At the SQL level, call the ROW_COUNT() function; from the C API, call the mysql_affected_rows() function.