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/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. For example: ALTER TABLE t1 DISCARD PARTITION ...Simply using a partition_options clause with ALTER TABLE on a partitioned table repartitions the table according to the partitioning scheme defined by the ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
These keywords are important to allow multiple sessions to read and write InnoDB tables concurrently, providing substantial scalability benefits in write-heavy workloads. If you have UNIQUE constraints on secondary keys, you can speed up a table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Table import limitations outlined in Section 14.6.1.3, “Importing InnoDB Tables” are applicable to this procedure. A warning is issued indicating that InnoDB tries to import the file without schema verification. Information about table ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
Important When extending a table's primary key, any columns which become part of primary key must not be updated while the backup is being taken; any such updates discovered by ndb_restore cause the restore operation to fail, even when no change in ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-enable-gtids.html
On each server, execute: SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = ON; On each server, execute: SET @@GLOBAL.GTID_MODE = OFF_PERMISSIVE; It does not matter which server executes this statement first, but it is important that all servers complete this ... This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
Important For users familiar with the ANSI/ISO SQL Standard, please note that no storage engine, including InnoDB, recognizes or enforces the MATCH clause used in referential integrity constraint definitions. Important Table-level DATA DIRECTORY and ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
This value is set to 1 by default, on the assumption that data being stored is important to preserve in case of an outage and should immediately be committed. Important Care should be taken when changing innodb_buffer_pool_chunk_size, as changing ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
Important Once the keyring_encrypted_file plugin has created its data file and started to use it, it is important not to remove the file. Important Once the keyring_encrypted_file_password value has been set, changing it does not rotate the keyring ...These variables are unavailable unless the appropriate keyring plugin is installed (see Section 6.4.4.1, “Keyring Plugin ...
https://dev.mysql.com/doc/refman/5.7/en/load-data-local-security.html
For the mysqlimport client, local data loading is not used by default. MySQL Shell includes these dump and dump loading utilities: Table export utility util.exportTable() Exports a MySQL relational table into a data file, which can be uploaded to a ... The LOAD DATA statement loads a data file into a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
Important Because each SQL node using connection pooling occupies multiple API node slots—each slot having its own node ID in the cluster—you must not use a node ID as part of the cluster connection string when starting any mysqld process that ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...