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/index-statistics.html
(This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this happens, the statistics are collected using whatever value innodb_stats_method or myisam_stats_method has at the time. Storage engines collect ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-buffer-page-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-ft-index-cache-table.html
The same word can occur several times within the cache table, once for each combination of DOC_ID and POSITION values. The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-ft-index-table-table.html
The same word can occur several times within the cache table, once for each combination of DOC_ID and POSITION values. The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-session-temp-tablespaces-table.html
Session temporary tablespaces are recreated each time the server is started. The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. The ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-introduction.html
Other terms that are sometimes used for this information are data dictionary and system catalog. Performance Considerations INFORMATION_SCHEMA queries that search for information from more than one database might take a long time and impact ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-triggers-table.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG The ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-views-table.html
IS_UPDATABLE MySQL sets a flag, called the view updatability flag, at CREATE VIEW time. You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs.
https://dev.mysql.com/doc/refman/9.7/en/innochecksum.html
To turn on verbose mode, run: innochecksum --verbose To turn off verbose mode, run: innochecksum --verbose=FALSE The --verbose option and --log option can be specified at the same time. This tool reads an InnoDB tablespace file, calculates the ...