Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-foreign-cols-table.html
The INNODB_FOREIGN_COLS table provides status information about InnoDB foreign key columns. The INNODB_FOREIGN_COLS table has these columns: ID The foreign key index associated with this index key field; the same value as INNODB_FOREIGN.ID. row ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-foreign-table.html
The INNODB_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, test/products_fk). row *************************** ID: test/fk1 FOR_NAME: test/child ...For ...0 = ON DELETE/UPDATE RESTRICT, 1 = ON DELETE CASCADE, 2 = ON DELETE SET NULL, 4 = ON UPDATE CASCADE, 8 = ON UPDATE SET NULL, 16 = ON DELETE NO ACTION, 32 = ON UPDATE NO ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-optimize-tablespace-page-allocation.html
Attempting to disable innodb_extend_and_initialize on those systems returns the following error: Changing innodb_extend_and_initialize not supported on this platform. You can optimize how InnoDB allocates space to file-per-table and general ...You ...This behavior can affect performance if new pages are allocated ...
https://dev.mysql.com/doc/internals/en/innodb-more-information.html
References: The most relevant InnoDB source-code files are rem0rec.c, rem0rec.ic, and rem0rec.h in the rem ("Record Manager") directory.
https://dev.mysql.com/doc/internals/en/innodb-more-page-information.html
References: The most relevant InnoDB source-code files are page0page.c, page0page.ic, and page0page.h in the page directory.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-compared.html
See Section 25.2.6.3, “NDB and InnoDB Feature Usage Summary”, for a comparison of the relative suitability of each for use in common types of database applications. They see NDB as a possible alternative or upgrade to the default InnoDB storage ...Since both NDB and InnoDB can serve as transactional MySQL storage engines, users of MySQL Server sometimes become interested in NDB ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbfulltext-category.html
Lists the InnoDB Fulltext configuration metrics and provides a brief description of each. Table 7.15 InnoDB Fulltext Configuration Metrics NameDescriptionAux Table Specifies the qualified name of an InnoDB table containing a FULLTEXT index. Cache ...Enable Diag Print Whether to enable additional full-text search (FTS) diagnostic ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-failure-conditions.html
The tmpdir or innodb_tmpdir file system runs out of disk space, while MySQL writes temporary sort files on disk during index creation. The operation takes a long time and concurrent DML modifies the table so much that the size of the temporary ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-detection.html
The same error may also occur if the locking thread must look at more than 1,000,000 locks owned by transactions on the wait-for list. When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not return an error. If a statement returns an error, the commit or rollback behavior depends ...If autocommit mode is disabled within a session with SET autocommit = 0, the session always has a transaction ...