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/replication-features-invoked.html
The ORIGINATOR column in the Information Schema EVENTS table and the originator column in mysql.event store this information. You can do this by storing in a separate table the event names from the SELECT statement shown previously, or using ALTER ... Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--safe-user-create Command-Line Format --safe-user-create[={OFF|ON}] Type Boolean Default Value OFF If this option is enabled, a user cannot create new MySQL users by using the GRANT statement unless the user has the INSERT privilege for the ...
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 ...