PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
InnoDB does not currently support foreign keys for tables with user-defined partitioning. This restriction does not apply for NDB tables that are partitioned by KEY or LINEAR KEY (the only user partitioning types supported by the NDB storage ...For ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
Access to the replica's connection metadata repository file or table should be restricted to the database administrator, because it contains the replication user account name and password for connecting to the source. The metadata in this repository ...Updates to the replica's applier metadata repository table are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, even in the event of an unexpected server ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-enterprise-backup.html
The following instructions assume that you are already familiar with how to use MySQL Enterprise Backup to perform a backup; if that is not the case, please review the MySQL Enterprise Backup 4.1 User's Guide, especially Backing Up a Database Server. Connect to the restored server with a mysql client and reset the source and replica information with the following commands: mysql> RESET MASTER;mysql> RESET SLAVE ALL; For the restored server to be able to recover automatically using Group Replication's built-in mechanism for distributed recovery, configure the server's gtid_executed ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
Undo logs that reside in the temporary tablespace are used for transactions that modify data in user-defined temporary tables. An undo log record contains information about how to undo the latest change by a transaction to a clustered index record.
https://dev.mysql.com/doc/refman/5.7/en/keyring-okv-plugin.html
For details, consult the section named Add a KMIP Server in the KeySecure User Guide. The default value is empty, so you must set the variable to name a properly configured directory before the plugin can communicate with the KMIP back end. The ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
Because the MYSQL_ONETIME_PASSWORD option is true by default, after you have connected a mysql client to the server, you must reset the server root password by issuing this statement: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
As a table, updates to the applier metadata repository are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, even in ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
To override these system-wide settings and configure optimizer statistics parameters for individual tables, you can define STATS_PERSISTENT, STATS_AUTO_RECALC, and STATS_SAMPLE_PAGES clauses in CREATE TABLE or ALTER TABLE statements. The value ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir Logical Downgrade Logical downgrade involves using mysqldump to dump all tables from the new MySQL version, and then loading the dump file into ...Configure MySQL to perform a slow shutdown by setting innodb_fast_shutdown to ...In-place ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-nodes-groups.html
(You should be aware that the number of LDM threads increases with the value of this parameter, but not in a strictly linear fashion, and that there are additional constraints on setting it; see the description of MaxNoOfExecutionThreads for more ...