Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-role-table-grants-table.html
The ROLE_TABLE_GRANTS table provides information about the table privileges for roles that are available to or granted by the currently enabled roles. The ROLE_TABLE_GRANTS table has these columns: GRANTOR The user name part of the account that ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-schema-privileges-table.html
The SCHEMA_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the schema belongs. The value can be any privilege ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-thread-pool-table-reference.html
Table 28.7 INFORMATION_SCHEMA Thread Pool Tables Table Name Description TP_THREAD_GROUP_STATE Thread pool thread group states TP_THREAD_GROUP_STATS Thread pool thread group statistics TP_THREAD_STATE Thread pool thread information .
https://dev.mysql.com/doc/refman/8.4/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.4/en/information-schema-view-routine-usage-table.html
The VIEW_ROUTINE_USAGE table 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 definitions. You can see ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-view-table-usage-table.html
The VIEW_TABLE_USAGE table 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 have some privilege. The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-adaptive-hash.html
The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient memory for the buffer pool without sacrificing transactional features or reliability. The adaptive ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-architecture.html
The following diagram shows in-memory and on-disk structures that comprise the InnoDB storage engine architecture. For information about each structure, see Section 17.5, “InnoDB In-Memory Structures”, and Section 17.6, “InnoDB On-Disk ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-flushing.html
InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer pool. Dirty pages are those that have been modified but are not yet written to the data files on disk. The number of page cleaner threads is ...