Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics columns. This can have values A (ascending), D (descending), or NULL (not sorted). The ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/information-schema-user-attributes-table.html
Additionally, if the account has the CREATE USER privilege but not the SYSTEM_USER privilege, it can see rows for all other accounts that do not have the SYSTEM_USER privilege. The USER_ATTRIBUTES table provides information about user comments and ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-view-routine-usage-table.html
You can see information only for views for which you have some privilege, and only for functions for which you have some privilege. The VIEW_ROUTINE_USAGE table provides access to information about stored functions used in view definitions. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-view-table-usage-table.html
You can see information only for views for which you have some privilege, and only for tables for which you have some privilege. The VIEW_TABLE_USAGE table provides access to information about tables and views used in view definitions. The ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
You do not have to specify the --no-check option if the current checksum is valid. This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
This includes single-row and multiple-row INSERT and REPLACE statements that do not have a nested subquery, but not INSERT ... Such a statement behaves differently in lock modes 0, 1, and 2. InnoDB provides a configurable locking mechanism that can ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-flushing.html
Dirty pages are those that have been modified but are not yet written to the data files on disk. Only consider increasing the value if you have spare I/O capacity under a typical workload. InnoDB performs certain tasks in the background, including ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
ERROR 1031 (HY000): Table storage engine for 't1' doesn't have this option Note The table is not created if the current configuration does not permit using compressed tables. To import the dump file into a new database, and have the tables ... This ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
If you use the keyring_okv or keyring_aws plugin, ensure that you have performed the necessary configuration. A table must have the same encryption setting as the general tablespace it resides in. InnoDB supports data-at-rest encryption for ...