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-columns-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table has these columns: TABLE_ID An identifier representing the table associated with the column; the same ...
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). For related usage information and examples, see Section 17.15.3, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
TYPE A numeric value derived from bit-level information that identifies the index type. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_INDEXES table has these ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tables-table.html
FLAG A numeric value that represents bit-level information about table format and storage characteristics. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_TABLES table ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-brief-table.html
FLAG A numeric value that represents bit-level information about tablespace format and storage characteristics. The INNODB_TABLESPACES_BRIEF table provides space ID, name, path, flag, and space type metadata for file-per-table, general, undo, and ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-table.html
FLAG A numeric value that represents bit-level information about tablespace format and storage characteristics. The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo tablespaces. For related usage information ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-profiling-table.html
The PROFILING table has these columns: QUERY_ID A numeric statement identifier. Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 15.7.7.30, “SHOW PROFILE Statement”). The table is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-adaptive-hash.html
If there are numerous threads waiting on rw-latches created in btr0sea.c, consider increasing the number of adaptive hash index partitions or disabling the adaptive hash index. The adaptive hash index enables InnoDB to perform more like an ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-resize.html
| +----------------------------------+----------------------------------+ From MyQL 8.0.31, you can also monitor an online buffer pool resizing operation using the Innodb_buffer_pool_resize_status_code and Innodb_buffer_pool_resize_status_progress ... You can configure InnoDB buffer pool size offline or while the server is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-change-buffer.html
Change buffer merging may take several hours when there are many affected rows and numerous secondary indexes to update. The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the ...