Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-instance.html
Instead, a warning is generated and encryption is disabled for new connections on the interface to which the statement applies. ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE ...
https://dev.mysql.com/doc/refman/8.4/en/alter-tablespace.html
ADD DATAFILE is used with ENGINE = NDB, a data file is created on each Cluster data node, but only one row is generated in the Information Schema FILES table. It can be used to add a new data file to, or to drop a data file from an NDB tablespace.
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
DDL operations that involve multiple data file operations generate multiple DDL log records. An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-reading.html
Events that do not fit within the buffer size are skipped and generate warnings. The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log files. (This capability does not apply to log files written in ...
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
For SQL output (CREATE and INSERT statements), local or remote dumps can be done and generate output on the client. This section describes the characteristics of different types of backups. Physical (Raw) Versus Logical Backups Physical backups ...
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
You can generate new queries from existing ones that are similar by copying and editing script files. In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
mysqld appends a numeric extension to the binary log base name to generate binary log file names. The binary log contains “events” that describe database changes such as table creation operations or changes to table data. It also contains ...
https://dev.mysql.com/doc/refman/8.4/en/binlog.html
It is generated by the mysqlbinlog program as the printable representation of certain events in binary log files. (See Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”.) The 'str' value is a base 64-encoded string the ...
https://dev.mysql.com/doc/refman/8.4/en/checksum-table.html
For a nonexistent table, CHECKSUM TABLE returns NULL and generates a warning. [QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. You can use this statement to verify that the contents are the same before and after a ...