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-single-primary-mode.html
In this mode the group has a single-primary server that is set to read-write mode. This avoids possible concurrency issues between old transactions from the old primary and the new ones being executed on this member. All the other members in the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-summary.html
For applying and externalizing the certified transactions, Group Replication permits servers to deviate from the agreed order of the transactions if this does not break consistency and validity. This is permitted when the certification process has ... Group Replication is a technique that can be used to implement fault-tolerant ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
This table object is not shared by other sessions and is not closed until the session calls HANDLER ... This statement works for InnoDB tables as well, but there is no such concept because there is no separate data file. This occurs when both of the ... HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. (This does not apply to other operations on temporary tables ...Most of these statements also cause an implicit commit after ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-cols-table.html
The INNODB_SYS_FOREIGN_COLS table has these columns: ID The foreign key index associated with this index key field, using the same value as INNODB_SYS_FOREIGN.ID. POS The ordinal position of this key field within the foreign key index, starting from ... The INNODB_SYS_FOREIGN_COLS table provides status information about the columns of InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN_COLS table in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
FOR_NAME The name of the child table in this foreign key relationship. REF_NAME The name of the parent table in this foreign key relationship. row *************************** ID: test/fk1 FOR_NAME: test/child REF_NAME: test/parent N_COLS: 1 TYPE: 1 ... The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN table in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
If the constraint is a foreign key, then this is the column of the foreign key, not the column that the foreign key references. For foreign-key constraints, this column is the ordinal position in key of the table that is being referenced. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...