Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
This topic describes how to prepare your data for loading into MySQL HeatWave. You can manually convert tables by using the following ALTER TABLE statement: mysql> ALTER TABLE tbl_name ENGINE=InnoDB; The tables you intend to load must be defined ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-nl2ml.html
MySQL 9.4.0 introduces the NL2ML (natural language to machine learning) routine, which provides step-by-step guidelines on using MySQL HeatWave AutoML for a particular business problem. Use this routine to ask general questions about MySQL HeatWave ...Note Oracle Cloud Infrastructure Generative AI is available in specific ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. This topic contains the following sections: ML_EMBED_TABLE Syntax Syntax Examples ... The ML_EMBED_TABLE routine runs multiple embedding generations in a batch, in ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-groups.html
Groups and Permissions 20.1 Groups and Permissions MySQL HeatWave on AWS has three predefined groups. Table 20-1 Table 20-2 Table 20-3 Note: The OCI user account that registered for the MySQL HeatWave on AWS service is added to the ...The ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
MySQL also supports setting the histogram of a single column to a user-defined JSON value. MySQL uses the stored key distribution to decide the order in which tables should be joined for joins on something other than a constant. In the few cases ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
Local Versus Remote Backups A local backup is performed on the same host where the MySQL server runs, whereas a remote backup is done from a different host. Physical backup methods typically are initiated locally on the MySQL server host so that the ...Typically this is a copy of all or part of the MySQL data ... This ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
Passwords in statements written to the binary log are rewritten by the server not to occur literally in plain text. MySQL binary log files and relay log files can be encrypted, helping to protect these files and the potentially sensitive data ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
This option can be applied to any blob column type supported by MySQL except TINYBLOB or TINYTEXT (BLOB, MEDIUMBLOB, LONGBLOB, TEXT, MEDIUMTEXT, LONGTEXT). Using MAX_ROWS to force the number of partitions is deprecated but continues to be supported ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
SET GLOBAL innodb_monitor_reset_all = [counter-name|module_name|pattern|all]; Counters and counter modules can also be enabled at startup using the MySQL server configuration file. For example, to enable the log module, metadata_table_handles_opened ... The INNODB_METRICS table provides information about InnoDB performance and resource-related ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-hashicorp-plugin.html
Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial product. No key information is permanently stored in MySQL server local storage. (An optional in-memory key cache may be used as intermediate ...