Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collections-as-relational-tables.html
Applications that seek to store standard SQL columns with Documents can cast a collection to a table. In this case a collection can be fetched as a Table object with the Schema.getCollectionAsTable() function. From that moment on it is treated as a ...Document values can be accessed in SQL CRUD operations using the following syntax: doc->'$.field' doc->'$.field' is used to access the document top level ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-index-advisor-report-table.html
When Autopilot Indexing runs, it sends detailed output to the autopilot_index_advisor_report table in the sys schema. The autopilot_index_advisor_report table is a temporary table that contains data from the last execution of Autopilot Indexing.
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-column-id-table.html
The rpd_column_id table provides information about columns of tables that are loaded in MySQL HeatWave. The rpd_column_id table has these columns: ID A unique identifier for the column. TABLE_ID The ID of the table to which the column belongs.
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-nodes-table.html
The rpd_nodes read-only table provides information about MySQL HeatWave nodes. The table may not show the current status for a new node or newly configured node immediately. The rpd_nodes table is updated after the node has successfully joined the ...CORES The number of cores used by the MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-connection-control-failed-login-attempts-table.html
This table provides information about the current number of consecutive failed connection attempts per account (user/host combination). Notes The CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin must be activated for this table to be available, and ...CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS has these columns: USERHOST The user/host combination indicating an account that has failed connection attempts, in 'user_name'@'host_name' ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-engines-table.html
The ENGINES table has these columns: ENGINE The name of the storage engine. SUPPORT The server's level of support for the storage engine, as shown in the following table. This is particularly useful for checking whether a storage engine is ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-mysql-firewall-users-table.html
The MYSQL_FIREWALL_USERS table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_users system table that provides persistent storage of firewall data; see MySQL Enterprise ...It lists names and operational modes of registered firewall account ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-mysql-firewall-whitelist-table.html
The MYSQL_FIREWALL_WHITELIST table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_whitelist system table that provides persistent storage of firewall data; see MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-profiling-table.html
The table is empty unless the profiling session variable is set to 1. Note This table is deprecated; expect it to be removed in a future MySQL release. The PROFILING table has these columns: QUERY_ID A numeric statement identifier. Its contents ...