Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-a-forecasting-model.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE forecasting_data; mysql> USE forecasting_data; ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-channel-details.html
The target DB System is Inactive, that is, the Channel is created or updated while the DB System is in Inactive state. Resource ID: The unique resource identifier assigned to the Channel when it is created. Table without primary key: How the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-deploying-egress-privatelink.html
To allow your DB System to connect to an endpoint in your AWS account using a private network path, you first configure your account’s network infrastructure and then create an Egress PrivateLink inside MySQL HeatWave on AWS. During the creation ... Deploying an Egress PrivateLink 6.2 Deploying an Egress PrivateLink Overview Certain features like inbound replication require egress connections from your MySQL HeatWave on AWS DB System to your AWS ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-server-compatibility.html
loadDump command only allows import of dumps created with the ocimds option enabled. This option modifies the ENGINE= clause of CREATE TABLE statements to specify INNODB for tables that do not already use the InnoDB storage engine. MySQL Server ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-functions.html
create_digest(digest_type, str) Creates a digest from the given string using the given digest type, and returns the digest as a binary string. MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
To specify this, use the ENGINE=NDBCLUSTER or ENGINE=NDB option when creating the table: CREATE TABLE tbl_name (col_name column_definitions) ENGINE=NDBCLUSTER; Alternatively, for an existing table that uses a different storage engine, use ALTER ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used in creating a partitioned table. A new row event is created for a modification that takes place in a different ... This section discusses obtaining information about existing partitions, which can be done in a number of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-invoked.html
The following statements are replicated using statement-based replication: CREATE EVENT ALTER EVENT DROP EVENT CREATE PROCEDURE DROP PROCEDURE CREATE FUNCTION DROP FUNCTION CREATE TRIGGER DROP TRIGGER However, the effects of features created, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...GTID_SUBTRACT(): Returns the GTIDs from one GTID set that are not in ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
Because local variables are in scope only during stored program execution, references to them are not permitted in prepared statements created within a stored program. An event may not be created from within a stored program. An event also may not ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...