https://dev.mysql.com/c-api.html
For clients, the size of the buffer associated with a connection is not decreased until the connection is closed, at which time client memory is reclaimed. The C API provides low-level access to the MySQL client/server protocol and enables C ...
https://dev.mysql.com/caching-sha2-pluggable-authentication.html
For example: shell> mysql --ssl-mode=DISABLED -u sha2user -p Enter password: password For this connection attempt by sha2user, the server determines that caching_sha2_password is the appropriate authentication plugin and invokes it (because that was ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...
https://dev.mysql.com/changing-mysql-user.html
To start the server as the given user automatically at system startup time, specify the user name by adding a user option to the [mysqld] group of the /etc/my.cnf option file or the my.cnf option file in the server's data directory. On Windows, you ...
https://dev.mysql.com/channels-startup-options.html
--slave_net-timeout=N This value is set per channel, so that each channel waits for N seconds to check for a broken connection. This section describes startup options which are impacted by the addition of replication channels. The following startup ...
https://dev.mysql.com/charset-database.html
For stored routines (procedures and functions), the database character set and collation in effect at routine creation time are used as the character set and collation of character data parameters for which the declaration includes no CHARACTER SET ... Every database has a database character set and a database ...
https://dev.mysql.com/charset-examples.html
Example 2: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 ) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci; This time we have a column with a latin1 character set and a default collation. The following ...
https://dev.mysql.com/charset-unicode-utf32.html
utf32 takes twice as much space as ucs2 and more space than utf16, but utf32 has the same advantage as ucs2 that it is predictable for storage: The required number of bytes for utf32 equals the number of characters times 4. The utf32 character set ...
https://dev.mysql.com/clone-plugin-installation.html
With this plugin-loading method, the option must be given each time the server starts. This section describes how to install and configure the clone plugin. For remote cloning operations, the clone plugin must be installed on the donor and ...
https://dev.mysql.com/clone-plugin-limitations.html
Only a single MySQL instance can be cloned at a time. The clone plugin is subject to these limitations: DDL, including TRUNCATE TABLE, is not permitted during a cloning operation. A workaround is to use dedicated donor instances, which can ...
https://dev.mysql.com/clone-plugin-options-variables.html
They can be changed dynamically at runtime using the SET statement, which enables you to modify operation of the server without having to stop and restart it. Setting a global system variable runtime value normally requires the ... This section ...
