PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...
https://dev.mysql.com/doc/refman/9.7/en/index-page-merge-threshold.html
If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index page. The default ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-cached-indexes-table.html
Index identifiers are unique across all the databases in an instance. The INNODB_CACHED_INDEXES table reports the number of index pages cached in the InnoDB buffer pool for each index. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-cmpmem-table.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer pool. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables have these columns: PAGE_SIZE The block size in bytes. PAGES_USED The ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-metrics-table.html
The INNODB_METRICS table has these columns: NAME A unique name for the counter. The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for InnoDB.
https://dev.mysql.com/doc/refman/9.7/en/information-schema-json-duality-view-columns-table.html
The JSON_DUALITY_VIEW_COLUMNS table shows information about all columns referenced by any JSON duality view which is accessible by the current user. The JSON_DUALITY_VIEW_COLUMNS table has the following columns: TABLE_CATALOG View catalog; this is ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-json-duality-view-tables-table.html
The JSON_DUALITY_VIEW_TABLES table shows information about all tables referenced by any JSON duality view which is accessible by the current user. The JSON_DUALITY_VIEW_TABLES table has the columns listed here: TABLE_CATALOG View catalog; this is ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-key-column-usage-table.html
One row with CONSTRAINT_NAME = 'CO', TABLE_NAME = 't3', COLUMN_NAME = 's2', ORDINAL_POSITION = 1, POSITION_IN_UNIQUE_CONSTRAINT = 1. This table provides no information about functional key parts because they are expressions and the table provides ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-parameters-table.html
The return value is not a true parameter, so the row that describes it has these unique characteristics: The ORDINAL_POSITION value is 0. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-statistics-table.html
NON_UNIQUE 0 if the index cannot contain duplicates, 1 if it can. CARDINALITY An estimate of the number of unique values in the index. The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...