Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. Note An easier alternative to generating the files required for SSL than the procedure described here is to let the ...The first example shows a simplified procedure such as you might use from the command ...
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host system. System Requirements for FIPS Mode in MySQL For MySQL to support FIPS mode, these system requirements must be satisfied: MySQL must be ...FIPS mode on the server side applies to cryptographic operations performed by the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-communication-protocol.html
Group Replication in MySQL 8.4 uses the concept of a group communication protocol whose version can be managed explicitly, and set to accommodate the oldest MySQL Server version that you want the group to support. This enables groups to be formed ...When a new member joins a replication group, it checks the communication protocol version that is announced by the existing members of the ...
https://dev.mysql.com/doc/refman/8.4/en/hexadecimal-literals.html
In numeric contexts, MySQL treats a hexadecimal literal like a BIGINT UNSIGNED (64-bit unsigned integer). Converted to a number, it produces 0: mysql> SELECT CHARSET(X''), LENGTH(X''); +--------------+-------------+ | CHARSET(X'') | LENGTH(X'') | ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
You can check the accuracy of statistics by comparing the actual cardinality of an index (determined by running SELECT DISTINCT on the index columns) with the estimates in the mysql.innodb_index_stats table. 17.8.10.1.5 InnoDB Persistent Statistics ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.4/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...In ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. As discussed elsewhere in this Manual (see Section 7.1.11, “Server SQL Modes”), the results of many MySQL functions and operators may change according to ...The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. This can be more efficient than using mysqldump and importing the file on ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
} This statement displays the privileges and roles that are assigned to a MySQL user account or role, in the form of GRANT statements that must be executed to duplicate the privilege and role assignments. Note To display nonprivilege information for ... SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
You must specify the schema name if the trigger is not in the default schema: mysql> DROP TRIGGER test.ins_sum; If you drop a table, any triggers for the table are also dropped. OLD and NEW are MySQL extensions to triggers; they are not ... To ...