Search Results
https://dev.mysql.com/doc/connector-j/en/connecting-using-kerberos.html
Kerberos is a ticket-based server-client mutual authentication protocol that is supported by the MySQL Server (commercial versions only) . Support for Kerberos is implemented by Connector/J using the GSS-API, JAAS API, and JCA API; providers for ...
https://dev.mysql.com/doc/connector-j/en/connector-j-config-failover.html
A failover happens when connection-related errors occur for an underlying, active connection. The connection errors are, by default, propagated to the client, which has to handle them by, for example, recreating the working objects (Statement, ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-high-availability-and-clustering.html
autoReconnect Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
Connection pooling is a technique of creating and managing a pool of connections that are ready for use by any thread that needs them. Connection pooling can greatly increase the performance of your Java application, while reducing overall resource ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-generated-columns.html
ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and CHANGE. CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified.
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space management. The ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for type are: STATEMENT causes logging to be statement based. Setting the binary logging format does not activate ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no ...
https://dev.mysql.com/doc/refman/8.4/en/charset-syntax.html
There are default settings for character sets and collations at four levels: server, database, table, and column. The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads ...