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/create-table-like.html
Tables created in the mysql tablespace, the InnoDB system tablespace (innodb_system), or general tablespaces include a TABLESPACE attribute in the table definition, which defines the tablespace where the table resides. LIKE preserves the TABLESPACE ...LIKE does not preserve any DATA DIRECTORY or INDEX DIRECTORY table options that were specified for the original table, or any foreign key ...LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-added-deprecated-removed.html
PartitionsPerNode: Determines the number of table partitions created on each data node; not used if ClassicFragmentation is enabled. RequireEncryptedBackup: Whether backups must be encrypted (1 = encryption required, otherwise 0). Parameters ...
https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html
When innodb_strict_mode is enabled (the default), CREATE TEMPORARY TABLE returns an error if ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE is specified. The innodb_file_per-table option does not affect the creation of InnoDB temporary tables. LIKE to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-migrate-keyring.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. mysql_migrate_keyring supports the following options, which can be specified on the command line or ... The mysql_migrate_keyring utility migrates keys between one keyring component and ...Note --component-dir, --source-keyring, and ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. If you use the --databases or --all-databases option to process all tables in one or more databases, ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-upgrade-downgrade.html
NDB 8.0.22 adds support for IPv6 addressing for management nodes and data nodes in the config.ini file. The EncryptedFileSystem configuration parameter, introduced in NDB 8.0.29, could in some cases cause undo log files to be encrypted, even when ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-configuration.html
Each data node or SQL node requires a my.cnf file that provides two pieces of information: a connection string that tells the node where to find the management node, and a line telling the MySQL server on this host (the machine hosting the data ...
https://dev.mysql.com/doc/refman/8.0/en/mysqladmin.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. You can use it to check the server's configuration and current status, to create and drop databases, ...Some of the commands take an argument following the command ...Invoke mysqladmin like this: ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-component-installation.html
MySQL provides these keyring component choices: component_keyring_file: Stores keyring data in a file local to the server host. component_keyring_encrypted_file: Stores keyring data in an encrypted, password-protected file local to the server host.
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
CHANGE REPLICATION SOURCE TO causes the previous values for SOURCE_HOST, SOURCE_PORT, SOURCE_LOG_FILE, and SOURCE_LOG_POS to be written to the error log, along with other information about the replica's state prior to execution. GTID_ONLY = {0|1} ...