PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-table.html
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 has these columns: CONSTRAINT_CATALOG The name of the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-extensions-table.html
The TABLES_EXTENSIONS table (available as of MySQL 8.0.21) provides information about table attributes defined for primary and secondary storage engines. The TABLES_EXTENSIONS table has these columns: TABLE_CATALOG The name of the catalog to which ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tablespaces-table.html
For InnoDB, the INFORMATION_SCHEMA INNODB_TABLESPACES and INNODB_DATAFILES tables provide tablespace metadata. It is deprecated; expect it to be removed in a future MySQL release. Other INFORMATION_SCHEMA tables may provide related information: For ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-view-routine-usage-table.html
You can see information only for views for which you have some privilege, and only for functions for which you have some privilege. The VIEW_ROUTINE_USAGE table (available as of MySQL 8.0.13) provides access to information about stored functions ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema.html
Other terms that are sometimes used for this information are data dictionary and system catalog. INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-in-memory-structures.html
This section describes InnoDB in-memory structures and related topics. ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-on-disk-structures.html
This section describes InnoDB on-disk structures and related topics. ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-buffer-pool.html
This section provides configuration and tuning information for the InnoDB buffer pool.
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-read_ahead.html
Random read-ahead is a technique that predicts when pages might be needed soon based on pages already in the buffer pool, regardless of the order in which those pages were read. To enable this feature, set the configuration variable ... A read-ahead ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-model.html
InnoDB performs locking at the row level and runs queries as nonlocking consistent reads by default, in the style of Oracle. Typically, several users are permitted to lock every row in InnoDB tables, or any random subset of the rows, without causing ... The InnoDB transaction model aims to combine the best properties of a multi-versioning database with traditional two-phase ...