PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmpmem-table.html
row *************************** page_size: 16384 buffer_pool_instance: 0 pages_used: 0 pages_free: 0 relocation_ops: 0 relocation_time: 0 Notes Use these tables to measure the effectiveness of InnoDB table compression in your database. The ...row ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-cache-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). Before querying it, set the value of the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
Before an in-place online DDL operation can finish, it must wait for transactions that hold metadata locks on the table to commit or roll back. This is similar to the idea of a foreign key constraint check in InnoDB in which constraints must hold ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-fields-table.html
The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. The INNODB_FIELDS table has these columns: INDEX_ID An identifier for the index associated with this key field; the same value as INNODB_INDEXES.INDEX_ID.
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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. As of MySQL 8.0.22, you can optimize how InnoDB allocates space to file-per-table ...As of MySQL 8.0.22, you can disable innodb_extend_and_initialize on Linux systems to avoid physically writing NULLs to newly allocated tablespace ...
https://dev.mysql.com/doc/refman/8.0/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/refman/8.0/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.0/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 ...