PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. The implementation comprises these elements: Keyring components and plugins that manage a backing store ...Keyring use involves installing one from among the available components and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-objects.html
Undo log files are used only by Disk Data tables, and are not needed or used by NDB tables that are stored in memory only. Now we can create a tablespace—an abstract container for files used by Disk Data tables to store data. It is also possible ... NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
Nullpos, Nullbit For columns that can be NULL, MyISAM stores NULL values as a flag in a byte. The position and number of bytes used to store NULL flags is shown in the line for field 1. no endspace, not_always Do not store endspace and do not do ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
FileSystemPath: Path to directory where data node stores its data (directory must exist). FileSystemPathDataFiles: Path to directory where data node stores its Disk Data files. FileSystemPathDD: Path to directory where data node stores its Disk Data ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
As of MySQL 8.0.14, changing a generated column, when these conditions apply: For InnoDB tables, statements that modify generated stored columns but do not change their type, expression, or nullability. For non-InnoDB tables, statements that modify ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
ANALYZE TABLE generates table statistics: ANALYZE TABLE without any HISTOGRAM clause performs a key distribution analysis and stores the distribution for the named table or tables. ANALYZE TABLE with the UPDATE HISTOGRAM clause generates histogram ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
As of MySQL 8.0.19, the password is stored as a utf8mb4 string. Prior to MySQL 8.0.19, the password is stored in binary form. audit_log_password_history_keep_days Command-Line Format --audit-log-password-history-keep-days=# Introduced 8.0.17 System ...Unless those objects are installed, the audit_log plugin operates in legacy mode (deprecated in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN comments do not support TINYBLOB or TINYTEXT columns, since these have an inline part (only) of fixed size, and no separate parts to store elsewhere. (Prior to NDB 8.0.30, only MAX_BLOB_PART_SIZE is supported.) Syntax for this option is ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
When a tablespace is encrypted, a tablespace key is encrypted and stored in the tablespace header. All MySQL editions provide a component_keyring_file component and keyring_file plugin, each of which stores keyring data in a file local to the server ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html
To avoid the issues that come with storing all tables and indexes inside the system tablespace, you can enable the innodb_file_per_table configuration option (the default), which stores each newly created table in a separate tablespace file (with ...