PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-column-privileges-table.html
TABLE_SCHEMA The name of the schema (database) to which the table containing the column belongs. The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
TABLE_SCHEMA The name of the schema (database) to which the table containing the column belongs. The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. ORDINAL_POSITION is ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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/5.7/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/5.7/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/5.7/en/information-schema-innodb-sys-foreign-table.html
The INNODB_SYS_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). The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
Index identifiers are unique across all the databases in an instance. The INNODB_SYS_INDEXES table provides metadata about InnoDB indexes, equivalent to the information in the internal SYS_INDEXES table in the InnoDB data dictionary. For related ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html
The INNODB_SYS_TABLESPACES table provides metadata about InnoDB file-per-table and general tablespaces, equivalent to the information in the SYS_TABLESPACES table in the InnoDB data dictionary. For related usage information and examples, see ...