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-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. This information is used when populating the server_operations and ...
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 Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
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 ...