PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
If cached statistics are not available or have expired, MySQL retrieves the latest statistics from the storage engine and caches them in the mysql.index_stats and mysql.innodb_table_stats dictionary tables. Querying statistics columns does not store ... Applications that monitor databases may make frequent use of INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/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.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 Introduced Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS ...
https://dev.mysql.com/doc/refman/8.0/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 (available as of MySQL 8.0.21) provides ...
https://dev.mysql.com/doc/refman/8.0/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 (available as of MySQL 8.0.13) provides access to information about stored functions ...
https://dev.mysql.com/doc/refman/8.0/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 (available as of MySQL 8.0.13) provides access to information about tables and views used in ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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 ...