Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
The rpd_query_stats table has these columns: CONNECTION_ID The ID of the connection. The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave plugin in JSON format. For MySQL HeatWave AutoML ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
This topic describes how to use the EXPLAIN statement to analyze query execution and verify whether a query is offloaded to MySQL HeatWave for accelerated processing. To learn how to download the sample database, see AirportDB Analytics Quickstart.
https://dev.mysql.com/doc/heatwave/en/mys-hw-select.html
This topic provides information related to the SELECT statement clauses supported in MySQL HeatWave and describes how to use the GROUP BY and QUALIFY clauses to group or filter the processing results. Verify if the query is offloaded to MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-silos.html
What's Next Learn about accessing, managing, and connecting to MySQL HeatWave. Figure 1.3 MySQL HeatWave Features MySQL HeatWave MySQL HeatWave is ideal for data warehousing, real-time analytics, mixed workloads, transactional processing, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-using-views.html
This topic describes how to run queries on views using MySQL HeatWave and verify if those queries are offloaded to the MySQL HeatWave secondary engine for accelerated processing. Verify if the query is offloaded to MySQL HeatWave for processing. To ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-generate-explanation.html
You can use the session variable for the model that is valid for the duration of the connection. After training a classification model, you can query the default model explanation or query new model explanations. Explanations help you understand ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-generate-prediction.html
You can use the session variable for the model that is valid for the duration of the connection. To generate predictions, use the sample data from the testing_data dataset. Even though the table has labels for the Approved target column, the column ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-overview.html
Prepare Data To prepare the data for the classification model: Connect to your MySQL HeatWave Database System. This topic describes how to prepare the data to use for a classification machine learning model. The classification use-case is to ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-score.html
You can use the session variable for the model that is valid for the duration of the connection. After generating predictions and explanations, you can score the model to assess its reliability. For a list of scoring metrics you can use with ...