Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
When a user-created NDB table is accessed using a unique index, the hidden index table is first read to find the primary key that is then used to read the user-created table. When a row referenced by a unique index in the user-created NDB table is ...NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
If the actual data dictionary version is lower than the current expected version, the server creates data dictionary tables with updated definitions, copies persisted metadata to the new tables, atomically replaces the old tables with the new ones, ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-exec-stats-table.html
The rpd_exec_stats table stores query execution statistics produced by MySQL HeatWave nodes in JSON format. One row of execution statistics is stored for each node that participates in the query. For MySQL HeatWave AutoML routines that include ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave plugin in JSON format. The rpd_query_stats table has these columns: CONNECTION_ID The ID of the connection. For MySQL HeatWave AutoML ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-column-statistics-table.html
The COLUMN_STATISTICS table provides access to histogram statistics for column values. For information about histogram statistics, see Section 10.9.6, “Optimizer Statistics”, and Section 15.7.3.1, “ANALYZE TABLE Statement”. The ...You can ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-keywords-table.html
The KEYWORDS table lists the words considered keywords by MySQL and, for each one, indicates whether it is reserved. This table provides applications a runtime source of MySQL keyword information. Reserved keywords may require special treatment in ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-role-column-grants-table.html
The ROLE_COLUMN_GRANTS table provides information about the column privileges for roles that are available to or granted by the currently enabled roles. The ROLE_COLUMN_GRANTS table has these columns: GRANTOR The user name part of the account that ...GRANTOR_HOST The host name part of the account that granted the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tablespaces-extensions-table.html
The TABLESPACES_EXTENSIONS table 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.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. The VIEW_ROUTINE_USAGE ...You can see information only for views for which you have some privilege, and only for functions for which you have some ...