PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
This is done because InnoDB and these operating systems cannot drop a table that is in use. If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new ...
https://dev.mysql.com/doc/refman/8.0/en/alter-view.html
This statement requires the CREATE VIEW and DROP privileges for the view, and some privilege for each column referred to in the SELECT statement. ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER ...
https://dev.mysql.com/doc/refman/8.0/en/audit-api-message-emit.html
Because installing and uninstalling the audit_api_message_emit component installs and uninstalls the audit_api_message_emit_udf() function that the component implements, it is not necessary to use CREATE FUNCTION or DROP FUNCTION to do so. As of ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
A disadvantage of PERFORMANCE strategy is that it drops events when the buffer is full. This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
Either drag and drop the signature (.asc) file into Kleopatra, or load the dialog from File, Decrypt/Verify Files..., and then choose either the .msi or .asc file. The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
To view undo tablespace file names on the donor to ensure that they are unique, query INFORMATION_SCHEMA.FILES: mysql> SELECT TABLESPACE_NAME, FILE_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE LIKE 'UNDO LOG'; For information about dropping ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. Table-level options for controlling read from any replica and partition balance can be ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
Adding or dropping a secondary index on a virtual column is an in-place operation. A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index may be created on one or more virtual columns or on ...