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-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
Typically this is a copy of all or part of the MySQL data directory. Because backup speed and compactness are important for busy, important databases, the MySQL Enterprise Backup product performs physical backups. For an overview of the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
MySQL binary log files and relay log files can be encrypted, helping to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from unauthorized viewing by users of the operating ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... The ...Certain ...