PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
Issue this ALTER TABLE statement to tell InnoDB to use the new .ibd file for the table: ALTER TABLE tbl_name IMPORT TABLESPACE; Note The ALTER TABLE ... IMPORT TABLESPACE feature does not enforce foreign key constraints on imported data. To improve ... This section describes techniques for moving or copying some or all InnoDB tables to a different server or ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
How do I import an existing MySQL database into an NDB Cluster? A.10.28. For information about new features and other important changes in this series, see What is New in MySQL NDB Cluster 8.0. It is especially important to keep in mind that every ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
Important Replication filters cannot be used on a MySQL server instance that is configured for Group Replication, because filtering transactions on some servers would make the group unable to reach agreement on a consistent state. Another important ... This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas Options for Logging Replica Status to Tables System Variables Used on Replicas Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
These variables control many aspects of storage, memory use, and I/O patterns for InnoDB tables, and are especially important now that InnoDB is the default storage engine. secure_file_priv Command-Line Format --secure-file-priv=dir_name System ...
https://dev.mysql.com/doc/refman/5.7/en/checking-rpm-signature.html
To import the MySQL public key into the RPM keyring, first obtain the key, then use rpm --import to import the key. For example: $> gpg --export -a 3a79bd29 > 3a79bd29.asc $> rpm --import 3a79bd29.asc Alternatively, rpm also supports loading the key ...RPM 4.1 no longer uses your personal GPG keyring (or GPG ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
These conditions apply to the following system variables: group_replication_single_primary_mode group_replication_enforce_update_everywhere_checks group_replication_gtid_assignment_block_size default_table_encryption lower_case_table_names ... This ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
This section provides information about specifying InnoDB settings in a configuration file, viewing InnoDB initialization information, and important storage considerations. Important Storage Considerations Review the following storage-related ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
One of these is to modify the table definition before importing it into the Cluster database. Then modify the table definitions as just described and import the file into the SQL node of the cluster like this: $> mysql world < /tmp/world.sql If you ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
New features and other important changes in NDB Cluster 7.6 which are likely to be of interest are shown in the following list: New Disk Data table file format. Important The old and new formats are not compatible; different data files or undo log ...A new file format is used in NDB 7.6 for NDB Disk Data tables, which makes it possible for each Disk Data table to be uniquely identified without reusing any table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-setup-replicas.html
The next steps depend on whether you have existing data to import to the replica or not. Choose one of the following: If you do not have a snapshot of a database to import, see Section 16.1.2.5.3, “Setting Up Replication between a New Source and ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...