PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-table.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. The INNODB_CMP and INNODB_CMP_RESET tables have these columns: PAGE_SIZE The compressed page size in bytes. row ...COMPRESS_OPS ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-table-info.html
The table_info table provides information about logging, checkpointing, distribution, and storage options in effect for individual NDB tables.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
The host_cache_size system variable controls the size of the host cache, as well as the size of the host_cache table. Because the host_cache table exposes the contents of the host cache, it can be examined using SELECT statements. The Performance ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variable-tables.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. System variable information is available in these Performance Schema tables: global_variables: Global system variables. An ...For details, see the description of that variable in Section 5.1.7, “Server System ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 25.1 Performance Schema Tables Table Name Description Deprecated accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html
REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has variables that control memory allocation. For REPAIR TABLE, the same principle applies, but ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA The name of the schema (database) to which the table containing the column belongs. Unlike SHOW COLUMNS, SELECT ...ORDINAL_POSITION is necessary because you might want to say ORDER BY ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-locks-table.html
The INNODB_LOCKS table provides information about each lock that an InnoDB transaction has requested but not yet acquired, and each lock that a transaction holds that is blocking another transaction. Note This table is deprecated as of MySQL 5.7.14 ...Although LOCK_ID currently contains TRX_ID, the format of the data in LOCK_ID is subject to change at any ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-columns-table.html
The INNODB_SYS_COLUMNS table provides metadata about InnoDB table columns, equivalent to the information from the SYS_COLUMNS table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB ...When a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-datafiles-table.html
The INNODB_SYS_DATAFILES table provides data file path information for InnoDB file-per-table and general tablespaces, equivalent to the information in the SYS_DATAFILES table in the InnoDB data dictionary. For related usage information and ...