PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/grant.html
[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ... To grant a privilege with GRANT, you must have the GRANT OPTION privilege, and you must have the privileges ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-flow-control.html
Group Replication ensures that a transaction only commits after a majority of the members in a group have received it and agreed on the relative order between all transactions that were sent concurrently. This approach works well if the total ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
This section lists the system variables that are specific to the Group Replication plugin. The name of each Group Replication system variable is prefixed with group_replication_. Most system variables for Group Replication are described as dynamic, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-columns-table.html
The INNODB_SYS_COLUMNS table provides metadata about InnoDB table columns, equivalent to the information from the SYS_COLUMNS table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index belongs. TABLE_SCHEMA The name of the schema (database) to which the table containing the index belongs. NON_UNIQUE 0 if the index ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-and-mysql-replication.html
It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the source. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica.
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Using MySQL Enterprise Backup is the ...
https://dev.mysql.com/doc/refman/5.7/en/insert-select.html
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] SELECT ... [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} assignment: col_name = ...
https://dev.mysql.com/doc/refman/5.7/en/installation-layouts.html
The installation layout differs for different installation types (for example, native packages, binary tarballs, and source tarballs), which can lead to confusion when managing different systems or using different installation sources. The ...
https://dev.mysql.com/doc/refman/5.7/en/making-windows-dumps.html
Program Database files (with suffix pdb) are included in the ZIP Archive Debug Binaries & Test Suite distribution of MySQL. Note The PDB files are available in a separate file labeled "ZIP Archive Debug Binaries & Test Suite". These files provide ...