Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
These audit log functions are available: audit_log_encryption_password_get([keyring_id]) This function fetches an audit log encryption password from the MySQL keyring, which must be enabled or an error occurs. Any keyring component or plugin can be ...Unless those objects are installed, the audit_log plugin operates in (deprecated) legacy ...
https://dev.mysql.com/doc/refman/8.4/en/bug-reports.html
The options to programs such as mysqld and mysql, and to the configure script, are often key to resolving problems and are very relevant. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP REPLICA SQL_THREAD ...The effects of the statement are not persistent; any filters set using CHANGE REPLICATION FILTER are lost following a restart of the replica ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. For a ...
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature-windows.html
The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using GPG. That guide also applies to Microsoft Windows, but another option is to use a GUI tool like Gpg4win. You may use a different tool ...
https://dev.mysql.com/doc/refman/8.4/en/comments.html
For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers should not: SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE ... MySQL Server supports three comment styles: From a # character to ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
In read-only mode, it remains possible to change tables created with the TEMPORARY keyword using DML statements. The BEGIN statement differs from the use of the BEGIN keyword that starts a BEGIN ... The optional WORK keyword is supported for COMMIT ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-dns-srv.html
For example, a client might support specifying the name within a URI-like connection string or as a key-value pair. In the Domain Name System (DNS), a SRV record (service location record) is a type of resource record that enables a client to ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 5 filtered: 20.00 Extra: Using where 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS; ... Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during ...
https://dev.mysql.com/doc/refman/8.4/en/corrupted-myisam-tables.html
Typical symptoms of a corrupt table are: You get the following error while selecting data from the table: Incorrect key file for table: '...'. Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are ...