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/host-cache.html
The server stores information about the result of this operation in the host cache. The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. The Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html
During DDL operations, ROLLBACK operations, and undo log purge operations related to SDI, there may be a short interval of time when ibd2sdi fails to read SDI data stored in the tablespace. ibd2sdi is a utility for extracting serialized dictionary ...
https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
Systems that rely on this type of single-value lookup are known as “key-value stores”; to use MySQL for such applications, use hash indexes wherever possible. Understanding the B-tree and hash data structures can help predict how different ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-character-sets-table.html
MAXLEN The maximum number of bytes required to store one character. The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name. Notes Character set information is also available from the SHOW CHARACTER SET statement. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-column-statistics-table.html
HISTOGRAM A JSON object describing the column statistics, stored as a histogram. The COLUMN_STATISTICS table provides access to histogram statistics for column values. For information about histogram statistics, see Section 10.9.6, “Optimizer ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. The INNODB_SESSION_TEMP_TABLESPACES table has these columns: ID The process or session ID. A range ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Querying statistics columns does not store or update statistics in the mysql.index_stats and mysql.innodb_table_stats dictionary tables under these circumstances: When cached statistics have not expired. Applications that monitor databases may make ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimizer-trace-table.html
INSUFFICIENT_PRIVILEGES If a traced query uses views or stored routines that have SQL SECURITY with a value of DEFINER, it may be that a user other than the definer is denied from seeing the trace of the query. The OPTIMIZER_TRACE table provides ...