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/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-flow-control.html
This approach works well if the total number of writes to the group does not exceed the write capacity of any member in the group. The information is shared every second, and this period is sufficient to address both concerns. This means that every ... 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 ...
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 ...