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-columns-table.html
TABLE_SCHEMA The name of the schema (database) to which the table containing the column belongs. The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these columns: ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html
DATABASE_PAGES The number of pages in the InnoDB buffer pool containing data. OLD_DATABASE_PAGES The number of pages in the old buffer pool sublist. The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/information-schema-innodb-cmp-table.html
row *************************** page_size: 16384 compress_ops: 0 compress_ops_ok: 0 compress_time: 0 uncompress_ops: 0 uncompress_time: 0 Notes Use these tables to measure the effectiveness of InnoDB table compression in your database. The ...
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 ...
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-ft-being-deleted-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). The INNODB_FT_BEING_DELETED table provides a snapshot ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-deleted-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). The INNODB_FT_DELETED table stores rows that are ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
Index identifiers are unique across all the databases in an instance. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_INDEXES table has these columns: INDEX_ID An ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-keywords-table.html
Prior to MySQL 8.0.13, selecting from the KEYWORDS table with no default database selected produced an error. The KEYWORDS table lists the words considered keywords by MySQL and, for each one, indicates whether it is reserved. Reserved keywords may ...