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/replication-features-auto-increment.html
LIKE: Foreign key definitions are ignored, as are the DATA DIRECTORY and INDEX DIRECTORY table options. (Bug #45677) An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is done correctly, subject to the following exceptions: When using statement-based replication prior to MySQL 5.7.1, AUTO_INCREMENT columns in tables on the replica must match the same columns on the source; that is, AUTO_INCREMENT columns must be replicated to AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
Examples: PRIMARY for a primary key index, GEN_CLUST_INDEX for the index representing a primary key when one is not specified, and ID_IND, FOR_IND, and REF_IND for foreign key constraints. The INNODB_SYS_INDEXES table provides metadata about InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
Gap locking is only used for foreign-key constraint checking and duplicate-key checking. For other search conditions, InnoDB locks the index range scanned, using gap locks or next-key locks to block insertions by other sessions into the gaps covered ... Transaction isolation is one of the foundations of database ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
syntax: a BEFORE INSERT trigger activates for every row, followed by either an AFTER INSERT trigger or both the BEFORE UPDATE and AFTER UPDATE triggers, depending on whether there was a duplicate key for the row. CREATE [DEFINER = user] TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
If a transaction executes against a table that has foreign keys with cascading constraints, then the transaction fails to commit when synchronizing itself with the group. group_replication_recovery_ssl_key Command-Line Format ... This section lists ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-constraints-table.html
The value can be UNIQUE, PRIMARY KEY, FOREIGN KEY, or CHECK. The UNIQUE and PRIMARY KEY information is about the same as what you get from the Key_name column in the output from SHOW INDEX when the Non_unique column is 0. The TABLE_CONSTRAINTS table ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
REFERENCES Creation of a foreign key constraint requires the REFERENCES privilege for the parent table. The privileges granted to a MySQL account determine which operations the account can perform. MySQL privileges differ in the contexts in which ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
If you use a multiple-table DELETE statement involving InnoDB tables for which there are foreign key constraints, the MySQL optimizer might process tables in an order that differs from that of their parent/child relationship. For MyISAM tables, you ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 24.2 INFORMATION_SCHEMA General Tables Table Name Description CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablestats-table.html
MODIFIED_COUNTER The number of rows modified by DML operations, such as INSERT, UPDATE, DELETE, and also cascade operations from foreign keys. CLUST_INDEX_SIZE The number of pages on disk that store the clustered index, which holds the InnoDB table ... The INNODB_SYS_TABLESTATS table provides a view of low-level status information about InnoDB ...