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/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? A.6.4. What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
In MySQL version 5.7.5, this variable was added as simplified_binlog_gtid_recovery and in MySQL version 5.7.6 it was renamed to binlog_gtid_simple_recovery. This is the same as the value of the Executed_Gtid_Set column in the output of SHOW MASTER ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
For example, a table rename failure could result in a “missing” *.ibd file without an MLOG_FILE_DELETE record. In this case, you could manually rename the tablespace file and restart crash recovery, or you could restart the server in recovery ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
(It is permissible to rename or move the file, as long as you change the value of keyring_encrypted_file_data to match.) keyring_encrypted_file_password Command-Line Format --keyring-encrypted-file-password=password Introduced 5.7.21 System Variable ...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/reserved-accounts.html
Strictly speaking, this account name is not reserved, in the sense that some installations rename the root account to something else to avoid exposing a highly privileged account with a well-known name. Use of the mysql.sys account avoids problems ... One part of the MySQL installation process is data directory initialization (see Section 2.9.1, “Initializing the Data ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
To upgrade in this case, remove or rename the existing sys schema first. Use of the dedicated mysql.sys account avoids problems that occur if a DBA renames or removes the root account. MySQL 5.7 includes the sys schema, a set of objects that helps ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable column that exists in the table schema in the backup becomes part of the table's primary key in the database. Important ... 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/create-table.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; For more information, see Section 13.1.18.3, “CREATE TABLE ... | ...