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/manual-info.html
This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.44. Typographical and Syntax Conventions This manual uses certain typographical conventions: Text in this style is used for SQL statements; database, ...
https://dev.mysql.com/doc/refman/5.7/en/channels-with-prev-replication.html
When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For example, the following statements behave as expected for all ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
For certain data types, you can index a prefix of the column (see Section 8.3.4, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the columns in the index, or queries that test just the first column, the first ... MySQL can create composite indexes (that is, indexes on multiple ...
https://dev.mysql.com/doc/refman/5.7/en/null-values.html
Treatment of \N as a synonym for NULL in SQL statements is deprecated as of MySQL 5.7.18 and is removed in MySQL 8.0; use NULL instead. Be aware that the NULL value is different from values such as 0 for numeric types or the empty string for string ... The NULL value means “no data.” NULL can be written in any ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. See ...In addition (as with RANGE COLUMNS partitioning), you can use multiple columns in the COLUMNS() ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
A number of table and partition maintenance tasks can be carried out using SQL statements intended for such purposes on partitioned tables in MySQL 5.7. Table maintenance of partitioned tables can be accomplished using the statements CHECK TABLE, ...Rebuilds the partition; this has the same effect as dropping all records stored in the partition, then reinserting ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management.html
There are also ways to obtain information about partitioned tables and partitions. For information about partition management in tables partitioned by RANGE or LIST, see Section 22.3.1, “Management of RANGE and LIST Partitions”. For a discussion ... MySQL 5.7 provides a number of ways to modify partitioned ...
https://dev.mysql.com/doc/refman/5.7/en/replication-compatibility.html
For example, if you are using a chained or circular replication setup, you cannot use MySQL 5.7.22, MySQL 5.7.23, and MySQL 5.7.24 concurrently, although you could use any two of these releases together. For example, you can replicate from a source ... MySQL supports replication from one release series to the next higher release ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transactions.html
The server uses these rules for binary logging: If the initial statements in a transaction are nontransactional, they are written to the binary log immediately. Otherwise, they are discarded.) For statement-based logging, logging of nontransactional ...In general, you should avoid transactions that update both transactional and nontransactional tables in a replication ...