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-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-extensions-table.html
The TABLES_EXTENSIONS table (available as of MySQL 8.0.21) provides information about table attributes defined for primary and secondary storage engines. The TABLES_EXTENSIONS table has these columns: TABLE_CATALOG The name of the catalog to which ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tablespaces-extensions-table.html
The TABLESPACES_EXTENSIONS table (available as of MySQL 8.0.21) provides information about tablespace attributes defined for primary storage engines. The TABLESPACES_EXTENSIONS table has these columns: TABLESPACE_NAME The name of the tablespace.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tablespaces-table.html
It is deprecated; expect it to be removed in a future MySQL release. Other INFORMATION_SCHEMA tables may provide related information: For NDB, the INFORMATION_SCHEMA FILES table provides tablespace-related information. For InnoDB, the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-privileges-table.html
The USER_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the global level; see Section 15.7.1.6, “GRANT ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-view-routine-usage-table.html
The VIEW_ROUTINE_USAGE table (available as of MySQL 8.0.13) provides access to information about stored functions used in view definitions. The table does not list information about built-in (native) functions or loadable functions used in the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-view-table-usage-table.html
The VIEW_TABLE_USAGE table (available as of MySQL 8.0.13) provides access to information about tables and views used in view definitions. You can see information only for views for which you have some privilege, and only for tables for which you ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema.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/innodb-buffer-pool-optimization.html
Knowing how the InnoDB buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL tuning. InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory.
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-background.html
For extracting or updating the column values, MySQL also creates an uncompressed page in the buffer pool with the uncompressed data. Because processors and cache memories have increased in speed more than disk storage devices, many workloads are ...