PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partial-revokes.html
Prior to MySQL 8.0.16, it is not possible to grant privileges that apply globally except for certain schemas. As of MySQL 8.0.16, that is possible if the partial_revokes system variable is enabled. Specifically, for users who have privileges at the ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. Atomic DDL Characteristics The characteristics of atomic DDL statements ...The operation is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. The only tables that would be safe from this sort of mayhem would be those tables that were ... In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-key-migration.html
This pertains to migration strategy because the way in which the source and destination keystores are managed determines whether a particular type of key migration is possible and the procedure for performing it: Migration from one keyring plugin to ... A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
If you are running with --safe-updates enabled, status also prints the values for the mysql variables that affect your queries. For server side help, type 'help contents' If mysql is invoked with the --binary-mode option, all mysql commands are ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online.html
This section describes how to change the mode of replication from and to GTID mode without having to take the server offline.
https://dev.mysql.com/doc/refman/8.0/en/select.html
[WITH ROLLUP]] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [into_option] [FOR {UPDATE | SHARE} [OF tbl_name [, tbl_name] ...] [NOWAIT | SKIP LOCKED] | LOCK IN SHARE MODE] [into_option] into_option: { INTO OUTFILE 'file_name' [CHARACTER ...If you use FOR UPDATE with a storage engine that uses page or row locks, rows examined by the query are write-locked until the end of the current ... SELECT [ALL | DISTINCT | DISTINCTROW ] ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-system-variables.html
If you create the directory manually, it should have a restrictive mode and be accessible only to the account used to run the MySQL server. If this variable is specified in an option file, the file should have a restrictive mode and be accessible ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
You can remove the files manually, but it is preferable to use PURGE BINARY LOGS, which also safely updates the binary log index file for you (and which can take a date argument). The binary log also contains information about how long each ... The ...
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
The TIMESTAMP and DATETIME data types offer automatic initialization and updating to the current date and time. For more information, see Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. Invalid DATE, DATETIME, ...This section describes their characteristics, how they are similar, and how they ...