Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-table.html
If you specify the output table and the input table as the same name, the predictions are inserted into the input table. ML_PREDICT_TABLE generates predictions for an entire table of trained data. Depending on your MySQL version, we recommend the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-test-split.html
MySQL 9.4.1 introduces the TRAIN_TEST_SPLIT routine, which automatically splits your data into training and testing datasets. Two new tables in the same database are created with the following names: [original_table_name]_train ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-6-0.html
This update enables users to efficiently merge new data from CSV files with existing data in the table, leveraging a temporary duplicate table and parallel readers to compare and insert records in the appropriate order. Note These release notes ...
https://dev.mysql.com/doc/heatwave-aws/en/autopilot-index-advisor.html
Indexes can improve query performance of SELECT statements, but managing the indexes increases the overhead of INSERT, UPDATE, and DELETE statements. Autopilot Index Advisor 11 Autopilot Index Advisor Autopilot Index Advisor provides secondary ...
https://dev.mysql.com/doc/heatwave-aws/en/database-vector-store.html
MySQL HeatWave GenAI In-database Vector Store 14.3 MySQL HeatWave GenAI In-database Vector Store The automated, in-database vector store enables customers to use MySQL HeatWave GenAI with their business documents without moving data to a separate ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-cloudwatch-metrics.html
dbSystemId Detailed mysql.stats.handler.write Count The number of requests to insert a row in a table. CloudWatch Monitoring Metrics 17.1.1 CloudWatch Monitoring Metrics CloudWatch metrics can be used to monitor resources, diagnose issues, and ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
Creating Lakehouse Mapping 9.2 Creating Lakehouse Mapping For MySQL HeatWave Lakehouse to process data in Amazon S3, it needs to first map the data in files on S3 to a MySQL HeatWave Lakehouse table. Once the S3 data is provided, the schema for the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-connection.html
"affected rows" for DML statements, but does cause correct update counts from "INSERT ... connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-prepared-statements.html
Default Value true Since Version 3.1.12 useServerPrepStmts Use server-side prepared statements if the server supports them? The server may limit the number of prepared statements with 'max_prepared_stmt_count' or disable them altogether. In case of ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-result-sets.html
clobberStreamingResults This will cause a streaming result set to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.