Search Results
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
In the mysqld-auto.cnf option file, the names and values of sensitive system variables are stored in an encrypted format, along with a generated file key to decrypt them. The generated file key is in turn encrypted using a master key ... The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
Examples of the ways query attributes may be used: A web application produces pages that generate database queries, and for each query must track the URL of the page that generated it. The most visible part of an SQL statement is the text of the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-key-rotation.html
When you rotate the binary log master key manually, MySQL Server takes the following actions in sequence: A new binary log encryption key is generated with the next available sequence number, stored on the keyring, and used as the new binary log ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-scope.html
Because the temporary files are volatile and tied to a single process, they are encrypted using single-tier encryption, using a randomly generated file password and initialization vector that exist only in memory and are never stored on disk or in ...Existing binary log files and relay log files that were present on the server when you started encryption are not ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-load-data.html
When binlog_format=STATEMENT is set, note that LOAD DATA does not generate a warning, unlike other unsafe statements. When mysqlbinlog reads log events for LOAD DATA statements logged in statement-based format, a generated local file is created in a ... LOAD DATA is considered unsafe for statement-based logging (see Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). After copying, delete the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-enable-gtids.html
If this step causes any warnings in the log, adjust your application so that it only uses GTID-compatible features and does not generate any warnings. Wait for all transactions generated up to the previous step to replicate to all servers. This ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
In the first phase, the clustered index is scanned, and index entries are generated and added to the sort buffer. Sorted Index Builds and Optimizer Statistics Sorted index builds may result in optimizer statistics that differ from those generated by ... InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
overall: Generate an analysis based on the content of the table specified by in_table. Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary ...