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/group-replication-use-cases.html
There is a distributed recovery procedure to ensure that when servers join the group they are brought up to date automatically. There is no need for server fail-over, and the multi-source update everywhere nature ensures that even updates are not ...
https://dev.mysql.com/doc/refman/5.7/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
Storage engines collect statistics about tables for use by the optimizer. Table statistics are based on value groups, where a value group is a set of rows with the same key prefix value. For optimizer purposes, an important statistic is the average ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
The CREATION_TIME, LAST_UPDATE_TIME, and LAST_ACCESSED values are as reported by the operating system, and are not supplied by the NDB storage engine. The FILES table provides information about the files in which MySQL tablespace data is stored. In ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
The value is INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified). To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
The buffered changes, which may result from INSERT, UPDATE, or DELETE operations (DML), are merged later when the pages are loaded into the buffer pool by other read operations. Similarly, deletes and updates may affect secondary index pages that ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-limitations.html
The shared metadata lock permits the online DDL operation to proceed but blocks the operation in its final phase, when an exclusive metadata lock is required to update the table definition. OPTIMIZE TABLE for an InnoDB table is mapped to an ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbd.html
In a multi-processor system performing a large number of operations (including updates), the ndbd process can consume up to 2 CPUs if permitted to do so. The ndbd binary provides the single-threaded version of the process that is used to handle all ...