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/replica-logs-relaylog.html
The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log files. The term “relay log file” generally denotes an ...
https://dev.mysql.com/doc/refman/5.7/en/windows-server-first-start.html
After starting the server, you should set up a password for it using the instructions in Section 2.9.4, “Securing the Initial MySQL Account”. Note The database must be initialized before MySQL can be started. The following sections provide more ... This section gives a general overview of starting the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
fq_name is a fully qualified database object name in database/schema/name format, such as test/def/t1 or sys/def/10/b$unique. The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests ...Together with the block name, this number can be used to look up a given instance in the threadblocks ...
https://dev.mysql.com/doc/refman/5.7/en/replication-upgrade.html
For example, you cannot use MySQL 5.7.22, MySQL 5.7.24, and MySQL 5.7.28 concurrently in such a setup, although you could use any two of these releases together. If you are upgrading an existing replication setup from a version of MySQL that does ...
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 ...