Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-session.html
sessionVariables A comma or semicolon separated list of "name=value" pairs to be sent as "SET [SESSION] ..." to the server when the driver connects. Since Version 3.1.8 characterEncoding Instructs the server to set session system variables ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-x-protocol-and-x-devapi.html
If the property is not set, the mechanism is chosen depending on the connection type: "PLAIN" is used for TLS connections and "SHA256_MEMORY" or "MYSQL41" is used for unencrypted connections. Default Value PLAIN Since Version 8.0.8 ...
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. The JDBC specification is flexible on how certain functionality should be implemented. This section gives details on an interface-by-interface level about implementation decisions that might affect how you code applications with MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
over_clause is described in Section 14.20.2, “Window Function Concepts and Syntax”, which also includes other information about window function usage. This section describes aggregate functions that operate on sets of values. They are often ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
For usage information and examples, see Section 26.3.3, “Exchanging Partitions and Subpartitions with Tables”. Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses caching on the server side for better performance and has ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8.html
utf8 has been used by MySQL in the past as an alias for the utf8mb3 character set, but this usage is now deprecated; in MySQL 8.4, SHOW statements and columns of INFORMATION_SCHEMA tables display utf8mb3 instead. For more information, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/cleartext-pluggable-authentication.html
(Examples are the PAM and simple LDAP authentication plugins; see Section 8.4.1.5, “PAM Pluggable Authentication”, and Section 8.4.1.7, “LDAP Pluggable Authentication”.) The following discussion provides usage information specific to ... A ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
If your cloning operation is not achieving the desired data transfer rate and you have available bandwidth, check I/O usage on the recipient and donor. This section describes the system variables that control operation of the clone plugin. If ...
https://dev.mysql.com/doc/refman/8.4/en/compressed-format.html
This minimizes disk usage, which is helpful when using slow disks (such as CD-ROMs). Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables ...