Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html
Before loading a table into MySQL HeatWave, exclude the columns with unsupported data types. For a list of data types that MySQL HeatWave supports, see Section 4.2.1, “Supported Data Types for MySQL HeatWave”. With MySQL version 8.2.0 or ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-table.html
For MySQL 9.4.1 and later, if ML_PREDICT_TABLE takes a long time to complete, manually limit input tables to a maximum of 1,000 rows. Depending on your MySQL version, we recommend the following: Before MySQL 9.4.1, limit operations to batches of ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location VARCHAR(100), purchase_amount DECIMAL(10, 2), purchase_time DATETIME, target INT ); Insert the sample data to train ...Prepare Data for a Semi-Supervised Anomaly Detection Model The semi-supervised anomaly detection model (available as of MySQL 9.0.1-u1) looks for unusual patterns in credit card ... This topic ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-limitations.html
Only a single MySQL instance can be cloned at a time. The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. For example, you cannot clone between MySQL 8.0 and MySQL 8.4, but can clone ...MyISAM and CSV tables stored in any schema including the sys schema are cloned as empty ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
The same word can occur several times within the cache table, once for each combination of DOC_ID and POSITION values. The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set ...
https://dev.mysql.com/doc/refman/8.4/en/replication.html
MySQL 8.4 also supports delayed replication such that a replica deliberately lags behind the source by at least a specified amount of time; see Section 19.4.11, “Delayed Replication”. Replication enables data from one MySQL database server ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, and mysqldump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect to MySQL.
https://dev.mysql.com/doc/c-api/8.4/en/c-api-data-structures.html
Do not try to make a copy of a MYSQL structure. MYSQL_RES This structure represents the result of a query that returns rows (SELECT, SHOW, DESCRIBE, EXPLAIN). MYSQL_ROW This is a type-safe representation of one row of data. (You cannot treat these ... This section describes C API data structures other than those used for prepared statements, the asynchronous interface, or the replication stream ...
https://dev.mysql.com/doc/workbench/en/wb-design-modeling-interface.html
MySQL Workbench represents each active data model as an icon in the models view of the home screen tab. Both models derive from MySQL database samples (see https://dev.mysql.com/doc/index-other.html), which you can download and use to explore the ...Figure 9.1 Data Models on the Home Screen The sakila database sample includes a model file (sakila.mwb) in the product ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-configuration-properties.html
Configuration properties define how Connector/J will make a connection to a MySQL server. Unless otherwise noted, properties can be set for a DataSource object or for a Connection object. If you specify a configuration property in the URL without ...