Search Results
https://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...ibd2sdi can be used at runtime or while the server is ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-model-export.html
You can then use SHOW_CREATE_TABLE to view information on the table for the exported model. Use the ML_MODEL_EXPORT routine to export a model from the model catalog to a user defined table. ML_MODEL_EXPORT Overview After you run ML_MODEL_EXPORT, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-quickstart.html
This creates an asynchronous task in the background which loads the vector embeddings into the specified vector store table quickstart_embeddings. Learn how to create a DB System and edit a DB System in Oracle Cloud Infrastructure (OCI). It analyzes ... This quickstart shows how to set up a GenAI-powered Help Chat that uses the information available in MySQL HeatWave User Guide to provide answers to MySQL HeatWave-related ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-client-commands.html
Since there is currently no way using ndb_mgm or the mysql client to remove all data from a specific data node or node group, this means that the command succeeds only in the two following cases: After issuing CREATE NODEGROUP in the ndb_mgm client, ...Commands for the event logs are given in Section 25.6.3, “Event Reports Generated in NDB Cluster”; commands for creating backups and restoring from them are provided in Section 25.6.8, “Online Backup of NDB ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-handleractivity-category.html
Table 6.8 Handler Activity Metrics NameDescriptionCommit (Delta) The number of internal COMMIT statements. Delete (Delta) The number of times that rows have been deleted from tables. External Lock (Delta) The server increments this variable for each ... Lists the Handler Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-unload.html
Unload Advisor recommends tables to unload, reducing MySQL HeatWave memory usage. The recommendations are based upon when the tables were last queried. Run Unload Advisor For Advisor to recommend tables to unload, the tables must be loaded in MySQL ...To enable Unload Advisor, specify the auto_unload option in recommend ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-cluster-unload-advisor.html
Unload Advisor 9.1.1 Unload Advisor Unloading tables from the MySQL HeatWave Cluster that have not been queried recently can free up memory for other tables and allow for a better use of available resources. To help identify unused tables in the ...
https://dev.mysql.com/doc/refman/8.4/en/any-in-some-subqueries.html
The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if table t2 contains (20,10), or if table t2 is empty. The expression is unknown (that is, NULL) if table t2 ...When ...
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...So, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl.html
The online DDL feature provides support for instant and in-place table alterations and concurrent DML. Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for ...For in-place operations, the ability to adjust the balance between performance and concurrency during DDL operations using the LOCK ...